谁能给几个asp(c#)数据库连接详细例子

using System.Data.SqlClient;

string connstr="Data Source=XMJZB-NW-7032\SQLEXPRESS;Initial Catalog=yptest;Persist Security Info=True;User ID=test;Password=test01";
qlConnection myConnection = new SqlConnection(connstr);
myConnection.Open();
DataSet dataSet = new DataSet();
string sqlText="Selet * from table1";
SqlDataAdapter da = new SqlDataAdapter(sqlText,myConnection);

try
{
///读取数据
da.Fill(dataSet);
//...........
}
catch(Exception ex)
{
///记录错误日志
//SystemError.CreateErrorLog(ex.Message);
}