c# - 无效的对象名称(即使存在)

Question

这是我的代码:

   InitializeComponent();
   SqlConnection myConnection = new SqlConnection("data source = DESKTOP-77FA1JE;" +
             "user id = DESKTOP-77FA1JE\\Chanloi" +
             "initial catalog = TransactionProcessingSystem;" +
             "integrated security = SSPI");

   myConnection.Open();

    SqlCommand myCommand = new SqlCommand("select * from UserAccounts", myConnection);
   SqlDataReader myReader = myCommand.ExecuteReader();

   BindingSource mySource = new BindingSource();
   mySource.DataSource = myReader;

   dataGridView1.DataSource = mySource;

   myConnection.Close();

我收到此错误:

System.Data.SqlClient.SqlException: 'Invalid object name 'UserAccounts'.'

Answer 1

非常简单-您的数据库中没有名为UserAccounts的表。
请尝试dbo.UserAccounts