Question

ASP.NET C#链接SQL数据库代码

ASP.NET C# 数据库SQL 2008 R2 登陆名sjk 密码123456

Answer 1

SqlConnection con = new SqlConnection();
con.ConnectionString = "server=.;database=数据库名称;uid=sjk;pwd=123456";
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.Text;
com.CommandText = "SQL的语句";
SqlDataReader dr = com.ExecuteReader();
dr.Close();
con.Close();

追问

com.CommandText = "SQL的语句"; 是要写什么的?

追答

SQL语句没学过吗？