3/21/2012

Quick Way to get Datatable from a SQL Server DB

string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["myconn"].ConnectionString;
DataTable dtExcentive = null;
SqlConnection sConn = null;
using (sConn = new SqlConnection(connstr))
{
sConn.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM k_m_indicators",sConn);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
dtExcentive.Load(sqlDataReader);
}
return dtExcentive;

No comments:

Post a Comment