帮忙写份连接数据库的文件(SqlServer C#)

这是一个添加下拉菜单的例子:

Web.Config文件里这样写:
<appSettings>
<add key="sqlserver" value="server=(local);database=你的数据库名;uid=sa;pwd="/>
</appSettings>

cs文件里:
SqlConnection myconn = new SqlConnection();
myconn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["sqlserver"];
myconn.Open();
SqlCommand cmd = myconn.CreateCommand();
SqlDataReader rec = null;

cmd.CommandText = "select distinct name from zzmm"; 所属类别绑定

rec = cmd.ExecuteReader();
this.zzmm.Items.Clear();
while (rec.Read())
{
this.zzmm.Items.Add(new ListItem(Convert.ToString(rec["name"]), Convert.ToString(rec["name"])));
}
rec.Close();

cmd.Dispose();
myconn.Close();
myconn.Dispose();