已有打开的与此 Command 相关联的 DataReader,必须首先将它关闭。
代码如下:
static void Main(string[] args)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
connectionStringBuilder.InitialCatalog = "DWYS";
connectionStringBuilder.DataSource = "127.0.0.1";
connectionStringBuilder.UserID = "sa";
connectionStringBuilder.Password = "meirenai.";
connectionStringBuilder.MultipleActiveResultSets = true;
SqlConnection sqlConnection = new SqlConnection(connectionStringBuilder.ToString());
sqlConnection.Open();
SqlCommand cmd = new SqlCommand("SELECT [username],[password] FROM [dbo].[user]", sqlConnection);
SqlDataReader sqlDataReader = cmd.ExecuteReader();
Console.WriteLine(cmd.ExecuteNonQuery());
sqlConnection.Close();
}
求解答