第一个错误是catch (Exception e) 提示:
D:\WebDown\COCOWO\peizhi.cs(247): 不能在此范围内声明名为“e”的局部变量,因为这样会使“e”具有不同的含义,而它已经用于“父级或当前”范围以表示其他内容第二个错误是myCmd.ExecuteNonQuery();提示:
运行的时候报错,请大家帮我看看!
private void button3_Click(object sender, System.EventArgs e)
{
string Server=this.peizhi_Server.Text;
string DataBase=this.peizhi_DataBase.Text;
string uid=this.peizhi_uid.Text;
string pwd=this.peizhi_pwd.Text;
string TimeOut=this.peizhi_TimeOut.Text; string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\WebDown\\COCOWO\\peizhi.MDB";
string strSQL = "INSERT INTO peizhisql (Server,DataBase,uid,pwd,TimeOut ) VALUES('"+Server+"','"+DataBase+"','"+uid+"','"+pwd+"','"+TimeOut+"')" ;
// 实例化OleDbCommand对象
OleDbConnection myConn = new OleDbConnection(strDSN); // 实例化OleDbCommand对象
OleDbCommand myCmd = new OleDbCommand(strSQL, myConn); // 打开数据库,执行插入SQL语句
try
{
myConn.Open();
myCmd.ExecuteNonQuery();
MessageBox.Show("插入操作成功!");
}
catch (Exception e)
{
MessageBox.Show("数据库连接错误");
}
finally
{
myConn.Close();
}
}
D:\WebDown\COCOWO\peizhi.cs(247): 不能在此范围内声明名为“e”的局部变量,因为这样会使“e”具有不同的含义,而它已经用于“父级或当前”范围以表示其他内容第二个错误是myCmd.ExecuteNonQuery();提示:
运行的时候报错,请大家帮我看看!
private void button3_Click(object sender, System.EventArgs e)
{
string Server=this.peizhi_Server.Text;
string DataBase=this.peizhi_DataBase.Text;
string uid=this.peizhi_uid.Text;
string pwd=this.peizhi_pwd.Text;
string TimeOut=this.peizhi_TimeOut.Text; string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\WebDown\\COCOWO\\peizhi.MDB";
string strSQL = "INSERT INTO peizhisql (Server,DataBase,uid,pwd,TimeOut ) VALUES('"+Server+"','"+DataBase+"','"+uid+"','"+pwd+"','"+TimeOut+"')" ;
// 实例化OleDbCommand对象
OleDbConnection myConn = new OleDbConnection(strDSN); // 实例化OleDbCommand对象
OleDbCommand myCmd = new OleDbCommand(strSQL, myConn); // 打开数据库,执行插入SQL语句
try
{
myConn.Open();
myCmd.ExecuteNonQuery();
MessageBox.Show("插入操作成功!");
}
catch (Exception e)
{
MessageBox.Show("数据库连接错误");
}
finally
{
myConn.Close();
}
}
有e了,所以catch (Exception e)就出错,
改catch (Exception e)为catch (Exception ee),总之不要再用e