/*Use Like It Hope your Problem will be sort out */
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace Insurance
{
public partial class Create_New_Customer : System.Web.UI.Page
{
DataSet ds = new DataSet();
SqlConnection con;
SqlCommand cmd = new SqlCommand();
SqlParameter sp1 = new SqlParameter();
SqlParameter sp2 = new SqlParameter();
SqlParameter sp3 = new SqlParameter();
SqlParameter sp4 = new SqlParameter();
SqlParameter sp5 = new SqlParameter();
SqlParameter sp6 = new SqlParameter();
SqlParameter sp7 = new SqlParameter();
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
BindGridView();
}
}
protected void btnSave_Click1(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=NSEZ-DD4-028;
Initial Catalog=Insurance;Integrated Security= SSPI");
cmd = new SqlCommand("Create_Customer", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Connection = con;
cmd.Parameters.Add("@First_Name", SqlDbType.VarChar).Value = txtFirstName.Text.ToString();
cmd.Parameters.Add("@Last_Name", SqlDbType.VarChar).Value = txtLastName.Text.ToString();
cmd.Parameters.Add("@Address1", SqlDbType.VarChar).Value = txtAddress.Text.ToString();
cmd.Parameters.Add("@City", SqlDbType.VarChar).Value = txtCity.Text.ToString();
cmd.Parameters.Add("@State", SqlDbType.VarChar).Value = txtState.Text.ToString();
cmd.Parameters.Add("@Zip", SqlDbType.Int).Value = txtZip.Text;
cmd.Parameters.Add("@Country", SqlDbType.VarChar).Value = txtCountry.Text.ToString();
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Clear();
BindGridView();
}
Void BindGridView()
{
con = new SqlConnection("Data Source=NSEZ-DD4-028;Initial Catalog=Insurance;Integrated Security= SSPI");
cmd = new SqlCommand("Create_Customer_All", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Connection = con;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
gridviewCustomer.DataSource = ds;
gridviewCustomer.DataBind();
con.Close();
}
protected void btnCancel_Click(object sender, EventArgs e)
{
Clear();
}
Void Clear()
{
txtFirstName.Text = "";
txtLastName.Text = "";
txtAddress.Text = "";
txtCity.Text = "";
txtState.Text = "";
txtZip.Text = "";
txtCountry.Text = "";
}
protected void btnMainWindow_Click(object sender, EventArgs e)
{
Response.Redirect("Main.aspx");
}
protected void txtCity_TextChanged(object sender, EventArgs e)
{
}
}
}