Hey,
You can use session variables, hidden fields based upon your requirement.
Hidden fields can be pretty useful.
Have a look below:
<input type="hidden" id="hiddenPersonalDetails" runat="server" />
<input type="hidden" id="hiddenEducationalDetails" runat="server" />
<asp:textbox id="txtName" runat="server" xmlns:asp="#unknown"></asp:textbox>
<asp:textbox id="txtEducation" runat="server" xmlns:asp="#unknown"></asp:textbox>
On Submit button click:
protected void btnSubmit_Click(object sender, EventArgs e)
{
hiddenPersonalDetails.Value=txtName.Text;
hiddenEducationalDetails.Value=txtEducation.Text;
}
Below code might help you to insert the records in the DB
string personalDetails=hiddenPersonalDetails.Value;
string educationalDetails=hiddenEducationalDetails.Value;
string connectionString = "Your connection string";
using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = "INSERT INTO dbo.table(PersonalDetails, EducationalDetails) VALUES (@personalDetails, @educationalDetails)";
command.Parameters.AddWithValue("@personalDetails", personalDetails);
command.Parameters.AddWithValue("@educationalDetails",educationalDetails);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
Regards
Anurag