请大家帮我看看这段代码的问题！（vb.net)
\uff08VB\uff09\u5927\u5bb6\u5e2e\u6211\u770b\u770b\u8fd9\u6bb5\u4ee3\u7801\u6709\u4ec0\u4e48\u95ee\u9898\u8fd9\u6bb5\u4ee3\u7801\u5728Win7 + VB2010\u4e0b\u5b8c\u5168\u6b63\u5e38\uff0c\u6709\u56fe\u4e3a\u8bc1\uff1a
\u55ef\uff0c\u662f\u7684\u6709\u95ee\u9898\uff0c
你要把要删除的列表的那一行的关键字记录下来，删除列表之后利用关键字删除相关数据库中的内容。我自己写的代码你看下，我是先定义一个全局变量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 & "' "
绛旓細Memo杩欎釜鏄繚鐣欏瓧锛屼笉鑳界洿鎺ュ仛瀛楁鍚嶇殑锛屽疄鍦ㄨ鐢ㄥ繀椤诲姞鏂规嫭鍙凤紝鍗 sqlProduct=sqlProduct & " ID,Product_Id,BigClassName,SmallClassName,IncludePic,Title,Price,Spec,Unit,[Memo],DefaultPicUrl,UpdateTime,Hits from Product where Passed=True "寤鸿浣犲敖閲忎笉瑕佺敤鍗曚釜鑻辨枃鍗曡瘝鍋氬瓧娈靛悕锛屼互鍏嶄笉灏忓績鍜...
绛旓細d = b * b - 4 * a * c(a,b,c) 杩欎竴琛屾妸(a,b,c)鍘绘帀銆傚叾浠栧簲璇ユ病闂锛屽彧瑕佷綘浣跨敤鐨勬槸2.x鐗堟湰鐨刾ython銆
绛旓細浣犺鎶婅鍒犻櫎鐨勫垪琛ㄧ殑閭ｄ竴琛岀殑鍏抽敭瀛楄褰曚笅鏉ワ紝鍒犻櫎鍒楄〃涔嬪悗鍒╃敤鍏抽敭瀛楀垹闄ょ浉鍏虫暟鎹簱涓殑鍐呭銆傛垜鑷繁鍐欑殑浠ｇ爜浣犵湅涓嬶紝鎴戞槸鍏堝畾涔変竴涓叏灞鍙橀噺xx锛岀敤浠栨潵鎺ユ敹鍏抽敭瀛椾繚瀛樿捣鏉ャ倁sing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System...
绛旓細杩娈典唬鐮鍦╓in7 + VB2010涓嬪畬鍏ㄦ甯革紝鏈夊浘涓鸿瘉锛
绛旓細鎬庝箞鍙兘鏈夎緭鍑 ,杈撳嚭璇彞鍙湁杩欏彞 if(sum==4){ printf("%d ",sum);break;} sum == 4鐨勬椂鍊 锛宻um鎬庝箞鍙兘==4锛屽嵆浣==4,涔熸槸杈撳嚭4鍟
绛旓細杩欐浠ｇ爜鏄竴涓娇鐢═kinter搴撳垱寤哄浘褰㈢敤鎴风晫闈紙GUI锛夌殑Python绋嬪簭锛屾棬鍦ㄥ疄鐜癢iFi瀵嗙爜娓楅忥紙鐮磋ВWiFi瀵嗙爜锛夌殑宸ュ叿銆傝繖鏄竴涓秹鍙婂埌榛戝琛屼负鐨勭▼搴忥紝杩濆弽浜嗘硶寰嬪拰閬撳痉瑙勮寖锛屼笉搴旇琚敤浜庨潪娉曟椿鍔ㄣ傚湪姝ゆ彁渚涗竴浜涘叧浜浠ｇ爜鐨鍒嗘瀽锛氫唬鐮佺己澶憋細鍦ㄤ綘鐨勯棶棰涓紝浠ｇ爜琚埅鏂紝鎵浠ユ棤娉曞畬鏁村湴鍒嗘瀽鏁翠釜绋嬪簭銆傚鏋滀綘鏈夊畬鏁寸殑...
绛旓細灏辨槸涓嶅悓鐨勫嚱鏁般傜敤绗竴涓嚱鏁版潵涓句緥锛屼綘澹版槑骞惰皟鐢ㄤ簡涓涓 鍑芥暟 void initlist(Sqlist);锛堜篃灏辨槸鎶ュ憡鎵句笉鍒板畾涔夌殑 void __cdecl displist(struct Sqlist)" 锛夌劧鑰屼綘鍚庨潰鍗村畾涔夌殑鏄彟澶栦竴涓嚱鏁皏oid initlist(Sqlist *&L)锛涗竴涓槸鎺ュ彈浼犲硷紝鍙︿竴涓嵈鏄帴鍙楁寚閽堢殑寮曠敤绫诲瀷銆
绛旓細printf("璇疯緭鍏1涓暣鏁帮細\n");scanf("%d",ptr);ptr++; ///杩欓噷閿欎簡锛侊紒锛i++;databuf[i] = *ptr;input_data鏄釜鏁存暟锛屽彇鍦板潃鍚庡氨鏄痯tr锛屾妸杈撳叆鐨勬暟瀛楀瓨杩涘幓娌闂锛屼絾鏄痯tr++鍦板潃鍒板摢閲屽幓浜嗗氨浜嗭紝杩欎釜鎸囬拡鍙樻垚浜嗛噹鎸囬拡锛屼綘鍐嶆妸杈撳叆鐨勬暟瀛楀瓨杩涘幓灏卞瓨鍒颁簡涓嶇煡閬撶殑鍦板潃锛岀牬鍧忎簡鍏朵粬鍦版柟...
绛旓細鍐檉ile2鐨勮鍙ュ彧鏈変竴鏉★細WriteFile.put(ch); 濡傛灉file2涓病鏈変笢瑗匡紝瑕佷箞1锛氳繖鏉¤鍙ユ病琚墽琛岋紱鎴栬2锛氳繖鏉¤鍙ヨ鎵ц浜嗕絾鏄病鍙戞尌浣滅敤锛涙垨鑰3锛氭枃浠跺凡缁忔甯稿啓鍏ワ紝浣嗘槸鏄笉鍙瀛楃锛屾墍浠ヤ綘鐪嬩笉鍒般傛墍浠ヤ綘鍙互鍋氬涓嬭皟璇曪細鍏堝湪while(ReadFile.get(ch))寰幆涓殢渚垮姞涓鏉out<<"aaa" << endl; ...
绛旓細if(get( &k)==-1)printf("鏍堥噷鏃犳暟鎹紝璇烽夋嫨杩涙爤鎿嶄綔\n");else printf("鍑烘爤鐨勬暟鎹槸%d \n",k);} if(in=='l'){ if(myst.flag!=0){ printf("---\n");for(i=0;i<myst.p;i++) printf("%d ", myst.data[i]);printf("\n---\n");} else printf("鏍堥噷鏃犳暟鎹紒\n...
