Hi Christian, Thanks a lot for your time in reading my post and replying to it. I'm still struggling with populating the header of the gridview from the table. My table structure is : ____________________ PhaseId PhaseName ____________________ 1 Scope Closure 2 Functional Design 3 Techical Design 4 Alpha Testing 5 Beta Testing 6 UAT In the header of the gridview I need: =================================================================================================== TemplateHeader1 | TemplateHeader2 | Scope Closure | Func. Design | Tech Design | Alpha | Beta | UAT ==================================================================================================== TeamplateHeader1 & TemplateHeader2 are template columns for checkbox and label. Scope Closure onwards come from the table. Also, The colors for the cells from 'scope Closure' to 'UAT' have to come from the PhaseColor table depending upon the status of phase e.g. AtRisk=Red color, OnTrack=green color etc... first two Template columns and their cells have to stay white or whatever the grids background color is. Is gridview right for such functionality?or is there another alternative to it? In classic ASP the previous person has used elements to achieve the desired result. Thanks for your help once again. Aartee. ...HE is watching Us All!

Use radio or have a JavaScript function to uncheck. Vasudevan Deepak Kumar Personal Homepage Tech Gossips

Thanks MArk, it has worked finally, you were thinking right, just that I had to use 'Is System.DBNull.Value' in place of '==' or '='. Thanks a ton for your solution, it worked like magic. Aartee. ...HE is watching Us All!

Hi there: This article NewRowGridView might help you... << >>

The only problem what I can guess is some ID(which you are inserting in the second table as a foreign key) does not belong to the first table(i.e. ID not there in the first table). Can you check them again? Best Regards, Apurva Kaushal

Since this is a bit column you need the default value to be 0 which is false and then you would avoid this. Also if you dont want a default value, create a Protected Function in the code behind and pass the value from the Datagrid DB value and accept it as an Object, check for DBNull and if it is return a 0/False whatever works. Cleako

Hi Pratibha, Thankyou for your Reply.Yes the datagrid is connected to the database. so as per your solution it also means I will need to introduce EOMRate as a new field in the datatable right? or maybe I don't need to and then I can calculate the buyamt and sellamt in the code behind the 'Calculate' button and call Refreshgrid() which will display the new values. So I do not really need to touch the datagrid(geeee that's great!) well, it does sound quite straightforward...I will go ahead with this solution and see how it works. Thanks a lot. Aartee. ...HE is watching Us All!

use the custom validator - private void CustomValidator1_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args) { if ( !dropdown.SelectedIndex == 0 ) args.IsValid = false; }

Yeah well...I thought so, but thanks for confirming my doubts..it will be easier for me to expalin to my manager now that we are not miracle churners to make anything they want happen :-D. Thanks a ton Aartee. ...HE is watching Us All!

all that the database is saving each time is '0.00000' and '1.00000' You might have referenced the wrong control, or you are losing the control handle on postback of the page. If you can give a small sample code containing your Textboxes and Database update we might be able to help you more on this. Ed -- modified at 3:03 Monday 19th September, 2005 [Edit]Also, posting in ASP.Net forum might be better.[/Edit]

Thanks guys, I initialised the values of the variables and Bingo!thanks for all the help. Aartee. ...HE is watching Us All!

Eureka!!! I got it... Aartee. ...HE is watching Us All!

That would explain it. If you don't close the connection, the number of connections being used on the SQL server increases until it hits the license limit. Then you next connection request will hang until a previous connection is closed, thereby causing the timeout. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

arty=me wrote: Does someone/anyone have a ready code(or open source code) for a Page Hit Counter?( No, but it's really, really easy. Where-ever you store the count, you just need to increment it every time the page is hit, and it's not a postback. It's up to you if you put it in a text file, or if you have a database already where you can put it. arty=me wrote: Also, does anyone know of a free downloadable 'search engine' for .NET applications that can be included onto the company intranet system? If the intranet is not online, I don't know, but if you have a web site that is online, you can do links to google that search only your site. Given that google are rich, I assume that writing a search engine is not trivial. Christian Graus - Microsoft MVP - C++