Mar 03, 2011, 12:25 AM
Update data and refreshing grid on server-side !
Hi...
I'm the new in using ext.net. I need help. I want to update data and refresh grid on server side (in .cs file).
My form contains the grid and form panel where I update selected row from the grid when I click edit button. And after I update data, i want to refresh the grid also. But, don't know how to do that.
On the server side (.cs file):
protected void btnEdit_OnClick(object sender, EventArgs e)
{
string updateEmployee = "update [dbo].[tbl_Employee] set [FirstName]=' "+ test + "' where employeeID = '5'";
SQLHelper spConnectionObject = new SQLHelper();
spConnectionObject.GetExecuteNonQueryByCommand(upd ateEmployee, CommandType.Text);
// and closing connestion here
}
on the client side I have this:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="_Default" %>
<%@ Register assembly="Ext.Net" namespace="Ext.Net" tagprefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Resource Main</title >
</head>
<body>
<form id="form1" runat="server">
<div>
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:Viewport ID="Viewport1" runat="server" Layout="border">
<Items>
<ext:GridPanel ID="GridPanel1" runat="server" StripeRows="true" Title="Employees"
Icon="UserSuit" Visible="true" AutoDataBind="True" Region="Center" Frame="true"
Margins="0 0 5 5" SelectionMemory="Enabled">
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column Header="First Name" DataIndex="FirstName">
</ext:Column>
<ext:Column ColumnID="ID" Header="Last Name" DataIndex="LastName">
</ext:Column>
<ext:Column Header="Email Address" DataIndex="Email">
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true">
<Listeners>
<RowSelect Handler="#{FormPanel1}.getForm().loadRecord(record );" />
</Listeners>
</ext:RowSelectionModel>
</SelectionModel>
<BottomBar>
<ext:PagingToolbar ID="PagingToolbar1" runat="server" />
</BottomBar>
<Store>
<ext:Store ID="Store1" runat="server" OnRefreshData="DataRefresh">
<Reader>
<ext:JsonReader>
<Fields>
<ext:RecordField Name="FirstName" />
<ext:RecordField Name="LastName" />
<ext:RecordField Name="Email" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
</Store>
</ext:GridPanel>
<ext:FormPanel ID="FormPanel1" runat="server" Region="East" Split="true" Margins="0 5 5 5"
Frame="true" Title="Employee Details" Width="280" Icon="User" DefaultAnchor="100%">
<Items>
<ext:TextField ID="TextField1" runat="server" FieldLabel="Employee ID" DataIndex="EmployeeID" />
<ext:TextField ID="TextField2" runat="server" FieldLabel="First Name" DataIndex="FirstName" />
<ext:TextField ID="TextField3" runat="server" FieldLabel="Last Name" DataIndex="LastName" />
</Items>
<Buttons>
<ext:Button ID="btnEdit" runat="server" Text="Edit" AutoPostBack="true" Icon="UserEdit" Region="Center" Width="60" Height="25" OnClick="btnEdit_OnClick"/>
<ext:Button ID="btnDelete" runat="server" Text="Delete" Icon="UserDelete" Region="West"
Width="60" Height="25" />
</Buttons>
</ext:FormPanel>
</Items>
</ext:Viewport>
</div>
</form>
</body>
</html>
I'm the new in using ext.net. I need help. I want to update data and refresh grid on server side (in .cs file).
My form contains the grid and form panel where I update selected row from the grid when I click edit button. And after I update data, i want to refresh the grid also. But, don't know how to do that.
On the server side (.cs file):
protected void btnEdit_OnClick(object sender, EventArgs e)
{
string updateEmployee = "update [dbo].[tbl_Employee] set [FirstName]=' "+ test + "' where employeeID = '5'";
SQLHelper spConnectionObject = new SQLHelper();
spConnectionObject.GetExecuteNonQueryByCommand(upd ateEmployee, CommandType.Text);
// and closing connestion here
}
on the client side I have this:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="_Default" %>
<%@ Register assembly="Ext.Net" namespace="Ext.Net" tagprefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Resource Main</title >
</head>
<body>
<form id="form1" runat="server">
<div>
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<ext:Viewport ID="Viewport1" runat="server" Layout="border">
<Items>
<ext:GridPanel ID="GridPanel1" runat="server" StripeRows="true" Title="Employees"
Icon="UserSuit" Visible="true" AutoDataBind="True" Region="Center" Frame="true"
Margins="0 0 5 5" SelectionMemory="Enabled">
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column Header="First Name" DataIndex="FirstName">
</ext:Column>
<ext:Column ColumnID="ID" Header="Last Name" DataIndex="LastName">
</ext:Column>
<ext:Column Header="Email Address" DataIndex="Email">
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true">
<Listeners>
<RowSelect Handler="#{FormPanel1}.getForm().loadRecord(record );" />
</Listeners>
</ext:RowSelectionModel>
</SelectionModel>
<BottomBar>
<ext:PagingToolbar ID="PagingToolbar1" runat="server" />
</BottomBar>
<Store>
<ext:Store ID="Store1" runat="server" OnRefreshData="DataRefresh">
<Reader>
<ext:JsonReader>
<Fields>
<ext:RecordField Name="FirstName" />
<ext:RecordField Name="LastName" />
<ext:RecordField Name="Email" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
</Store>
</ext:GridPanel>
<ext:FormPanel ID="FormPanel1" runat="server" Region="East" Split="true" Margins="0 5 5 5"
Frame="true" Title="Employee Details" Width="280" Icon="User" DefaultAnchor="100%">
<Items>
<ext:TextField ID="TextField1" runat="server" FieldLabel="Employee ID" DataIndex="EmployeeID" />
<ext:TextField ID="TextField2" runat="server" FieldLabel="First Name" DataIndex="FirstName" />
<ext:TextField ID="TextField3" runat="server" FieldLabel="Last Name" DataIndex="LastName" />
</Items>
<Buttons>
<ext:Button ID="btnEdit" runat="server" Text="Edit" AutoPostBack="true" Icon="UserEdit" Region="Center" Width="60" Height="25" OnClick="btnEdit_OnClick"/>
<ext:Button ID="btnDelete" runat="server" Text="Delete" Icon="UserDelete" Region="West"
Width="60" Height="25" />
</Buttons>
</ext:FormPanel>
</Items>
</ext:Viewport>
</div>
</form>
</body>
</html>
Last edited by Aleksa007; Mar 03, 2011 at 12:32 AM.