| Author: RamarajSundaram 27 Dec 2006 | Member Level: Diamond | Rating:  Points: 2 |
con =new SqlConnection(ConfigurationSettings.AppSettings["Myconnection"]);
con.Open();
connectionstring is maintained in web.config like as,
<appSettings>
<add key="Myconnection" value="packet size=4096;integrated security=SSPI;data source='.';persist security info=False;initial catalog=test"/>
</appSettings>
|
| Author: Arvind Singh 27 Dec 2006 | Member Level: Bronze | Rating: Points: 2 |
1. add namespace for sql server.
using System.Data.SqlClient;
2. string cnStr ="Server=(localhost);user id=sa;pwd=;Data Source=dbname";
3. SqlConnection conn=new SqlConnection(cnstr);
4. conn.open()
|
| Author: Pankaj Mishra 27 Dec 2006 | Member Level: Diamond | Rating: Points: 2 |
www.connectionstrings.com
|
| Author: DotNetGuts (DNG) 28 Dec 2006 | Member Level: Diamond | Rating: Points: 2 |
<appSettings>
<add key ="ConnectionString" value="Server=192.168.0.99;Database=Northwind;uid=sa;pwd=abc;"/>
</appSettings>
protected void Button1_Click(object sender, EventArgs e)
{
string strCon = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
SqlConnection con = new SqlConnection(strCon);
string str;
str = "select * from sysobjects where xtype='U'";
SqlDataAdapter da = new SqlDataAdapter(str, con);
DataSet ds = new DataSet();
da.Fill(ds);
DropDownList1.DataSource = ds.Tables[0];
DropDownList1.DataTextField = ds.Tables[0].Columns[0].ToString();
DropDownList1.DataValueField = ds.Tables[0].Columns[1].ToString();
DropDownList1.DataBind();
con.Close();
}
|