请大家帮我看看这段代码的问题！（vb.net)

（VB）大家帮我看看这段代码有什么问题~

这段代码在Win7 + VB2010下完全正常，有图为证：

嗯，是的有问题，

你要把要删除的列表的那一行的关键字记录下来，删除列表之后利用关键字删除相关数据库中的内容。
我自己写的代码你看下，我是先定义一个全局变量xx，用他来接收关键字保存起来。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using r2o;

namespace Dagl.systemmanage.usermanage
{
public partial class UserSeeForm1 : Form
{
public static string xx;
public UserSeeForm1()
{
InitializeComponent();
button1.Visible = false;
button2.Visible = false;
button3.Visible = false;
compile();
//try
//{
// SqlOperater mo = new SqlOperater();
// r2o.dataclass dl = new r2o.dataclass();
// String sql = "SELECT * FROM users ";
// DataSet dataSet = dl.getDataSet(sql, " users");
// dataGridView1.AutoGenerateColumns = true;
// dataGridView1.DataSource = dataSet.Tables[0];
// //SqlDataAdapter da = new SqlDataAdapter(sql, "recordIF");

//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//}
}

private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Close();
this.Dispose();
}

private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
linkLabel1.Visible = false;
linkLabel2.Visible = false;
linkLabel3.Visible = false;
button1.Visible = true;
button2.Visible = true;
button3.Visible = true;
}

private void button2_Click(object sender, EventArgs e)
{
mainForm mf = new mainForm();
mf.Show();
this.Close();
}

private void button3_Click(object sender, EventArgs e)
{
this.Close();
this.Dispose();
}

private void button1_Click(object sender, EventArgs e)
{

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Selected)
{
xx = dataGridView1.Rows[i].Cells[1].Value.ToString();
}
}
DataRowView drv = dataGridView1.SelectedRows[0].DataBoundItem as DataRowView;
drv.Delete();
SqlOperater mo = new SqlOperater();
string sql = "delete from users where userName='"+xx+"'";
mo.execute(sql);
if (mo.read())
{
MessageBox.Show("删除数据成功！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
compile();
return;

}
public void compile()
{
try
{
SqlOperater mo = new SqlOperater();
r2o.dataclass dl = new r2o.dataclass();
String sql = "SELECT * FROM users ";
DataSet dataSet = dl.getDataSet(sql, " users");
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = dataSet.Tables[0];
//SqlDataAdapter da = new SqlDataAdapter(sql, "recordIF");

}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}

private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
mainForm mf = new mainForm();
mf.Show();
this.Close();
}

}
}
希望对你有帮助哈

值日教师表 where 值日教师ID=" & ID & " and 密码 =" & PassWord & ""

文本类型,用 单引号圈起来

改成这个
strSQL = "select * from 值日教师表 where 值日教师ID='" & ID & "' and 密码 ='" & PassWord & "' "

---

请大家帮我看看这段代码的问题！（vb.net)视频