coneverting oledb code to connect to remote sqlserver

[sansat6699]

i have some oledb code made in c#(vs 2005) it is for local msaccess file. i want to conevert the code for sql server where connection string placed in web.config file seperately. please help me.here is code

private void buildGrid() { string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; conStr += Server.MapPath("~/common/db/demo.mdb"); System.Data.OleDb.OleDbConnection dbCon = new System.Data.OleDb.OleDbConnection(conStr); dbCon.Open(); string sql = "SELECT * FROM Posts ORDER BY LastPostDate DESC"; System.Data.OleDb.OleDbDataAdapter dbAdapter = new System.Data.OleDb.OleDbDataAdapter(sql, dbCon); DataSet ds = new DataSet(); dbAdapter.Fill(ds); ds.Tables[0].TableName = "Inbox"; Grid1.DataSource = ds; }

healp me please

[aspnetguy]

place your connection string in appSettings

<appSettings>		<add key="ConnectionString" value="Data Source=(local);Initial Catalog=dbname;Trusted_Connection=yes;"/>	</appSettings>

then

private void buildGrid(){	SqlConnection dbCon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);	dbCon.Open();		string sql = "SELECT * FROM Posts ORDER BY LastPostDate DESC";	SqlDataAdapter dbAdapter = new SqlDataAdapter(sql, dbCon);	DataSet ds = new DataSet();	dbAdapter.Fill(ds);	ds.Tables[0].TableName = "Inbox";		Grid1.DataSource = ds;}

[sansat6699]

place your connection string in appSettings

<appSettings>		<add key="ConnectionString" value="Data Source=(local);Initial Catalog=dbname;Trusted_Connection=yes;"/>	</appSettings>

then

private void buildGrid(){	SqlConnection dbCon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);	dbCon.Open();		string sql = "SELECT * FROM Posts ORDER BY LastPostDate DESC";	SqlDataAdapter dbAdapter = new SqlDataAdapter(sql, dbCon);	DataSet ds = new DataSet();	dbAdapter.Fill(ds);	ds.Tables[0].TableName = "Inbox";		Grid1.DataSource = ds;}

thank you man thanks very much i will check it

[sansat6699]

thank you man thanks very much i will check it

code giving error as "connection string not initialized"at dbcon.open();

[aspnetguy]

did you add the connection string to web.config?

[sansat6699]

did you add the connection string to web.config?

yes in <connectionstring></connectionstring> section as i am using .net2.0

[aspnetguy]

I put it in appSettings and use the code I showed you earlier.

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">	<appSettings>		<add key="ConnectionString" value="Data Source=(local);Initial Catalog=dbname;Trusted_Connection=yes;"/>	</appSettings>......</configuration