example of editing in DataGrid and Default Paging

[hanusoft]

This is an example of editing in DataGrid and Default Paging

http://www.hanusoftwar e.com

Html Design Code : -

<asp:DataGrid id="DataGrid1" DataKeyField="i d" runat="server" Height="224px" AutoGenerateCol umns="False" PageSize="5" AllowPaging="Tr ue">
<Columns>
<asp:BoundColum n Visible="False" DataField="id"
HeaderText="Cat egory Id"></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="Cat egory">
<ItemTemplate >
<asp:Label id=lblName text='<%# DataBinder.Eval (Container.Data Item,"name")%>' Runat="server">
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox id=txtEdit Runat="server" Text='<%# DataBinder.Eval (Container.Data Item,"name")%>' >
</asp:TextBox>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:EditComman dColumn ButtonType="Lin kButton" UpdateText="Upd ate" HeaderText="Edi t" CancelText="Can cel"
EditText="Edit" ></asp:EditCommand Column>
</Columns>
</asp:DataGrid>

Code (EditInDataGrid .aspx.cs) :

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
if(!IsPostBack)
{

BindGrid();
}
}
private void DataGrid1_EditC ommand(object source, System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
DataGrid1.EditI temIndex = e.Item.ItemInde x;
BindGrid();

}
private void BindGrid()
{
SqlDataAdapter da = new SqlDataAdapter( "select id,name from category",con);
DataSet objDS = new DataSet();
try
{
da.Fill(objDS," Cat");
if(objDS.Tables[0].Rows.Count != 0)
{
DataGrid1.DataS ource = objDS;
DataGrid1.DataB ind();
}
else
{
DataGrid1.DataS ource = null;
DataGrid1.DataB ind();

Response.Write( "No record found.");
}
}
catch(Exception ex)
{
throw ex;
}
}

private void DataGrid1_Updat eCommand(object source, System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
try
{
string strCatName = ((TextBox)e.Ite m.FindControl(" txtEdit")).Text ;
string strId = DataGrid1.DataK eys[e.Item.ItemInde x].ToString();
SqlCommand com = new SqlCommand("upd ate category set name ='"+strCatName+ "' where id = "+strId,con );
con.Open();
com.ExecuteNonQ uery();
DataGrid1.EditI temIndex = -1;
BindGrid();
}
catch(Exception ex)
{
throw ex;
}
}

private void DataGrid1_Cance lCommand(object source, System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
DataGrid1.EditI temIndex = -1;
BindGrid();
}

private void DataGrid1_PageI ndexChanged(obj ect source, System.Web.UI.W ebControls.Data GridPageChanged EventArgs e)
{
DataGrid1.Curre ntPageIndex = e.NewPageIndex;
BindGrid();
This is an example of editing in DataGrid and Default Paging

http://www.hanusoftwar e.com

Html Design Code : -

<asp:DataGrid id="DataGrid1" DataKeyField="i d" runat="server" Height="224px" AutoGenerateCol umns="False" PageSize="5" AllowPaging="Tr ue">
<Columns>
<asp:BoundColum n Visible="False" DataField="id"
HeaderText="Cat egory Id"></asp:BoundColumn >
<asp:TemplateCo lumn HeaderText="Cat egory">
<ItemTemplate >
<asp:Label id=lblName text='<%# DataBinder.Eval (Container.Data Item,"name")%>' Runat="server">
</asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:TextBox id=txtEdit Runat="server" Text='<%# DataBinder.Eval (Container.Data Item,"name")%>' >
</asp:TextBox>
</EditItemTemplat e>
</asp:TemplateCol umn>
<asp:EditComman dColumn ButtonType="Lin kButton" UpdateText="Upd ate" HeaderText="Edi t" CancelText="Can cel"
EditText="Edit" ></asp:EditCommand Column>
</Columns>
</asp:DataGrid>

Code (EditInDataGrid .aspx.cs) :

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
if(!IsPostBack)
{

BindGrid();
}
}
private void DataGrid1_EditC ommand(object source, System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
DataGrid1.EditI temIndex = e.Item.ItemInde x;
BindGrid();

}
private void BindGrid()
{
SqlDataAdapter da = new SqlDataAdapter( "select id,name from category",con);
DataSet objDS = new DataSet();
try
{
da.Fill(objDS," Cat");
if(objDS.Tables[0].Rows.Count != 0)
{
DataGrid1.DataS ource = objDS;
DataGrid1.DataB ind();
}
else
{
DataGrid1.DataS ource = null;
DataGrid1.DataB ind();

Response.Write( "No record found.");
}
}
catch(Exception ex)
{
throw ex;
}
}

private void DataGrid1_Updat eCommand(object source, System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
try
{
string strCatName = ((TextBox)e.Ite m.FindControl(" txtEdit")).Text ;
string strId = DataGrid1.DataK eys[e.Item.ItemInde x].ToString();
SqlCommand com = new SqlCommand("upd ate category set name ='"+strCatName+ "' where id = "+strId,con );
con.Open();
com.ExecuteNonQ uery();
DataGrid1.EditI temIndex = -1;
BindGrid();
}
catch(Exception ex)
{
throw ex;
}
}

private void DataGrid1_Cance lCommand(object source, System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
DataGrid1.EditI temIndex = -1;
BindGrid();
}

private void DataGrid1_PageI ndexChanged(obj ect source, System.Web.UI.W ebControls.Data GridPageChanged EventArgs e)
{
DataGrid1.Curre ntPageIndex = e.NewPageIndex;
BindGrid();

Software Development Company