private void BindData()
{
string cmdText = "select * from RX_TABLE1 ORDER BY Staff_ID";
SqlConnection myConnection = new SqlConnection(connectionString);
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
myConnection.Open();
OscarDataReader dr = myCommand.ExecuteReader();
StaffList1.DataSource = dr; StaffList1.DataBind();
dr.Close();
myConnection.Close();
}StaffList1.DataBind();这里抛异常,未将对象引用设置到对象的实例...不知道怎么错了 小弟初学 请教 谢谢大家
{
string cmdText = "select * from RX_TABLE1 ORDER BY Staff_ID";
SqlConnection myConnection = new SqlConnection(connectionString);
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
myConnection.Open();
OscarDataReader dr = myCommand.ExecuteReader();
StaffList1.DataSource = dr; StaffList1.DataBind();
dr.Close();
myConnection.Close();
}StaffList1.DataBind();这里抛异常,未将对象引用设置到对象的实例...不知道怎么错了 小弟初学 请教 谢谢大家
换SqlDataReader 试试
{
string cmdText = "select * from RX_TABLE1 ORDER BY Staff_ID";
SqlConnection myConnection = new SqlConnection(connectionString);
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
StaffList1.DataSource = dr; StaffList1.DataBind();
dr.Close();
myConnection.Close();
} StaffList1.DataBind();这里抛异常,未将对象引用设置到对象的实例...问题还是这样子的
http://www.cnblogs.com/chairongzhen/articles/1089850.html
SqlDataReader dr = myCommand.ExecuteReader(); //你在这里设置断点看一下,你的dr中是什么
StaffList1.DataSource = dr; StaffList1.DataBind();
可要是ds的话怎么用呢,ds不是一个表要怎么用呢
可以解答一下吗