i have created two forms. in first i took three text boxes and one button with name of next page. in second form i took two text boxes and button with name of submit.
so my question is how can i insert values from first form & second form. values from first form accessed via session.
Loading
Satyapriya NayakPosted Mar 8, 2013, 1:30 PM
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace First_second_next_save
{
public partial class FirstForm : System.Web.UI.Page
{
string url;
protected void Button1_Click(object sender, EventArgs e)
{
url = "SecondForm.aspx?name=" + txt_name.Text + "&email=" + txt_email.Text + "&mobileno=" + txt_mobile.Text + " ";
Response.Redirect(url);
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="SecondForm.aspx.cs" Inherits="First_second_next_save.SecondForm" %>
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace First_second_next_save
{
public partial class SecondForm : System.Web.UI.Page
{
string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;
protected void btn_save_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "insert into employee values('" + txt_name.Text + "','" + txt_email.Text + "','" + txt_mobile.Text + "','" + txt_city.Text + "','" + txt_state.Text + "')";
com = new SqlCommand(str, con);
com.ExecuteNonQuery();
con.Close();
Response.Write("Records successfuly inserted");
}
protected void Page_Load(object sender, EventArgs e)
{
txt_name.Text = Request.QueryString["name"];
txt_email.Text = Request.QueryString["email"];
txt_mobile.Text = Request.QueryString["mobileno"];
}
}
}