data grid lost!!!

Question

Hi I designed a datagrid that will get data from sqlserver but cannot See it after running my form. My form is running properly it's only the datagrid that is not appearing. I've put visible to true but no change what so ever. I'm using asp.net. thanx

Ndayahundwa Claude · Answer

Hi saravanan Thanx 4 helping but it does not work.

saravana kumar · Answer

hi just give autogenerated column=true in datagrid hope it will work regards saravanan

Ndayahundwa Claude · Answer

thank you ahamad I've got now the datagrid but know I have a problem with updating data of column one by one. when I do update one column all the clumn change. Idon't really know where I went wrong. this is the code I'm using to update: private void Update_dataGrid( object source System.Web.UI.WebControls.DataGridCommandEventArgs e) { System.Web.UI.WebControls.TextBox cstaff= new System.Web.UI.WebControls.TextBox(); cstaff=(System.Web.UI.WebControls.TextBox)e.Item.Cells[1].Controls[0]; SqlCommand myCommand= new SqlCommand(update isp_email.staff set stafflevel=@stafflevel where id=idcon); myCommand.Parameters.Add( new SqlParameter(@stafflevelSqlDbType.VarChar45)); myCommand.Parameters[@stafflevel].Value=cstaff.Text; con.Open(); myCommand.ExecuteNonQuery(); con.Close(); dgupdate.EditItemIndex=-1; BindData(); }

Parwej Ahamad · Answer

First set the properly datasource property. and then call DataGrid.Bind() method. it will be show. if u feel more trouble plz post here.......