I have corrected my statement and this time I'm getting this error: "Object reference not set to an instance of an object." And the error source: Line 219: myCommand.CommandText="select * from dbo.DashBoard where Name Like @Billing"; Line 220: myCommand.Parameters.Add(new SqlParameter("@Billing",SqlDbType.VarChar,50)); Line 221: myCommand.Parameters["@Billing"].Value= bc.Text; Line 222: SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand); Line 223: DataSet ds = new DataSet(); This is my code: My code behind: private void dgoperation_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { System.Web.UI.WebControls.LinkButton bc=new System.Web.UI.WebControls.LinkButton(); bc=(System.Web.UI.WebControls.LinkButton)e.Item.Cells[0].FindControl("TeamB­illing"); SqlCommand myCommand=new SqlCommand(); myCommand.Connection=con; myCommand.CommandText="select * from dbo.DashBoard where Name Like @Billing"; myCommand.Parameters.Add(new SqlParameter("@Billing",SqlDbType.VarChar, 50)); myCommand.Parameters["@Billing"].Value= bc.Text; SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand); DataSet ds = new DataSet(); myAdapter.Fill(ds); dgis.DataSource=ds; dgis.EditItemIndex = -1; dgis.DataBind(); } How can I solve this? Thanks

Replace hyper link with this and write the code on datagrid item command & find the name from command Argument asp:LinkButton ID="lbtnName" Runat="server" Text="NAme" CommandArgument="Selected Name"/asp:LinkButto>" -- modified at 9:02 Friday 11th May, 2007

Hi Guffa, Been away for a while but I'm now back. What I ment by not working, when I select the hyperlinks text the semilar columns are not selected at all nothing changes. that's where my trouble is situated. Thanks.

Thanks Kubben, It's close to that only that it does not selects What the selected person wrote in the insert Datagrid. other wise now in the view source the URL looks like this: Claude Thanks.

The problem was actually in the code behind. But now I have solved it I was adding: InsertEmpty(); yet I was not supposed But now I'm facing another error after deploying it on server it works properly but when on the client side the user tries to insert data an error occurs: Exception Details: System.Runtime.InteropServices.COMException: The network path was not found Why would this happened. Thanks

Don't Repost. [^] Guffa has answered there ther may be a problem with Eval did you correct that one. Regards, Satips.

Why is it that when I insert data I fast get an error : Specified cast is not valid. But When I run it the second time I find the data was saved the right image was selected! Actually I can say every thing works well apart that when I atempt to insert data this error appears: Specified cast is not valid. on line: . Thanks

Do you want to save a picture into DB? << >> 8x Solutions Ltd

In sqlserver database. Thanks

TEXT : but you have to encode the image data to base64 (ie text). Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]

it seems strange :confused::confused:...try to re-install ISS and test the built-in website (iishelp page)...to see the result? Good luke << >> 8x Solutions Ltd

Hi, Thanks CLEAKO I won't do it again. Yo code Advice worked. Thanks again.

You are going to have to look at Active Directory to translate that value. This Google search may help some[^] CleaKO "I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy) "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

Thanks, But when I try the example on a new webform I get domain/username. But it's not inserted into the database my problem is getting it into the database I have a row where I want it to be saved so that every one can read who wrote a particular message. How should I do it. I have this code writen for the column: System.Web.UI.WebControls.TextBox st6=new System.Web.UI.WebControls.TextBox(); st6=(System.Web.UI.WebControls.TextBox)e.Item.Cells[0].FindControl("txtname"); myCommand.Parameters.Add(new SqlParameter("@Name",SqlDbType.Text)); myCommand.Parameters["@Name"].Value=st6.Text; Thanks.

varshavmane, I think this will help anderstand my problem is there a way The windows login can be saved automatically into database whenever a user uses the website? since I'm working with datagrid. Thanks

A datagrid that inserts data. I mean using edit,Update and cancel. It actually inserts data into SQlserver. But the inserting code is not the problem, my problem is I want to know Which ever user has inserted data. Like when some one login his computer and uses the datagrid I want the user name to be automatically in datagrid. Thanks