May 10, 2012, 12:38 PM
How to access <ext:TextField> column on server side code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="bindData.aspx.cs" Inherits="bindData" %>
<%@ 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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<ext:ResourceManager ID="ResourceManager1" runat="server" />
<div>
<ext:Store ID="Store1" runat="server" OnBeforeRecordInserted="Store1_BeforeRecordInserted"
OnAfterRecordInserted="Store1_AfterRecordInserted" ShowWarningOnFailure="false"
UseIdConfirmation="true">
<Reader>
<ext:JsonReader IDProperty="SupplierID">
<Fields>
<ext:RecordField Name="cmpID" />
<ext:RecordField Name="CompanyName" />
</Fields>
</ext:JsonReader>
</Reader>
<SortInfo Field="CompanyName" Direction="ASC" />
<Listeners>
<LoadException Handler="Ext.Msg.alert('Suppliers - Load failed', e.message || e);" />
<CommitFailed Handler="Ext.Msg.alert('Suppliers - Commit failed', 'Reason: ' + msg);" />
<SaveException Handler="Ext.Msg.alert('Suppliers - Save failed', e.message || e);" />
<CommitDone Handler="Ext.Msg.alert('Suppliers - Commit', 'The data successfully saved');" />
</Listeners>
</ext:Store>
<ext:Viewport ID="Viewport1" runat="server">
<Items>
<ext:BorderLayout ID="BorderLayout1" runat="server">
<Center MarginsSummary="0 5 0 5">
<ext:Panel ID="Panel2" runat="server" Height="300" Header="false" Layout="Fit">
<Items>
<ext:GridPanel ID="GridPanel1" runat="server" Title="Suppliers" AutoExpandColumn="CompanyName"
StoreID="Store1" Border="false" Icon="Lorry">
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ColumnID="cmpID" DataIndex="cmpID" Header="Company ID">
<Editor>
<ext:TextField ID="TextField2" runat="server" />
</Editor>
</ext:Column>
<ext:Column ColumnID="CompanyName" DataIndex="CompanyName" Header="Company Name">
<Editor>
<ext:TextField ID="TextField1" runat="server" />
</Editor>
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
</SelectionModel>
<BottomBar>
<ext:PagingToolbar ID="PagingToolbar1" runat="server" PageSize="10" StoreID="Store1"
DisplayInfo="false" />
</BottomBar>
<SaveMask ShowMask="true" />
<LoadMask ShowMask="true" />
</ext:GridPanel>
</Items>
<Buttons>
<ext:Button ID="btnSave" runat="server" Text="Save" Icon="Disk">
<DirectEvents>
<Click OnEvent="Save">
</Click>
</DirectEvents>
</ext:Button>
<ext:Button ID="btnDelete" runat="server" Text="Delete selected records" Icon="Delete">
<Listeners>
<Click Handler="#{GridPanel1}.deleteSelected();" />
</Listeners>
</ext:Button>
<ext:Button ID="btnInsert" runat="server" Text="Insert" Icon="Add">
<Listeners>
<Click Handler="#{GridPanel1}.insertRecord(0, {});#{GridPanel1}.getView().focusRow(0);#{GridPanel1}.startEditing(0, 0);" />
</Listeners>
</ext:Button>
<ext:Button ID="btnRefresh" runat="server" Text="Refresh" Icon="ArrowRefresh">
<DirectEvents>
<Click OnEvent="UpdateMsg">
</Click>
</DirectEvents>
</ext:Button>
<ext:Button ID="btnEmulError" runat="server" Text="Refresh with Emulated error" Icon="Exclamation">
<Listeners>
<Click Handler="#{GridPanel1}.reload({params:{EmulateError: 1}});" />
</Listeners>
</ext:Button>
</Buttons>
</ext:Panel>
</Center>
</ext:BorderLayout>
</Items>
</ext:Viewport>
</div>
</form>
</body>
</html> protected void Save(object sender, EventArgs e)
{
string strCs = System.Configuration.ConfigurationSettings.AppSettings.Get("connectionstring1");
MySqlConnection m_oConn = new MySqlConnection(strCs);
m_oConn.Open();
string strInsertqry = "Insert into tblComapny values('" + TextField2.Text + "','" + TextField1.Text + "')";
MySqlCommand cmd = new MySqlCommand(strInsertqry, m_oConn);
cmd.ExecuteNonQuery();
m_oConn.Close();
getData(out ds);
}
