Here i'm using a table to insert data.....as shown below and Below that is a Grid view with SQLdatasource.. I want to insert data only into the table and i want to edit and update the data in grid view....plz guide me..


<table align="center" cellpadding="2" cellspacing="1" style="background-color: #FF0066"> <tr> <td> NAME:</td> <td> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> </td> </tr> <tr> <td> DESIGNATION:</td> <td> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </td> </tr> <tr> <td> SALARY:</td> <td> <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox> </td> </tr> <tr> <td> CITY:</td> <td> <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox> </td> </tr> <tr> <td> E-MAIL:</td> <td> <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox> </td> </tr> <tr align="center"> <td colspan="2"> <asp:Button ID="Button1" runat="server" BackColor="#3333FF" BorderColor="#000099" ForeColor="White" onclick="Button1_Click" Text="SUBMIT" />
 </td>
 </tr>
</table>



<asp:GridView ID="GridView1" runat="server" align="center" BackColor="White"
            BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3"
            ForeColor="Black" GridLines="Vertical" AutoGenerateColumns="false"
            onpageindexchanging="GridView1_PageIndexChanging"
            onrowcancelingedit="GridView1_RowCancelingEdit"
            onrowediting="GridView1_RowEditing" DataKeyNames="Name"
            onrowupdating="GridView1_RowUpdating">
            <FooterStyle BackColor="#CCCCCC" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="#CCCCCC" />
            <Columns>
            <asp:TemplateField>
            <EditItemTemplate>
                <asp:Button ID="LinkButton1" runat="server" Text="Update" CommandName="Update"></asp:Button>
                <asp:Button ID="LinkButton2" runat="server" Text="Cancel" CommandName="Cancel"></asp:Button>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Button ID="LinkButton4" runat="server" Text="Select" CommandName="Select"></asp:Button>
                <asp:Button ID="LinkButton3" runat="server" Text="Edit" CommandName="Edit"></asp:Button>
                <asp:Button ID="LinkButton5" runat="server" Text="Delete" CommandName="Delete"></asp:Button>
            </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Name">
            <EditItemTemplate>
                <asp:TextBox ID="TextBox7" runat="server" Text='<%#Eval("name") %>'>
                </asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <%#Eval("name") %>
            </ItemTemplate>
          
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Designation">
            <EditItemTemplate>
                <asp:TextBox ID="TextBox8" runat="server" Text='<%#Eval("desg") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <%#Eval("desg") %>
            </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Salary">
            <EditItemTemplate>
                <asp:TextBox ID="TextBox9" runat="server" Text='<%#Eval("sal") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <%#Eval("sal") %>
            </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="City">
            <EditItemTemplate>
                <asp:TextBox ID="TextBox10" runat="server" Text='<%#Eval("city") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <%#Eval("city") %>
            </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Email">
            <EditItemTemplate>
                <asp:TextBox ID="TextBox11" runat="server" Text='<%#Eval("email") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <%#Eval("email") %>
            </ItemTemplate>
            </asp:TemplateField>
          
            </Columns>
        </asp:GridView>