One without a body, apparently. Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

sritha wrote: object reference is not set to an instance of an object Did you debug your code? Where are you getting the error ? Does that object initialize? cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net

hi you can use this simple code String conString="data source=localhost\SQLEXPRESS;initial catalog=New;integrated security=true"; SqlConnection cn = new SqlConnection(conString); SqlCommand cmdFillGrid = new SqlCommand("select * from myTable", cn); SqlDataAdapter adapter = new SqlDataAdapter(cmdFillGrid); DataSet ds = new DataSet(); adapter.Fill(ds, "myTable"); GridView1.DataSource = ds.Tables["myTable"]; GridView1.DataBind(); Essam Moustafa

You can use Custom Validator and in that you can have Javascript code or server side code too. It is upto you. Regards, Kaushal Arora

Hi Sritha, You could use a custom validator to do this, this might help[^].

First of all your post is looks like Crap. sritha wrote: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Did you tried to google it ? This is one of the most common error for connecting with SQL server . Which SQL Server Version are you using? cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net

You seriously think we can help you based on this ? The answer is, check the size of the array before you try to access it, learn to use your debugger, and try to post actual code when you ask for help. If you'd posted code and a real explanation, I'd almost certainly be able to help more. Christian Graus Driven to the arms of OSX by Vista.