data grid
-
Hi all, i m using data grid(asp.net2003 code behind lang=c#) and i m takin templet column and i want 2 edit,update, delete my records... i have written followin code conn.Open(); cmd.Connection=conn; SqlDataAdapter da = new SqlDataAdapter("select * from leave_master",conn); try { da.Fill(ds,"myTable"); } catch(Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } if (!IsPostBack) { BindGrid(); } DGLeaveMaster.DataSource =ds; DGLeaveMaster.DataBind(); } private void DGLeaveMaster_SelectedIndexChanged(object sender, System.EventArgs e) { } public void BindGrid() { DGLeaveMaster.DataSource=ds; DGLeaveMaster.DataBind(); } public void DGLeaveMaster_Cancel(Object sender, DataGridCommandEventArgs e) { DGLeaveMaster.EditItemIndex=-1; BindGrid(); } public void DGLeaveMaster_Edit(Object sender, DataGridCommandEventArgs e) { DGLeaveMaster.EditItemIndex=(int)e.Item.ItemIndex; BindGrid(); } But it cant show records! -----
-
Hi all, i m using data grid(asp.net2003 code behind lang=c#) and i m takin templet column and i want 2 edit,update, delete my records... i have written followin code conn.Open(); cmd.Connection=conn; SqlDataAdapter da = new SqlDataAdapter("select * from leave_master",conn); try { da.Fill(ds,"myTable"); } catch(Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } if (!IsPostBack) { BindGrid(); } DGLeaveMaster.DataSource =ds; DGLeaveMaster.DataBind(); } private void DGLeaveMaster_SelectedIndexChanged(object sender, System.EventArgs e) { } public void BindGrid() { DGLeaveMaster.DataSource=ds; DGLeaveMaster.DataBind(); } public void DGLeaveMaster_Cancel(Object sender, DataGridCommandEventArgs e) { DGLeaveMaster.EditItemIndex=-1; BindGrid(); } public void DGLeaveMaster_Edit(Object sender, DataGridCommandEventArgs e) { DGLeaveMaster.EditItemIndex=(int)e.Item.ItemIndex; BindGrid(); } But it cant show records! -----
-
Did you forget to instantiate the DataSet? DataSet ds = new DataSet(); Practice sesquipedalianism! ;)