Hi, my question is:
I worte stored procedure like this:
create procedure Insert(@Name varchar,@DOB date,@RelationShip varchar,@Education varchar)
as
begin
Insert into Familydetails(Name,DOB,Relationship,Education) values(@Name,@DOB,@RelationShip,@Education)
end
In front end i have designed like this:
<table class="style1">
<tr>
<td>
Name</td>
<td>
DOB</td>
<td>
Relationship</td>
<td>
Education</td>
</tr>
<tr>
<td>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox7" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox8" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:TextBox ID="TextBox9" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox10" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox11" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox12" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:TextBox ID="TextBox13" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox14" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox15" runat="server"></asp:TextBox>
</td>
<td>
<asp:TextBox ID="TextBox16" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="4" style="text-align: center">
<asp:Button ID="Button1" runat="server" Text="Submit" />
</td>
</tr>
</table>
My scenario is I need to enter all the rows of (Name, DOB, Relationship,Education) of single family members and if i click on submit button all the details of family members should go to database table(FamilyDetails).
With Stored procedure how i need to call in front end.
Any help will be appreciated.