请教大虾们个 关于数据库连接的问题~~~~
connection为 连接字符串SqlConnection myconnection = new SqlConnection(connection);
SqlCommand mycommand = new SqlCommand();
mycommand.Connection = myconnection;
mycommand.CommandType = CommandType.Text;
mycommand.CommandText = sql;
myconnection.Open();
SqlDataAdapter mydataadapter = new SqlDataAdapter();
mydataadapter.SelectCommand = mycommand;
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset, "个人信息");
BindingSource bindingsource1 = new BindingSource();
bindingsource1.DataSource = mydataset;
bindingsource1.DataMember = "个人信息";
运行时就在 mydataadapter.Fill(mydataset, "个人信息"); 这句处 出现异常 --- ExecuteReader: CommandText 属性尚未初始化-----
指教下吧 本人 菜鸟~~~
--------------------编程问答-------------------- mycommand.CommandText = sql;
换成mycommand.CommandText="select * from 个人信息" --------------------编程问答-------------------- mycommand.CommandText = sql;
sql未赋值吧 --------------------编程问答--------------------
using (SqlConnection myconnection = new SqlConnection(connection))
{
SqlCommand mycommand = myconnection.CreateCommand();
mycommand.CommandType = CommandType.Text;
mycommand.CommandText = sql;
myconnection.Open();
SqlDataAdapter mydataadapter = new SqlDataAdapter(mycommand);
DataSet mydataset = new DataSet();
mydataadapter.Fill(mydataset, "个人信息");
BindingSource bindingsource1 = new BindingSource();
bindingsource1.DataSource = mydataset;
bindingsource1.DataMember = "个人信息";
myconnection.Close();
}
看看SqlDataAdapter,SqlCommand 的构造函数吧。 --------------------编程问答-------------------- sql 我定义成了 public 的 已经赋过值的 ~~~~ --------------------编程问答-------------------- DataSet ds=new DataSet ();
using (SqlConnection conn =
new SqlConnection(TSConfig.GetConnectionString()))
{
SqlCommand sqlCmd = new SqlCommand(strSelect, conn);
cmd.CommandType=CommandType.Text ;
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=cmd;
try
{
sda.Fill (ds);
}
catch(Exception e)
{
throw e;
}
}
贴出代码 --------------------编程问答-------------------- SqlDataAdapter mydataadapter = new SqlDataAdapter(mycommand);
你看下SqlDataAdapter()有没有参数
补充:.NET技术 , C#