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> |