View Complete Post
I want to add multiple rows of a gridview if the data for multiple fields are same.
Idea for this is that a user may search a record with some parameter e.g. Sector, plot.
For example 15 records being displayed in gridview.
There should be checkbox before every row and if user wants to update Plot and Flat No that is same for 10 rows out of 15 so he will check the rows and update.
For this a dialog box should appear asking for the parameter i.e. Plot and Flat or something else next time may be it will be City or country. Moreover, there is already an Edit button to update records, when user click it another page open for the record to be updated and whatever he wants to update, it updates.
Hope everone understand the scenario.
I don't want to disturb the already provided Edit functionality and want to provide same record to be updated.
Any idea in this regard would be appreciated.
I want to set up a gridview that will display data like this
WeekEndingDate Project Category Sun Mon Tues Wed Thu Fri Sat8/14/2010 proj1 test 2 1 2 3 2 1 0 8/21/2010 proj1 test 0 2 2 2 2 1 0 8/28/2010 proj1 test 0 1
I need to insert/update data to 3 or more tables on a single button click.What is best method for achieving this?I am using mysql as my DB.
Thanks for your valuable reply in advance.
Is it possible to issue multiple sql server update statements in SSIS OLE DB Command?
I Tried the following with no luck
update table1 set column1 = 1
update table2 set column1 = 1
I am trying to explain with example what i want to do. I have a table that has names and surnames of people. Some of names are null in table and i know its number. I want to update null values but i want to give to every row different names not updating
with single name.
Can i update these two records with names of 'ahmet' and 'yasir' within one single update statement
I hope i could explain my question. Any help would be so appreciated.
I have search input on my web page txtSearch.text(Column name is JobNO ,this column present in all the 3 tables), when i submit a value click on search button it has to read 3 tables.is it appropriate writing 3 queries in if condition..something like follows but not sure of it
if txtSearch.text<>"" thenQuery=select * from ship elseif txtSearch.text<>"" thenQuery=select * from openorderelseQuery=select * from scheduleend if
when i give above input it should read 3 tables and write the value on grid view,i am held up here and thankful to you can any one provide the possible solution
I've written a trigger that fires on a table after an insert and SHOULD update the destination table if a record exists or performs an insert if the record doesn't exist. I'm having trouble because in some instances it won't run because the subquery
is returning multiple rows from the INSERTED table. Code is below. Any help is greatly appreciated.
CREATE TRIGGER [dbo].[InsertOverflowHistory_Trigger]
SET NOCOUNT ON;
DECLARE @DCID INT;
DECLARE @ScheduledShipDate SMALLDATETIME;
DECLARE @Store NCHAR(5);
DECLARE @ItemWeight DECIMAL(12,4);
DECLARE @ItemCube D
Hey ASP Guru's,
I am working on a form that has a det
Currently running SQL 2005 sp2 SSRS. We were in the process of tuning a report's queries against DB2 when our DBA noticed in the tracing log that the queries used for the parameter list is ran 2 times for each parameter. They are cascading parameters
with a Date only, but we tested removing the dependancy and the parameter query still ran 2 times. We tested setting all the default values for initially opening the report and after we just opened the report and it rendered, nothing else was touched,
the parameter queries all ran 2 times. Any idea of why this happens. I tried to search for this and couldn't find anything.
I need a suggestion from you masters on performance and the best method for the kind of queries I have written.
I have pretty big UPDATE and INSERT queries like
I Want to build a page in which there are two text boxes and a drop down list....
Depending on the value of textbox and drop down list i am trying to get values from database....which checks for several roll number...
I want to count few roll numbers say 20 (in my form it depends on the values of text box and drop down list )whose status is loggen in that is i have set it in my database as (1) and the update panel should continously check whether all the 20 roll numbers have logged in or not....and if it gets the count correct a button is placed in the form named...BtnStart which should be enabled...i have tried a lot..gone through many websites for update panel but was unable to sort out the problem....can anyone give me a good suggestion to create this form...or can anyone tell me how to do this ....
And inside the update panel i want to get all the roll numbers whose status is logged in either in grid view or any other good control...
i am developing the application in vb.net so plz try to post the vb code...or else c# code...
Hope will get a good suggestions...
Have a nice day friends :)