<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="adduser.aspx.cs" Inherits="adduser" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<table align="right">
<tr>
<td><asp:ImageButton ID="imgsave" runat="server" ImageUrl ="~/images/save.jpg"
Width="25px" ToolTip="SAVE" onclick="imgsave_Click" ImageAlign="Right" /></td></tr></table>
<table style="height:400px; width: 1007px" align="center">
<asp:GridView ID="gvUser" runat="server" Width="1076px" AutoGenerateColumns="False"
CellPadding="4" CellSpacing="2" GridLines="None"
ShowFooter="true" Height="205px"
style="margin-right: 46px" AllowPaging="True" onpageindexchanging="gvUser_PageIndexChanging">
<Columns>
<%----%>
<asp:TemplateField>
<HeaderTemplate>Name</HeaderTemplate>
<ItemTemplate>
<%#Eval("User_Name")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Phone</HeaderTemplate>
<ItemTemplate>
<%#Eval("user_Phone")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtuserPhone" runat="server" Width="80"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>LoginId</HeaderTemplate>
<ItemTemplate><%#Eval("User_UserId")%></ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtLoginId" runat="server" Width="80"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Password</HeaderTemplate>
<ItemTemplate><%# GetVal(Eval("User_Password"))%></ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtpwd" runat="server" Width="100" TextMode="Password"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Email</HeaderTemplate>
<ItemTemplate>
<%#Eval("User_Email")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Address</HeaderTemplate>
<ItemTemplate>
<%#Eval("User_Address")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtAdress" runat="server" Width="70"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>City</HeaderTemplate>
<ItemTemplate>
<%#Eval("User_City")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCity" runat="server" Width="90"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>country</HeaderTemplate>
<ItemTemplate>
<%#Eval("user_country")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCountry" runat="server" Width="50"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>PIN</HeaderTemplate>
<ItemTemplate>
<%#Eval("User_PIN")%>
</ItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtPin" runat="server" Width="60"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>TypeId</HeaderTemplate>
<ItemTemplate >
<%# getuser(Eval("User_Type_Id"))%>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlusertypeid" runat="server" Width="110px"
DataSourceID="SqlDataSource1" DataTextField="user_type_Name"
DataValueField="user_type_id">
</asp:DropDownList >
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$connectionStrings:IMS %>"
SelectCommand="SELECT [user_type_id], [user_type_Name] FROM [usertype]">
</asp:SqlDataSource>
</FooterTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#003366" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#7C6F57" />
<AlternatingRowStyle BackColor="White" />
<RowStyle HorizontalAlign="Center" BackColor="#99ccff"/>
</asp:GridView>
</table>
</asp:Content>
Added from the OPs other "question"
da = new SqlDataAdapter("select * from UserTable", con);
DataSet dss = new DataSet();
da.Fill(dss, "UT");
i = ds.Tables["UT"].Rows.Count;
string uname, uid, upwd, uemail, uadress, ucity, ucountry;
int upin;
long uphone;
GridViewRow r = gvUser.FooterRow;
TextBox t1 = (TextBox)r.FindControl("txtUserName");
uname = t1.Text;
t1 = (TextBox)r.FindControl("txtuserPhone");
uphone = Convert.ToInt64(t1.Text);
t1 = (TextBox)r.FindControl("txtLoginId");
uid = (t1.Text);
t1 = (TextBox)r.FindControl("txtpwd");
upwd = (t1.Text);
t1 = (TextBox)r.FindControl("txtEmail");
uemail = (t1.Text);
t1 = (TextBox)r.FindControl("txtAdress");
uadress = (t1.Text);
t1 = (TextBox)r.FindControl("txtCity");
ucity = (t1.Text);
t1 = (TextBox)r.FindControl("txtCountry");
ucountry = (t1.Text);
t1 = (TextBox)r.FindControl("txtPin");
upin = Convert.ToInt32(t1.Text);
DropDownList kd = (DropDownList)gvUser.FooterRow.FindControl("ddlusertypeid");
SqlDataAdapter daa = new SqlDataAdapter("select user_type_Abbreviation from usertype where user_type_id='" + kd.SelectedValue + "'", con);
ds = new DataSet();
daa.Fill(ds, "usertype");
string id = ds.Tables["usertype"].Rows[0][0].ToString();
string userid = id + Convert.ToInt32(100 + i);
string s = "insert into USERTABLE values('" + userid + "','" + uname + "'," + uphone + ",'" + uid + "','" + upwd + "','" + uemail + "','" + uadress + "','" + ucity + "','" + ucountry + "'," + upin + ",'" + kd.SelectedValue + "')";
da = new SqlDataAdapter(s, con);
dss = new DataSet();
da.Fill(dss, "UserTable");
getdata();