Friday, April 2, 2010

ASP.NET_connection_String

SqlConnection con;
//public SqlCommand cmd;
//public DataSet ds;
//public SqlDataAdapter da;
//public DataTable dt;


protected void Page_Load(object sender, EventArgs e)
{
public String s = @"Data Source = ADMIN\SQLEXPRESS;Initial Catalog= Pan_Details;Integrated Security=True";
//Connect Timeout=30;User Instance=True";
con = new SqlConnection(s);

/*SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
string connectionString = ConfigurationManager.ConnectionStrings[ @"Data Source = ADMIN\SQLEXPRESS;Initial Catalog= Pan_Details;Integrated Security=True"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand("SELECT * FROM Member WHERE First_Name='"+TextBox1.Text+"' AND Middle_Name='" + TextBox2.Text + "'", conn);
conn.Open();
comm.Parameters.AddWithValue("@ID", "1");
reader = comm.ExecuteReader();
DetailsView1.DataSource = reader;
DetailsView1.DataBind();
reader.Close();
conn.Close(); */


protected void Button1_Click(object sender, EventArgs e)
{
///DetailsView1.Visible = false;
//SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
//string connectionString = ConfigurationManager.ConnectionStrings[@"Data Source = ADMIN\SQLEXPRESS;Initial Catalog= Pan_Details;Integrated Security=True"].ConnectionString;
conn = new SqlConnection(conn);
comm = new SqlCommand("SELECT * FROM Member WHERE First_Name='" + TextBox1.Text + "' AND Middle_Name='" + TextBox2.Text + "'", conn);
conn.Open();
//comm.Parameters.AddWithValue("@ID", "1");
reader = comm.ExecuteReader();
DetailsView1.DataSource = reader;
DetailsView1.DataBind();
reader.Close();
conn.Close();
/*con.Open();
string cs = @"select from Member where First_Name=@'" + TextBox1.Text + "',Middle_Name=@'" + TextBox2.Text + "',";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(cs, con);
da.Fill(ds,"Member");
//DataTable dt = ds.Tables["Member"];
DetailsView1.DataSource = da;
Label5.Text = "suceed";
con.Close();*/


//Response.Redirect("Default4.aspx");


}
}

No comments:

Post a Comment