gridview sourcecode for asp.net

<%@ 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>Select</HeaderTemplate>
          <ItemTemplate>
          <asp:CheckBox ID="chkSelect" runat="server" />
          </ItemTemplate>
          </asp:TemplateField>--%>
          <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>

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();