Isto kao sto bi napravio konekciju u desktop aplikaciji:
Code (csharp):
public string GetStringValue
()
{
string retVal
= string.Empty;
string connStr
= ConfigurationManager
.ConnectionStrings["LocalSqlServer"];
using (SqlConnection conn
= new SqlConnection
(connStr
))
{
using (SqlCommand cmdSelectString
= new SqlCommand
("select [column_name] from table_tbl", conn
))
{
conn
.Open();
retVal
= cmdSelectString
.ExecuteScalar() as string;
}
}
return retVal
;
}
Pri cemu ti je setovana sekcija u web.config:
Code (xml):
<connectionStrings>
<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=database_name;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>