Tuesday, February 08, 2005 3:47 AM
The nice thing about working fast and accurately is that you finish your work ahead of schedule. Like me if I finish my work early I'd make sure that I do something important/productive rather than waiting and do nothing. So here's something I discovered in .Net 2005 Beta 1.
ConnectionStringSettingsCollection cssc = ConfigurationSettings.ConnectionStrings;
string connectionstring = cssc["Main"].ConnectionString;
string sql = "select * from Customers";
SqlConnection conn = new SqlConnection(connectionstring);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
DataTableReader dtr = dt.GetDataReader();
while (dtr.Read())
{
Response.Write(string.Format("{0}\n", dtr["ContactName"].ToString()));
}
dtr.Close();