DataSet ds = new DataSet();
SqlDataAdapter cmd = new SqlDataAdapter("Select * FROM event", con);
cmd.Fill(ds, "Table");
一次又一次地遇到相同的错误,尝试了所有内容
请帮忙
编辑
尝试这样,其中缺少的元素可能是命令类型,该命令类型添加在下面的代码中,并且还为 databse 打开连接
SqlConnection sqlcon;
using(sqlcon = new SqlConnection("Data Source=Servername;Initial
Catalog=Marketing;Integrated Security=SSPI"))
{
SqlCommand cmd = new SqlCommand("Select * FROM event", sqlcon);
cmd.CommandType = CommandType.Text;
sqlcon.Open();
da = new SqlDataAdapter(sqlcmd);
da.Fill(dt);
}
注意:使用然后全部在 using 语句中处理。 上面也添加了
在调用 fill 方法之前执行此操作
SqlConnection conn= new
SqlConnection("Data Source=Servername;Initial Catalog=Marketing;Integrated Security=SSPI");
SqlDataAdapter cmd = new SqlDataAdapter("Select * FROM event", con);
cmd.Fill(ds, "Table");
SqlConnection myconn = new SqlConnection(YourConnString);
SqlCommand mycmd = new SqlCommand();
try{ myconn.Open(); }
catch (Exception ex) { MessageBox("Error");}
mycmd.Connection = myconn;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
String sqlStr = "Select * FROM event";
SqlDataAdapter da = new SqlDataAdapter(sqlStr, myconn);
da.Fill(ds);
dt = ds.Tables[0];