naunt wrote: Please suggest how to update this without looping through all rows in DataTable1. There are no methods to update data in a DataTable in bulk AFAIK. You could, however, dump your datatable into a temporary table in Sql Server, do the update there, and merge after. Bastard Programmer from Hell :suss:

Thank you for your reply. Group By doesn't work for my case.

Yep - the error message is correct.... Try .add ing the table to the DataSet C# has already designed away most of the tedium of C++.

try something like this. start your transaction begin transaction a insert into tableA if(@@rowcount > 0) begin insert into tableB commit transaction a end else (@@error > 0) begin rollback transaction a end

Excellent, there is another potentially useful keyword I have never used (or knew about). Never underestimate the power of human stupidity RAH

Use Dropdownlistname.visible=false property like in aspx page if(!page.ispostback) { Dropdownlistname.visible=false; }

I don't know your data but you could try to get all your counts in one go using a CASE WHEN. The COUNT aggregates only non null values. SELECT @result1 = COUNT(CASE WHEN (isNull(TDR_D20,0)= 0 And isNull(TDR_D40,0)=0 ...) THEN 1 ELSE NULL END), @result2 = COUNT(CASE WHEN (isNull(TDR_D20,0)>0 Or isNull(TDR_H20,0)>0 ...) THEN 1 ELSE NULL END), @result3 = COUNT(CASE WHEN (isNull(TDR_D20,0)=0 AND isNull(TDR_H20,0)=0 ...)) THEN 1 ELSE NULL END) FROM table WHERE Vessel_Code=@Vsl AND Voyage_No=@Voy AND POL=@POL This would be efficient as you would only read your table once this way. Then the logic you can probably remove quite a bit of the begin end and it becomes (sometime) clearer. IF @result1 = 20 SET @Color='Red Color' Else IF @result2=20 SET @Color='Blue Color' Else IF @result3>0 SET @Color='Blue Color' Else IF @result4>0 SET @Color='Blue Color' Else IF @result5=20 SET @Color='Green Color' Else IF @result6>0 SET @Color='Yellow Color' Else @Color='Orange Color'

Many Thanks to Mycroft Holmes and Sujit0761 Both answer are work in order.

Thanks Mark Nischalke and Shameel I added a CustomValidator to the textbox and add ClientValidationFunction This is my solution to share with other people those who have problem as mine * ValidateEmptyText="True" also important here, if not control will not doing validation. function CheckPorts(sender, args) { var chk = document.getElementById('<%= CType(CreateUserWizardStep1.ContentTemplateContainer.FindControl("chkViewAll"), CheckBox).ClientID %>') if (args.Value == "" && chk.checked == false) { args.IsValid = false; } else { args.IsValid = true; } }

Caching ASP.NET Pages[^] thatraja **My Tip/Tricks My Dad had a Heart Attack on this day so don't... **

Thank you RaviSant.

I am not sure but hope this link[^] might help you to solve your problem.

Yusuf, thanks for your advise.

Try this code: You have to select each group from the table. Declare a new DataTable Temp, now select the group values or distinct value in this datatable by following code( I am using C# language.) DataTable TEMP = new DataTable(); TEMP=Dataset1.Table(0).DefaultView.ToTable(true,"Col4"); Now the TEMP table will have following values in it- 1. C 2. S Now you can use loop and DataSet.Compute("Sum(Qty)","Col4='"+TEMP.Rows[location][0].ToString()+"'") method for data stored in TEMP. You can not use DataSet.Compute() method for multiple values as it is a single value function. :-D :-D :-D :-D :-D :-D For any further clearification please mail me at cybosoft@gmail.com C#, VB.NET,ASP.NET DEVELOPER

Seems that you can't directly drop a remote table then. How about creating a sproc in the remote database that takes a tablename and drops it? Could that be called with the three prefixes? I are Troll :suss:

naunt wrote: lease help me how to make MasterPage know that connection? Connection is not a kind of thing to open in a base page and leave it! You need to read on SQLConnections [^]before coding further. Whenever needed, wherever needed, open the connection and have a finalize block to make sure you close the connection as soon the work is done.

Thank you for your reply. I am really really sorry for my uncomplete question. I am using SQL server 2000. @J4amieC, Thank you. Will try with "sp_addlinkedserver[^]".

naunt wrote: I want to keep selection of it wherever Page I have reach You need any of the state management techiniques that suits your application, Session/Basepage property being the best ones. Other's can be QueryString, HiddenField in basepage, Cookie, BasePage Property.

@Arun Jacob : Thank you for your suggestion ... Can fixed that problem now. By runing "aspnet_regiis - i" form right version. First time I did a wrong choice for version, I choose "aspnet_regiis.exe" from v2.0.50727 and run. Actually I am using version 4.0. After re-running "aspnet_regiis -i" from v4.0.30319 everythings going smoothly. Pls, don't mind me for long explain unnecessary, I just mean to people who face this problem in future. Just inform them to do right choice. Thanks and Best Regards