public static readonly string ConnStr = "server=.;uid=sa;pwd=;database=Fly";

public static void FillDataTable(string sql, DataTable dt, params SqlParameter[] param)
{
SqlConnection cn = new SqlConnection(ConnStr);
SqlDataAdapter ada = new SqlDataAdapter(sql, cn);
ada.Fill(dt);
cn.Close();
cn.Dispose();
}

在web.config的appsettings中添加add key="database" value="server=();database=databasename;User= ;pwd= "

可以用SQLCONNECTION对象来连接数据库

举例子：用一个DATAGRID控件

SqlConnection con=new SqlConnection("uid=sa;pwd=;database=数据库名;server=.");

SqlDataAdapter da=new SqlDataAdapter ("select * from 表名",con);

DataSet ds=new DataSet();

da.Fill(ds,"表名");

DataGrid1.DataSource=ds.Tables[0];

DataGrid1.DataBind();