主题:请大家帮忙,小弟在这里谢谢
我要做一个学生管理系统,可是在数据查询这里出了问题
代码如下:
SqlConnection myConn = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=学生学籍管理系统;Data Source=ADMIN-66EF057D8");
SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT * FROM [入学注册表]",myConn);
SqlCommandBuilder myCmdBuilder = new SqlCommandBuilder(myAdapter);
DataSet ds = new DataSet();
myAdapter.Fill(ds,"[入学注册表]");
DataColumn[] Keys = new DataColumn[1];
Keys[0] = ds.Tables["入学注册表"].Columns["入学注册表"];
ds.Tables["入学注册表"].PrimaryKey = Keys;
DataRow dr = ds.Tables["入学注册表"].Rows.Find(this.txtStudentName.Text);
if(dr == null)
{
MessageBox.Show("没有这个人,请重新查找");
DataRow dRow =ds.Tables["入学注册表"].NewRow();
dRow["学生姓名"] = this.txtStudentName.Text;
ds.Tables["入学注册表"].Rows.Add(dRow);
if((dr = ds.Tables["入学注册表"].Rows.Find(this.txtStudentName.Text))!=null)
{
MessageBox.Show("已找到此人");
}
else
{
MessageBox.Show("没有此人");
}
}
else
{
myAdapter.Update(ds,"[入学注册表]");
myConn.Close();
}
一直调不过去,说对象没有被实例化!
代码如下:
SqlConnection myConn = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=学生学籍管理系统;Data Source=ADMIN-66EF057D8");
SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT * FROM [入学注册表]",myConn);
SqlCommandBuilder myCmdBuilder = new SqlCommandBuilder(myAdapter);
DataSet ds = new DataSet();
myAdapter.Fill(ds,"[入学注册表]");
DataColumn[] Keys = new DataColumn[1];
Keys[0] = ds.Tables["入学注册表"].Columns["入学注册表"];
ds.Tables["入学注册表"].PrimaryKey = Keys;
DataRow dr = ds.Tables["入学注册表"].Rows.Find(this.txtStudentName.Text);
if(dr == null)
{
MessageBox.Show("没有这个人,请重新查找");
DataRow dRow =ds.Tables["入学注册表"].NewRow();
dRow["学生姓名"] = this.txtStudentName.Text;
ds.Tables["入学注册表"].Rows.Add(dRow);
if((dr = ds.Tables["入学注册表"].Rows.Find(this.txtStudentName.Text))!=null)
{
MessageBox.Show("已找到此人");
}
else
{
MessageBox.Show("没有此人");
}
}
else
{
myAdapter.Update(ds,"[入学注册表]");
myConn.Close();
}
一直调不过去,说对象没有被实例化!