Hi, first time on this forums. Can some one please check this code, Insert/updating is not working.
The new grid will upgrade an old ASP grid upside. I did this in other test page but in this one i can't see what the problem is.
I need it to work with a StroredProcedure but I tried it with an SQL statment and is not working ether.
Any help would be useful, Thnx.
The new grid will upgrade an old ASP grid upside. I did this in other test page but in this one i can't see what the problem is.
I need it to work with a StroredProcedure but I tried it with an SQL statment and is not working ether.
Any help would be useful, Thnx.
<%@ Page Language="C#" MasterPageFile="~/Admin/Admin.Master" AutoEventWireup="true" CodeBehind="Users.aspx.cs" Inherits="GIA_SITE.Admin.Users" %> |
<%@ Register Assembly="Telerik.Web.UI, Version=2009.3.1314.20, Culture=neutral, PublicKeyToken=121fae78165ba3d4" |
Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> |
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> |
<AjaxSettings> |
<telerik:AjaxSetting AjaxControlID="RadGrid1"> |
<UpdatedControls> |
<telerik:AjaxUpdatedControl ControlID="RadGrid1" /> |
</UpdatedControls> |
</telerik:AjaxSetting> |
</AjaxSettings> |
</telerik:RadAjaxManager> |
<table width="100%"> |
<!--Fila 1--> |
<tr> |
<td align = "center"> |
<asp:UpdatePanel ID="pnlData1" runat="server"> |
<ContentTemplate> |
<table class="FondoAdministracion"> |
<tr> |
<td> |
|
</td> |
</tr> |
<tr align="left" valign="top"> |
<td> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblName" runat="server" Text="Name"></asp:Label></p> |
</td> |
<td colspan="9"> |
<asp:TextBox ID="txtName" runat="server" Width="497px" MaxLength="300"></asp:TextBox> |
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="*" Display="Dynamic" ControlToValidate="txtName"></asp:RequiredFieldValidator> |
</td> |
<td> |
|
</td> |
</tr> |
<tr align="left" valign="top"> |
<td> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblLogin" runat="server" Text="Login"></asp:Label></p> |
</td> |
<td align="left"> |
<asp:TextBox ID="txtLogin" runat="server" MaxLength="50"></asp:TextBox> |
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="*" Display="Dynamic" ControlToValidate="txtLogin"></asp:RequiredFieldValidator> |
</td> |
<td colspan="6"> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblEMail" runat="server" Text="EMail"></asp:Label></p> |
</td> |
<td> |
<asp:TextBox ID="txtEMail" runat="server" Columns="30" MaxLength="100"></asp:TextBox> |
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="*" Display="Dynamic" ControlToValidate="txtEMail"></asp:RequiredFieldValidator> |
</td> |
<td> |
|
</td> |
</tr> |
<tr align="left" valign="top"> |
<td> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblIdCompany" runat="server" Text="Company" ToolTip="Only active companies"></asp:Label></p> |
</td> |
<td> |
<asp:DropDownList ID="ddlCompany" runat="server" ToolTip="Only active companies" AutoPostBack="True" OnSelectedIndexChanged="ddlCompany_SelectedIndexChanged"></asp:DropDownList> |
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="ddlCompany" Display="Dynamic" ErrorMessage="*"></asp:RequiredFieldValidator> |
</td> |
<td colspan="6"> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblAdmin" runat="server" Text="Admin"></asp:Label> |
</p> |
</td> |
<td> |
<asp:DropDownList ID="ddlAdmin" runat="server"></asp:DropDownList> |
<asp:RequiredFieldValidator ID="reqAdmin" runat="server" ErrorMessage="*" ControlToValidate="ddlAdmin" Display="Dynamic"></asp:RequiredFieldValidator> |
</td> |
<td> |
|
</td> |
</tr> |
<tr align="left" valign="top"> |
<td> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblConsultant" runat="server" Text="External User"></asp:Label> |
</p> |
</td> |
<td> |
<asp:DropDownList ID="ddlConsultant" runat="server"></asp:DropDownList> |
<asp:RequiredFieldValidator ID="reqConsultant" runat="server" ErrorMessage="*" ControlToValidate="ddlConsultant" Display="Dynamic"></asp:RequiredFieldValidator> |
</td> |
<td colspan="6"> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblResponsible" runat="server" Text="Responsible"></asp:Label></p> |
</td> |
<td> |
<asp:DropDownList ID="ddlResponsible" runat="server"></asp:DropDownList> |
<asp:RequiredFieldValidator ID="reqResponsible" runat="server" ErrorMessage="*" ControlToValidate="ddlResponsible" Display="Dynamic"></asp:RequiredFieldValidator> |
</td> |
<td> |
|
</td> |
</tr> |
<tr align="left" valign="top"> |
<td> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblMailContact" runat="server" Text="Mail Contact"></asp:Label> |
</p> |
</td> |
<td> |
<asp:DropDownList ID="ddlMailContact" runat="server"></asp:DropDownList> |
<asp:RequiredFieldValidator ID="reqMailContact" runat="server" ErrorMessage="*" ControlToValidate="ddlMailContact" Display="Dynamic"></asp:RequiredFieldValidator> |
</td> |
<td colspan="6"> |
|
</td> |
<td> |
<p> |
<asp:Label ID="lblExpeditor" runat="server" Text="Expeditor"></asp:Label> |
</p> |
</td> |
<td> |
<asp:DropDownList ID="ddlExpeditor" runat="server"></asp:DropDownList> |
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ErrorMessage="*" ControlToValidate="ddlExpeditor" Display="Dynamic"></asp:RequiredFieldValidator> |
</td> |
<td> |
|
</td> |
</tr> |
<tr> |
<td colspan="2"> |
<asp:LinkButton ID="lnkbtnChangePassword" runat="server" OnClick="lnkbtnChangePassword_Click" Visible="False">Reset Password</asp:LinkButton> |
</td> |
</tr> |
<tr> |
<td> |
|
</td> |
</tr> |
</table> |
<table> |
<tr> |
<td> |
|
</td> |
</tr> |
<tr> |
<td colspan="4" align="center"> |
<asp:Button ID="btnSave" runat="server" Text="Save" OnClick="btnSave_Click" /> |
|
<asp:Button ID="Button1" runat="server" Text="Find" CausesValidation="false" OnClick="btnFind_Click" /> |
|
<asp:Button ID="btnAll" runat="server" Text="All" CausesValidation="false" OnClick="btnAll_Click" /> |
|
<asp:Button ID="btnCancel" runat="server" Text="Cancel" CausesValidation="false" OnClick="btnCancel_Click" /> |
</td> |
</tr> |
<tr> |
<td> |
|
</td> |
</tr> |
</table> |
</ContentTemplate> |
</asp:UpdatePanel> |
</td> |
</tr> |
<!--Fila 2--> |
<tr> |
<td align="center" style="height: 553px"> |
<asp:UpdatePanel ID="pnlGrid" runat="server" UpdateMode="Always" RenderMode="Inline"> |
<ContentTemplate> |
<asp:GridView ID="grdData" runat="server" HorizontalAlign="Center" AutoGenerateColumns="False" AllowSorting="true" |
DataKeyNames="Id" AllowPaging="true" PageSize="15" OnRowDataBound="grdData_RowDataBound" OnPageIndexChanging="grdData_PageIndexChanging" |
OnSorting="grdData_Sorting" CssClass="tabla"> |
<Columns> |
<asp:TemplateField HeaderText="Name" SortExpression="Name" HeaderStyle-ForeColor="#FFFFFF"> |
<ItemTemplate> |
<asp:LinkButton ID="lnkbName" runat="server" CausesValidation="false" Text='<%# Bind("Name") %>' |
OnCommand="lnkbName_Command" CommandArgument='<%# Eval("Id") %>'></asp:LinkButton> |
</ItemTemplate> |
</asp:TemplateField> |
<asp:BoundField DataField="Login" HeaderText="Login" SortExpression="Login" HeaderStyle-ForeColor="#FFFFFF"> |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:BoundField DataField="EMail" HeaderText="Email" SortExpression="EMail" HeaderStyle-ForeColor="#FFFFFF" > |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:BoundField DataField="CompanyName" HeaderText="Company" SortExpression="CompanyName" HeaderStyle-ForeColor="#FFFFFF" > |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:BoundField DataField="Admin" HeaderText="Admin" SortExpression="Admin" HeaderStyle-ForeColor="#FFFFFF" > |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:BoundField DataField="Consultant" HeaderText="Consulant" SortExpression="Consultant" HeaderStyle-ForeColor="#FFFFFF" > |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:BoundField DataField="Responsible" HeaderText="Responsible" SortExpression="Responsible" HeaderStyle-ForeColor="#FFFFFF" > |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:BoundField DataField="EXPEDITOR" HeaderText="Expeditor" SortExpression="Expeditor" HeaderStyle-ForeColor="#FFFFFF" > |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:BoundField DataField="Mail_Contact" HeaderText="Mail Contact" SortExpression="Mail_Contact" HeaderStyle-ForeColor="#FFFFFF" > |
<ItemStyle HorizontalAlign="Left" /> |
</asp:BoundField> |
<asp:TemplateField> |
<ItemTemplate> |
<asp:ImageButton ID="imgbtnDelete" runat="server" CommandArgument='<%# Eval("Id") %>' CausesValidation="false" ImageUrl="~/Resourses/Images/Eliminar.gif" OnCommand="imgbtnDelete_Command" BackColor="Transparent" /> |
<asp:ImageButton ID="imgbtnUndelete" runat="server" OnCommand="imgbtnDelete_Command" CommandArgument='<%# Eval("Id") %>' CausesValidation="false" ImageUrl="~/Resourses/Images/Inactivo.gif" BackColor="transparent" Visible="false"/> |
</ItemTemplate> |
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> |
</asp:TemplateField> |
</Columns> |
<PagerTemplate> |
</br> |
<asp:CheckBox Id="chkPaginar" runat="server" Checked="true" AutoPostBack="true" Text="Paging" TextAlign="Left" Visible="true" Enabled="true" OnCheckedChanged="chkPaginar_CheckedChanged"/> |
|
<span> |
<asp:Label ID="lblPage" runat="server" Text="Page"></asp:Label></span> |
<asp:DropDownList ID="ddlPageCounter" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlPageCounter_SelectedIndexChanged"></asp:DropDownList> |
<asp:Label ID="lblOf" runat="server" Text="Of"></asp:Label> |
<asp:Label ID="lblTotalPages" runat="server"></asp:Label> |
|
Showing |
|
<asp:Label ID="lblFirstOf" runat="server" Text="1"></asp:Label> |
to |
<asp:Label ID="lblLastOf" runat="server" Text="10"></asp:Label> |
Of |
<asp:Label ID="lblTotalReg" runat="server" Text="100"></asp:Label> |
<asp:ImageButton ID="btnFirst" runat="server" CommandName="Page" AlternateText="First" |
ToolTip="First Page" CommandArgument="First" ImageUrl="~/Resourses/Images/first.gif" |
BorderWidth="0" BackColor="transparent" CausesValidation="false" /> |
<asp:ImageButton ID="btnPrev" runat="server" CommandName="Page" AlternateText="First" |
ToolTip="Prev. Page" CommandArgument="Prev" ImageUrl="~/Resourses/Images/previous.gif" |
BorderWidth="0" BackColor="transparent" CausesValidation="false" /> |
|
<asp:ImageButton ID="btnNext" runat="server" CommandName="Page" AlternateText="First" |
ToolTip="Next Page" CommandArgument="Next" ImageUrl="~/Resourses/Images/next.gif" |
BorderWidth="0" BackColor="transparent" CausesValidation="false" /> |
<asp:ImageButton ID="btnLast" runat="server" CommandName="Page" AlternateText="First" |
ToolTip="Last Page" CommandArgument="Last" ImageUrl="~/Resourses/Images/last.gif" |
BorderWidth="0" BackColor="transparent" CausesValidation="false" /> |
</PagerTemplate> |
<HeaderStyle CssClass="celda" HorizontalAlign="Center" Height="30" /> |
<PagerStyle CssClass="celdaPager" HorizontalAlign="Center" /> |
<RowStyle CssClass="celda1" /> |
<AlternatingRowStyle CssClass="celda2" /> |
</asp:GridView> |
</ContentTemplate> |
</asp:UpdatePanel> |
</td> |
</tr> |
<tr> |
<td> |
<asp:UpdatePanel ID="updPanelGrid" runat="server" UpdateMode="Conditional"> |
<ContentTemplate> |
<telerik:RadGrid |
ID="RadGrid1" |
runat="server" |
DataSourceID="UsrGridSqlDataSource" |
GridLines="None" |
Skin="Outlook" |
ShowStatusBar="True" |
AllowAutomaticInserts="true" |
AllowAutomaticUpdates="true" |
OnInsertCommand="RadGrid1_InsertCommand" |
OnUpdateCommand="RadGrid1_UpdateCommand" |
AutoGenerateColumns="False" |
ShowFooter="true" OnNeedDataSource="RadGrid1_NeedDataSource" |
> |
<MasterTableView |
DataKeyNames="ID" |
CommandItemDisplay="Top" |
InsertItemDisplay="Bottom" |
EditMode="InPlace" |
> |
<Columns> |
<telerik:GridEditCommandColumn ButtonType="ImageButton"> |
</telerik:GridEditCommandColumn> |
<telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name" UniqueName="Name" ColumnEditorID="GridTextBoxColumnEditor1"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Login" HeaderText="Login" SortExpression="Login" UniqueName="Login" ColumnEditorID="GridTextBoxColumnEditor2"></telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="EMail" HeaderText="Email" SortExpression="EMail" UniqueName="EMail" ColumnEditorID="GridTextBoxColumnEditor3"></telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="CompanyName" HeaderText="Company" SortExpression="CompanyName" UniqueName="CompanyName" ColumnEditorID="GridTextBoxColumnEditor4"></telerik:GridBoundColumn> |
<telerik:GridCheckBoxColumn DataField="Admin" HeaderText="Admin" SortExpression="Admin" UniqueName="Admin" ColumnEditorID="GridTextBoxColumnEditor5"></telerik:GridCheckBoxColumn> |
<telerik:GridCheckBoxColumn DataField="Consultant" HeaderText="Consulant" UniqueName="Consultant" ColumnEditorID="GridTextBoxColumnEditor6"></telerik:GridCheckBoxColumn> |
<telerik:GridCheckBoxColumn DataField="Responsible" HeaderText="Responsible" UniqueName="Responsible" ColumnEditorID="GridTextBoxColumnEditor7"></telerik:GridCheckBoxColumn> |
<telerik:GridCheckBoxColumn DataField="EXPEDITOR" HeaderText="Expeditor" SortExpression="Expeditor" UniqueName="EXPEDITOR" ColumnEditorID="GridTextBoxColumnEditor8"></telerik:GridCheckBoxColumn> |
<telerik:GridCheckBoxColumn DataField="External_User" HeaderText="External User" SortExpression="External_User" UniqueName="External_User" ColumnEditorID="GridTextBoxColumnEditor9"></telerik:GridCheckBoxColumn> |
<telerik:GridCheckBoxColumn DataField="Mail_Contact" HeaderText="Mail Contact" SortExpression="Mail_Contact" UniqueName="Mail_Contact" ColumnEditorID="GridTextBoxColumnEditor10"></telerik:GridCheckBoxColumn> |
</Columns> |
</MasterTableView> |
</telerik:RadGrid> |
</ContentTemplate> |
</asp:UpdatePanel> |
<asp:SqlDataSource ID="UsrGridSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:testConn %>" InsertCommand="INSERT INTO USERS 	( 		NAME, LOGIN, PASSWORD, ID_COMPANY, ADMIN, EMAIL, CONSULTANT, RESPONSIBLE, EXPEDITOR, CHANGE_PASSWORD, MAIL_CONTACT, ID_CREATOR, 		CREATE_DATE, ID_UPDATER, UPDATER_DATE 	) 	VALUES 	( 		@NAME, @LOGIN, @PASSWORD, @ID_COMPANY, @ADMIN, @EMAIL, @CONSULTANT, @RESPONSIBLE, @EXPEDITOR, @CHANGE_PASSWORD, @MAIL_CONTACT, 		@ID_CREATOR, @DATE, @ID_CREATOR, @DATE 	)" SelectCommand="PA_GET_USERS_LIST" SelectCommandType="StoredProcedure" UpdateCommand="PA_USER_UPDATE" UpdateCommandType="StoredProcedure" OnUpdating="UsrGridSqlDataSource_Updating"> |
<UpdateParameters> |
<asp:Parameter Name="ID_COMPANY" Type="Int32" /> |
<asp:Parameter Name="ID_UPDATER" Type="Int32" /> |
<asp:Parameter Name="ADMIN" Type="Boolean" /> |
<asp:Parameter Name="CONSULTANT" Type="Boolean" /> |
<asp:Parameter Name="RESPONSIBLE" Type="Boolean" /> |
<asp:Parameter Name="EXPEDITOR" Type="Boolean" /> |
<asp:Parameter Name="CHANGE_PASSWORD" Type="Boolean" /> |
<asp:Parameter Name="MAIL_CONTACT" Type="Boolean" /> |
<asp:Parameter Name="ACTIVE" Type="Boolean" /> |
<asp:Parameter Name="NAME" Type="String" /> |
<asp:Parameter Name="LOGIN" Type="String" /> |
<asp:Parameter Name="PASSWORD" Type="String" /> |
<asp:Parameter Name="EMAIL" Type="String" /> |
<asp:Parameter Name="ID" Type="Int32" /> |
</UpdateParameters> |
<InsertParameters> |
<asp:Parameter Name="NAME" Type="String" /> |
<asp:Parameter Name="LOGIN" Type="String" /> |
<asp:Parameter Name="PASSWORD" Type="String" /> |
<asp:Parameter Name="ID_COMPANY" Type="Int32" /> |
<asp:Parameter Name="ADMIN" Type="Boolean" /> |
<asp:Parameter Name="EMAIL" Type="String" /> |
<asp:Parameter Name="CONSULTANT" Type="Boolean" /> |
<asp:Parameter Name="RESPONSIBLE" Type="Boolean" /> |
<asp:Parameter Name="EXPEDITOR" Type="Boolean" /> |
<asp:Parameter Name="CHANGE_PASSWORD" Type="Boolean" /> |
<asp:Parameter Name="MAIL_CONTACT" Type="Boolean" /> |
<asp:Parameter Name="ID_CREATOR" Type="Int32" /> |
<asp:Parameter Name="DATE" /> |
</InsertParameters> |
</asp:SqlDataSource> |
</td> |
</tr> |
</table> |
<asp:UpdateProgress ID="updPgrsImage" runat="server"> |
<ProgressTemplate> |
<div style="position: absolute; left: 505px; top: 300px; height: 70px; width: 70px;"> |
<img src="../Resourses/Images/Wait.gif" alt="In Progress"/> |
</div> |
</ProgressTemplate> |
</asp:UpdateProgress> |
</asp:Content> |