string connectionstring = "server=localhost;database=Northwind;uid=sa;pwd=dashijie";
SqlConnection mySqlConnection = new SqlConnection(connectionstring);
string commandstring = "SELECT TOP 10 CustomerID,CompanyName,ContactName,Address" +
" FROM Customers" +" ORDER BY CustomerID";
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = commandstring;
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = mySqlCommand;
DataSet myDataSet = new DataSet();//read data to myDataSet
mySqlConnection.Open();
mySqlDataAdapter.Fill(myDataSet,"Customers");//出错之处
mySqlConnection.Close();
DataTable myDataTable = new DataTable();
myDataTable = myDataSet.Tables["Customers"]; foreach (DataRow myDataRow in myDataTable.Rows)
{
Console.WriteLine("CustomerID="+myDataRow["CustomerID"]);
Console.WriteLine("CompanyName="+myDataRow["CompanyName"]);
Console.WriteLine("ContactName="+myDataRow["ContactName"]);
Console.WriteLine("Address="+myDataRow["Address"]);
} 错误提示是第1行' '附近有语法错误,郁闷……请指点,以后遇到这类问题应该怎么找?
SqlConnection mySqlConnection = new SqlConnection(connectionstring);
string commandstring = "SELECT TOP 10 CustomerID,CompanyName,ContactName,Address" +
" FROM Customers" +" ORDER BY CustomerID";
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText = commandstring;
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = mySqlCommand;
DataSet myDataSet = new DataSet();//read data to myDataSet
mySqlConnection.Open();
mySqlDataAdapter.Fill(myDataSet,"Customers");//出错之处
mySqlConnection.Close();
DataTable myDataTable = new DataTable();
myDataTable = myDataSet.Tables["Customers"]; foreach (DataRow myDataRow in myDataTable.Rows)
{
Console.WriteLine("CustomerID="+myDataRow["CustomerID"]);
Console.WriteLine("CompanyName="+myDataRow["CompanyName"]);
Console.WriteLine("ContactName="+myDataRow["ContactName"]);
Console.WriteLine("Address="+myDataRow["Address"]);
} 错误提示是第1行' '附近有语法错误,郁闷……请指点,以后遇到这类问题应该怎么找?
" FROM Customers" +" ORDER BY CustomerID";
这句有问题吧, 这么看不出来,你到查询分析器里执行看看
DataTable dt=myDataSet.Tables[0];
Message=第1行 ' '附近有语法错误
你设置表格名为Customers没?用6L的方法吧~
这个DataSourse应该是TABLE
自己挨着再检查下 可以单步调试下
mySqlConnection.Open();
mySqlDataAdapter.Fill(myDataSet,"Customers");//出错之处
mySqlConnection.Close();
这里的写法是没问题的,看哈SQL语句吧,在数据库里去运行哈看