Monday, January 19, 2009

connection string with web.config

string connectionString = ConfigurationManager.ConnectionStrings["azeem12"].ConnectionString;


SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("insert into tbl (name)values ('ee') ", con);
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}

1 comment:

  1. add name="azeem12" connectionString="Password=;Persist Security Info=True;User ID=caarridc;Initial Catalog=;Data Source="
    providerName="System.Data.SqlClient;"

    ReplyDelete