Dec 01, 2012, 3:24 AM
[CLOSED] Error in Store.Sync.
Now I create a gridPanel and update field. when you want to use store1.sync() which told me need to declare var. But I think I did it. so I want to find out which row I updated in the grid. in Internet I know the function "getModifiedRecords". but I can't use in gridpanel.getStore(), because it didn't show this function below gridpanel.getStore().
any hints in my program? C#
and My program is below second:
the error is below first:
any hints in my program? C#
and My program is below second:
the error is below first:
Status Code: 200Status Text: BADRESPONSE: 語法錯誤
{serviceResponse:{success:false,message:"System.Exception: Must declare the scalar variable \"@remark\". ---> System.Data.OleDb.OleDbException: Must declare the scalar variable \"@remark\".\r\n at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)\r\n at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()\r\n at System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation)\r\n at System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues)\r\n at System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback)\r\n at Ext.Net.Store.MakeUpdates(IDataSource ds, JArray data) in D:\\component_download\\extnet-Ext.NET.Pro-4a10352\\Ext.Net\\Ext\\Data\\Store.cs:line 890\r\n at Ext.Net.Store.MakeChanges() in D:\\component_download\\extnet-Ext.NET.Pro-4a10352\\Ext.Net\\Ext\\Data\\Store.cs:line 829\r\n at Ext.Net.Store.DoSaving(String action, String jsonData, JToken parameters) in D:\\component_download\\extnet-Ext.NET.Pro-4a10352\\Ext.Net\\Ext\\Data\\Store.cs:line 793\r\n --- End of inner exception stack trace ---\r\n at Ext.Net.Store.DoSaving(String action, String jsonData, JToken parameters) in D:\\component_download\\extnet-Ext.NET.Pro-4a10352\\Ext.Net\\Ext\\Data\\Store.cs:line 806\r\n at Ext.Net.Store.RaiseAjaxPostBackEvent(String eventArgument) in D:\\component_download\\extnet-Ext.NET.Pro-4a10352\\Ext.Net\\Ext\\Data\\Store.cs:line 1131",data:}}
<!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>己辭職員工例外處理</title>
<style type="text/css">
.x-grid-cell-fullName .x-grid-cell-inner {
font-family : tahoma, verdana;
display : block;
font-weight : normal;
font-style : normal;
color : #385F95;
white-space : normal;
}
.x-grid-rowbody div {
margin : 2px 5px 20px 5px !important;
width : 99%;
color : Gray;
}
.x-grid-row-expanded td.x-grid-cell{
border-bottom-width:0px;
}
.icon-exclamation {
padding-left: 25px !important;
background: url(/icons/exclamation-png/ext.axd) no-repeat 3px 0px !important;
}
.icon-accept {
padding-left: 25px !important;
background: url(/icons/accept-png/ext.axd) no-repeat 3px 0px !important;
}
.my-panel
{
padding-left: 50px;
padding-top: 50px;
padding-bottom: 50px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<ext:resourcemanager ID="ResourceManager1" runat="server"
DirectMethodNamespace="temp" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:CrystralConnString %>"
SelectCommand="SELECT excludeID, staffID, remark, insertUser, insertDate, updateUser, updateDate FROM tblExcludeStaff where isDel=0"
UpdateCommand = "update tblExcludeStaff set remark = @remark, staffID = @staffID where excludeID = @excludeID"
ProviderName="<%$ ConnectionStrings:CrystralConnString.ProviderName %>" >
<UpdateParameters>
<asp:Parameter Name="remark" Type="String" />
<asp:Parameter Name="staffID" Type="String" />
<asp:Parameter Name="excludeID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
<ext:GridPanel ID="GridPanel1" runat="server" Title="Data detail" Height="500px">
<Store>
<ext:Store ID="Store1" runat="server" DataSourceID="SqlDataSource1" OnReadData="Store1_RefershData">
<Model>
<ext:Model runat="server" IDProperty="excludeID">
<Fields>
<ext:ModelField name="excludeID" />
<ext:ModelField name="staffID" Type="String" />
<ext:ModelField name="remark" Type="String" />
<ext:ModelField name="insertUser" />
<ext:ModelField name="insertDate" />
<ext:ModelField name="updateUser" />
<ext:ModelField name="updateDate" />
</Fields>
</ext:Model>
</Model>
<Listeners>
<Exception Handler="Ext.Msg.alert('Operation failed', operation.getError());" />
<Write Handler="Ext.Msg.alert('Write', 'The data successfully saved');" />
</Listeners>
</ext:Store>
</Store>
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ID="excludeID" runat="server" Text="System ID" width="100" DataIndex="excludeID" Hidden="true" />
<ext:Column ID="staffID" runat="server" Text="Staff ID" width="100" DataIndex="staffID">
<Editor>
<ext:TextField runat="server" />
</Editor>
</ext:Column>
<ext:Column ID="remark" runat="server" Text="remark" width="200" DataIndex="remark">
<Editor>
<ext:TextField runat="server" />
</Editor>
</ext:Column>
<ext:Column ID="insertUser" runat="server" Text="Inupt_staff" width="200" DataIndex="insertUser" Hidden="true" />
<ext:Column ID="insertDate" runat="server" Text="input date" width="200" DataIndex="insertDate" Hidden="true" />
<ext:Column ID="updateUser" runat="server" Text="last update user" width="200" DataIndex="updateUser" Hidden="true" />
<ext:Column ID="updateDate" runat="server" Text="last update date" width="200" DataIndex="updateDate" Hidden="true" />
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel runat="server" Mode="Multi" />
</SelectionModel>
<View>
<ext:GridView ID="GridView1" runat="server">
<GetRowClass Handler="return 'x-grid-row-expanded';" />
</ext:GridView>
</View>
<Plugins>
<ext:CellEditing runat="server" />
</Plugins>
</ext:GridPanel>
</Items>
<Buttons>
<ext:Button ID="btnSave" runat="server" Text="Sync" Icon="Disk">
<Listeners>
<Click Handler="#{Store1}.sync();" />
</Listeners>
</ext:Button>
</Buttons>
</ext:Panel>
</Items>
</ext:tabpanel>
</form>
</body>
</html>
Last edited by Daniil; Dec 04, 2012 at 8:52 AM.
Reason: Please use [CODE] tags, [CLOSED]