總結了一下,在任何時候都可以使用sqlcommand物件來完成您想要的操作.使用sqlcommand物件來返回資料集合的方法 string strconn="data source=billgates;initial catalog=test;integrated security=SSPI;"; SqlConnection conn=new SqlConnection(strconn); conn.Open(); SqlCommand sqlcmd=new SqlCommand(); sqlcmd.CommandText ="select * from student"; sqlcmd.Connection=conn; SqlDataAdapter adp=new SqlDataAdapter(sqlcmd); DataTable dt=new DataTable(); adp.Fill(dt); dataGrid1.DataSource=dt; 使用sqlcommand物件來返回SQL執行正確與否 string strconn="data source=billgates;initial catalog=test;integrated security=SSPI;"; SqlConnection conn=new SqlConnection(strconn); conn.Open(); SqlCommand sqlcmd=new SqlCommand(); sqlcmd.CommandText ="select * from student"; sqlcmd.Connection=conn; try { sqlcmd.ExecuteNonQuery(); MessageBox.Show("success"); } catch { MessageBox.Show("false"); } 使用sqlcommand物件來操作儲存過程 string strconn="data source=billgates;initial catalog=test;integrated security=SSPI;"; SqlConnection conn=new SqlConnection(strconn); conn.Open(); SqlCommand sqlcmd=new SqlCommand(); sqlcmd.CommandText ="a"; sqlcmd.CommandType=CommandType.StoredProcedure ; sqlcmd.Connection=conn; sqlcmd.Parameters.Add("@param1",textBox1.Text.Trim()); sqlcmd.Parameters.Add("@param2",textBox2.Text.Trim()); sqlcmd.Parameters.Add("@param3",textBox3.Text.Trim()); SqlDataAdapter adp=new SqlDataAdapter(sqlcmd); DataTable dt=new DataTable(); adp.Fill(dt); dataGrid1.DataSource=dt;