2023年8月3日发(作者：)
Access数据操作Update⽅法using ; //这⾥要引⽤OleDb空间
public partial class addInfo : { //数据库连接字符串 static string strCon = @"provider = .4.0;Data source = |DataDirectory|"; //以上⽅法为连接ACCESS 特定数据⽬录APP_DATA 下数据⽂件的⽅法。注意DATADIRECTORY 的使⽤。 //申明连接数据源的对象和对数据源进⾏操作的对象 OleDbConnection con = new OleDbConnection(strCon); OleDbCommand cmd = new OleDbCommand(); //点击按钮添加记录
protected void Page_Load(object sender, EventArgs e) { ly = false; = "这是学号"; ly = true; = "这是准考证号"; = "这是姓名"; if (!Back) { } } protected void Button1_Click(object sender, EventArgs e) {
string A0 = ; //0.学号 string A1 = ; //1.准考证号 string A2 = ; //2.姓名 string A3 = ; //3.⼩学⼊学年⽉ string A4 = ; //4.班号 string A5 = ; //5.学⽣类别 string A6 = (); //6.⾝份证号 string A7 = ; //7.性别 string A8 = (); //8.出⽣⽇期 string A9 = (); //9.出⽣地 string A10 = ;//10.是否独⽣⼦⼥ string A11 = (); ; //11.籍贯 string A12 = ; //12.民族 string A13 = (); //13.户⼝所在地 string A14 = ; //14.是否农民⼯⼦⼥ string A15 = ; //15.是否贫困⽣ string A16 = (); //16.家庭住址 string A17 = (); //17.家庭邮政编码 string A18 = (); //18.家庭联系⼈ string A19 = ; //19.家族联系⼈关系 string A20 = ();//20.家长姓名 string A21 = (); ; //21.职业 string A22 = ; ; //22.是否是监护⼈
// string LBCLASS; // if (d) // { // LBCLASS = ; //3.学校名 // } // else // { // LBCLASS = ; // }
//要插⼊记录的sql语句// string insertText = "insert intoITmdb(A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23) values('" + A0+ "','" + A1 + "','" + A2 + "','" + A3 + "','" + A4 + "','" + A5 + "','" + A6 + "','" + A7 + "','" + A8 + "','" + A9 + "','" + A10 + "','" + A11+ "','" + A12 + "','" + A13 + "','" + A14 + "','" + A15 + "','" + A16 + "','" + A17 + "','" + A18 + "','" + A19 + "','" + A20 + "','" + A21+ "','" + A22 + "')";
// 要更新的学⽣信息 string insertText = "update gyMDB SET A3='" +A3+ "',A4='"+A4+"',A5='"+A5+"',A6='"+A6+"',A7='"+A7+"',A8='"+A8+"',A9='"+A9+"',A10='"+A10+"',A11='"+A11+"',A12='"+A12+"',A13='"+A13+"',A14='"+A14+"',A15='"+A15+"',A16='"+A16+"',A17='"+A17+"',A18='"+A18+"',A19='"+A19+"',A20='"+A20+"',A21='"+A21+"',A22='"+A22+"'where A0='1'";// string insertText = "update gyMDB SET A3='" + A3 + "',A4='" + A4 + "',A5='" + A5 + "',A6='" + A6 + "',A7='" + A7 +"',A8='" + A8 + "',A9='" + A9 + "',A10='" + A10 + "',A11='"+A11+"',A12='" +A12+ "',A15='" + A3 + "',A17='" + A3 + "',A18='"+ A3 + "',A19='" + A3 + "',A20='" + A3 + "' where A0='1'";
// string insertText = "update gyMDB SET A3='" + + "' where A0='1'"; //成功更新代码 // string insertText = "update gyMDB SET A3='" + A3 + "' where A0='1'"; //成功更新代码 //数据源打开EACHER,TJREN, (); //设置操作对象的数据源 tion = con; //要执⾏的SQL语句 dText = insertText; //执⾏操作 eNonQuery(); //数据源关闭 ();
//加⼊显⽰其它⽹页效果和弹出效果。 // ("");
// (""); ("");
}
2023年8月3日发(作者：)
Access数据操作Update⽅法using ; //这⾥要引⽤OleDb空间
public partial class addInfo : { //数据库连接字符串 static string strCon = @"provider = .4.0;Data source = |DataDirectory|"; //以上⽅法为连接ACCESS 特定数据⽬录APP_DATA 下数据⽂件的⽅法。注意DATADIRECTORY 的使⽤。 //申明连接数据源的对象和对数据源进⾏操作的对象 OleDbConnection con = new OleDbConnection(strCon); OleDbCommand cmd = new OleDbCommand(); //点击按钮添加记录
protected void Page_Load(object sender, EventArgs e) { ly = false; = "这是学号"; ly = true; = "这是准考证号"; = "这是姓名"; if (!Back) { } } protected void Button1_Click(object sender, EventArgs e) {
string A0 = ; //0.学号 string A1 = ; //1.准考证号 string A2 = ; //2.姓名 string A3 = ; //3.⼩学⼊学年⽉ string A4 = ; //4.班号 string A5 = ; //5.学⽣类别 string A6 = (); //6.⾝份证号 string A7 = ; //7.性别 string A8 = (); //8.出⽣⽇期 string A9 = (); //9.出⽣地 string A10 = ;//10.是否独⽣⼦⼥ string A11 = (); ; //11.籍贯 string A12 = ; //12.民族 string A13 = (); //13.户⼝所在地 string A14 = ; //14.是否农民⼯⼦⼥ string A15 = ; //15.是否贫困⽣ string A16 = (); //16.家庭住址 string A17 = (); //17.家庭邮政编码 string A18 = (); //18.家庭联系⼈ string A19 = ; //19.家族联系⼈关系 string A20 = ();//20.家长姓名 string A21 = (); ; //21.职业 string A22 = ; ; //22.是否是监护⼈
// string LBCLASS; // if (d) // { // LBCLASS = ; //3.学校名 // } // else // { // LBCLASS = ; // }
//要插⼊记录的sql语句// string insertText = "insert intoITmdb(A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23) values('" + A0+ "','" + A1 + "','" + A2 + "','" + A3 + "','" + A4 + "','" + A5 + "','" + A6 + "','" + A7 + "','" + A8 + "','" + A9 + "','" + A10 + "','" + A11+ "','" + A12 + "','" + A13 + "','" + A14 + "','" + A15 + "','" + A16 + "','" + A17 + "','" + A18 + "','" + A19 + "','" + A20 + "','" + A21+ "','" + A22 + "')";
// 要更新的学⽣信息 string insertText = "update gyMDB SET A3='" +A3+ "',A4='"+A4+"',A5='"+A5+"',A6='"+A6+"',A7='"+A7+"',A8='"+A8+"',A9='"+A9+"',A10='"+A10+"',A11='"+A11+"',A12='"+A12+"',A13='"+A13+"',A14='"+A14+"',A15='"+A15+"',A16='"+A16+"',A17='"+A17+"',A18='"+A18+"',A19='"+A19+"',A20='"+A20+"',A21='"+A21+"',A22='"+A22+"'where A0='1'";// string insertText = "update gyMDB SET A3='" + A3 + "',A4='" + A4 + "',A5='" + A5 + "',A6='" + A6 + "',A7='" + A7 +"',A8='" + A8 + "',A9='" + A9 + "',A10='" + A10 + "',A11='"+A11+"',A12='" +A12+ "',A15='" + A3 + "',A17='" + A3 + "',A18='"+ A3 + "',A19='" + A3 + "',A20='" + A3 + "' where A0='1'";
// string insertText = "update gyMDB SET A3='" + + "' where A0='1'"; //成功更新代码 // string insertText = "update gyMDB SET A3='" + A3 + "' where A0='1'"; //成功更新代码 //数据源打开EACHER,TJREN, (); //设置操作对象的数据源 tion = con; //要执⾏的SQL语句 dText = insertText; //执⾏操作 eNonQuery(); //数据源关闭 ();
//加⼊显⽰其它⽹页效果和弹出效果。 // ("");
// (""); ("");
}
发布评论