<div id="contractorbox" runat="server" class="grid_scroll">
<%--<div id="Div1" runat="server" class="grid_scroll">--%>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateDeleteButton="True"
AutoGenerateEditButton="True" DataSourceID="SqlDataSource1" DataKeyNames="userid">
<Columns>
<asp:BoundField DataField="contactname" HeaderText="Full Name" SortExpression="contactname" />
<asp:BoundField DataField="loginid" HeaderText="User Id" SortExpression="loginid" />
<asp:BoundField DataField="password" HeaderText="Password" SortExpression="password" />
<asp:BoundField DataField="coname" HeaderText="Company Name" SortExpression="coname" />
<asp:BoundField DataField="address" HeaderText="Address" SortExpression="address" />
<asp:BoundField DataField="state" HeaderText="State" SortExpression="state" />
<asp:BoundField DataField="city" HeaderText="City" SortExpression="city" />
<asp:BoundField DataField="zip" HeaderText="Zip" SortExpression="zip" />
<asp:BoundField DataField="phone" HeaderText="Phone" SortExpression="phone" />
<asp:BoundField DataField="email" HeaderText="Email" SortExpression="email" />
<asp:BoundField DataField="active" HeaderText="active" SortExpression="active" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DbConnection %>"
SelectCommand="SELECT [contactname], [userid],[loginid], [password], [phone], [zip], [state], [city], [address], [coname], [email],[active] FROM [tuan_users] where [active]=1 and cname = @ddltrade2"
UpdateCommand="Update [tuan_users] set [loginid]=@loginid, [password]=@password, [contactname]=@contactname, [phone]=@phone, [zip]=@zip, [state]=@state, [city]=@city, [address]=@address, [coname]=@coname, [email]=@email ,[active]=@active where [userid]=@userid"
DeleteCommand="UPDATE [dbo].[tuan_users] SET [active] = 0 WHERE userid=@userid"
InsertCommand="INSERT into [dbo].[tuan_users] (contactname,loginid,password,last_update_date,coname,active,class,cname,address,city,state,zip,phone,creation_date,email) VALUES (@contactname,@loginid,@password,getdate(),@coname,1,@class,@cname,@address,@city,@state,@zip,@phone,getdate(),@email)">
<SelectParameters>
<asp:ControlParameter Name="ddltrade2" ControlID="ddlTrades2" PropertyName="SelectedValue" />
</SelectParameters>
<DeleteParameters>
<asp:ControlParameter ControlID="GridView1" Name="userid" PropertyName="SelectedDataKey" />
</DeleteParameters>
<InsertParameters>
<asp:ControlParameter Name="contactname" ControlID="txtcontactname" Type="String" />
<asp:ControlParameter Name="loginid" ControlID="txtloginid" Type="String" />
<asp:ControlParameter Name="password" ControlID="txtpassword" Type="String" />
<asp:ControlParameter Name="coname" ControlID="txtconame" Type="String" />
<asp:ControlParameter Name="cname" ControlID="txtcname" Type="String" />
<asp:ControlParameter Name="class" ControlID="class" DefaultValue="vendor" Type="String" />
<asp:ControlParameter Name="address" ControlID="txtaddress" Type="String" />
<asp:ControlParameter Name="city" ControlID="txtcity" Type="String" />
<asp:ControlParameter Name="state" ControlID="txtstate" Type="String" />
<asp:ControlParameter Name="zip" ControlID="txtzip" Type="String" />
<asp:ControlParameter Name="phone" ControlID="txtphone" Type="String" />
<asp:ControlParameter Name="email" ControlID="txtemail" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
This is my popup add row button
<cc1:modalpopupextender id="mp1" runat="server" popupcontrolid="Panel1" targetcontrolid="btnShow"
cancelcontrolid="btnClose" backgroundcssclass="modalBackground"></cc1:modalpopupextender>
<asp:Panel ID="Panel1" runat="server" CssClass="modalPopup grid_scroll" align="center"
Style="display: none">
<h2>
Add a Contractor Admin</h2>
<table border="1" style="border-collapse: collapse">
<tr>
<td style="width: 100px">
<asp:Button ID="btnAdd2" runat="server" Text="Add" OnClick="Insert2" />
</td>
<td style="width: 75px">
Full Name:<br />
<asp:TextBox ID="txtcontactname" runat="server" />
</td>
<td style="width: 75px">
User ID:<br />
<asp:TextBox ID="txtloginid" runat="server" />
</td>
<td style="width: 75px">
Password:<br />
<asp:TextBox ID="txtpassword" runat="server" />
</td>
<td style="width: 75px">
Company Name:<br />
<asp:TextBox ID="txtconame" runat="server" />
</td>
<td style="width: 75px">
Category:<br />
<asp:TextBox ID="txtcname" runat="server" />
</td>
<td style="width: 75px">
Address:<br />
<asp:TextBox ID="txtaddress" runat="server" />
</td>
<td style="width: 75px">
City:<br />
<asp:TextBox ID="txtcity" runat="server" />
</td>
<td style="width: 75px">
State:<br />
<asp:TextBox ID="txtstate" runat="server" />
</td>
<td style="width: 75px">
Zip:<br />
<asp:TextBox ID="txtzip" runat="server" />
</td>
<td style="width: 75px">
Phone:<br />
<asp:TextBox ID="txtphone" runat="server" />
</td>
<td style="width: 75px">
Email:<br />
<asp:TextBox ID="txtemail" runat="server" />
</td>
<asp:HiddenField ID="class" runat="server" />
<%--used to store class for sql statement--%>
</tr>
</table>
<asp:Button ID="btnClose" runat="server" Text="Close" />
</asp:Panel>
