ÖØÇì¿Æ¼¼Ñ§Ôº¡¶.NET¿ª·¢¼¼Êõ¡·¿Î³ÌÉè¼Æ
3.2.5 ÕÛ¿ÛÐÅÏ¢±í
ÕÛ¿ÛÐÅÏ¢±íÓÃÀ´´æ·ÅÕۿ۵Ļù±¾ÐÅÏ¢£¬±íÖеĸ÷¸ö×ֶεÄÊý¾ÝÀàÐÍ¡¢´óСÈç±í3.6Ëùʾ£º
ͼ3.6 ÕÛ¿ÛÐÅÏ¢±í Name »áÔ±µÈ¼¶ ÕÛ¿Û ËùÐèÏû·Ñ
Code CSLevel Zhekou Xiaofei I F MN Data Type Length ±¸×¢ 3.2.6 ±£´æÕ˺ÅÐÅÏ¢±í
±£´æÕ˺ÅÐÅÏ¢±íÓÃÀ´´æ·ÅµÇ½½çÃæÖб£´æÕ˺ŵĻù±¾ÐÅÏ¢£¬±íÖеĸ÷¸ö×ֶεÄÊý¾ÝÀàÐÍ¡¢´óСÈç±í3.8Ëùʾ£º
ͼ3.8 ±£´æÕ˺ÅÐÅÏ¢±í Name Õ˺ŠÃÜÂë ÊÇ·ñ±£´æÃÜÂë
3
Code SaveNo SavePassWord SaveYN Data Type VA1 VA1 I Length 1 1 ±¸×¢ ÖØÇì¿Æ¼¼Ñ§Ôº¡¶.NET¿ª·¢¼¼Êõ¡·¿Î³ÌÉè¼Æ
4 ¹¦ÄÜÄ£¿éµÄ¾ßÌåÉè¼ÆÓëʵÏÖ
4.1 ¹ÜÀíÔ±ÐÅÏä¹ÜÀí
¹ÜÀíÔ±ÐÅÏä¹ÜÀíµÄ¾ßÌ幦ÄÜÈçÏ£º¿Í»§¿ÉÒÔ¸ø¹ÜÀíÔ±ÁôÑÔ£¬¹ÜÀíÔ±¿ÉÒԵǽ½øÊ×Ò³½øÐв鿴¡¢É¾³ýÁôÑÔ£¬¾ßÌåʵÏÖ´úÂëÈçÏ£º 1£©¿Í»§ÁôÑÔÖ÷Òª´úÂ룺
DateTime dt = DateTime.Now;
string getDate = DateTime.Now.ToLocalTime().ToString(); Class1 ss = new Class1();
string strSql = \values('{0}','{1}',0,'{2}')\;
strSql = string.Format(strSql, textBox1.Text, textBox2.Text, getDate); ss.UpdateData(strLianjie, strSql); MessageBox.Show(\ÁôÑԳɹ¦\);
2£©¹ÜÀíÔ±²é¿´Ö÷Òª´úÂ룺
Class1 ss = new Class1();
string strSql = \;
strSql = string.Format(strSql, dataGridView1[\񅧏\, rowkk].Value.ToString()); DataSet ds = ss.GetData(strLianjie,strSql);
textBox1.Text = ds.Tables[0].Rows[0][\].ToString(); string strSql1 = \;
strSql1 = string.Format(strSql1, dataGridView1[\񅧏\, rowkk].Value.ToString()); ss.UpdateData(strLianjie, strSql1);
string strSql2 = \±àºÅ,MDate as ÁôÑÔÈÕÆÚ,MessageTitle as ÁôÑÔ±êÌâfrom MessageAdmin where MYN = 0\;
DataSet ds1 = ss.GetData(strLianjie, strSql2);
label1.Text = \ÄúÄ¿Ç°ÓÐ\ + ds1.Tables[0].Rows.Count + \·âδ¶ÁÐżþ\;
3£©¹ÜÀíԱɾ³ýÖ÷Òª´úÂ룺
Class1 ss1 = new Class1();
string strSql1 = \;
strSql1 = string.Format(strSql1, dataGridView1[\±àºÅ\, rowkk].Value.ToString()); ss1.UpdateData(strLianjie, strSql1); MessageBox.Show(\ɾ³ý³É¹¦\);
4.2 ¿Í»§ÐÅÏ¢¹ÜÀí£º
¿Í»§ÐÅÏ¢¹ÜÀíµÄ¾ßÌ幦ÄÜÈçÏ£ºÔ±¹¤ºÍ¹ÜÀíÔ±¶¼¿É¶Ô¿Í»§½øÐвÙ×÷£¬°üÀ¨Ôö¼Ó¡¢É¾
³ýºÍÐ޸ŦÄÜ£¬¾ßÌåʵÏÖ´úÂëÈçÏ£º 1£©²é¿´¿Í»§ÐÅÏ¢Ö÷Òª´úÂ루ѧºÅ²éѯ£©£º
4
ÖØÇì¿Æ¼¼Ñ§Ôº¡¶.NET¿ª·¢¼¼Êõ¡·¿Î³ÌÉè¼Æ
Class1 ss = new Class1();
string strSql = \¿Í»§ºÅ,CSname as ÐÕÃû,CSNo as ѧºÅ»ò¹¤ºÅ,CSSex as ÐÔ±ð,CSClass as °à¼¶»ò²¿ÃÅ,CSLevel as »áÔ±µÈ¼¶,CSTel as ÁªÏµ·½Ê½from Customers where CSNo = '{0}'\; strSql = string.Format(strSql, textBox1.Text.Trim()); DataSet ds = ss.GetData(strLianjie, strSql); dataGridView1.DataSource = ds;
dataGridView1.DataMember = ds.Tables[0].ToString(); if (ds.Tables[0].Rows.Count >= 1) {
for (int i = 0; i < ds.Tables[0].Rows.Count; i++) {
comboBox2.Items.Add(ds.Tables[0].Rows[i][\¿Í»§ºÅ\].ToString()); } }
2£©Ð޸Ŀͻ§ÐÅÏ¢Ö÷Òª´úÂ룺
Class1 ss = new Class1();
string strSql = \'{3}' where CNo = '{4}'\;
strSql = string.Format(strSql, textBox4.Text.Trim(), textBox6.Text.Trim(), textBox7.Text.Trim(), textBox8.Text.Trim(), textBox2.Text.Trim()); ss.UpdateData(strLianjie, strSql); MessageBox.Show(\Ð޸ijɹ¦\);
3£©É¾³ý¿Í»§ÐÅÏ¢Ö÷Òª´úÂ룺
Class1 ss = new Class1();
string strSql = \; strSql = string.Format(strSql, textBox2.Text.Trim()); ss.UpdateData(strLianjie, strSql);
string strSql1 = \; //ɾ³ý´ËÈ˵ĹºÎïÐÅÏ¢ strSql1 = string.Format(strSql1, textBox2.Text.Trim()); ss.UpdateData(strLianjie, strSql1); MessageBox.Show(\ɾ³ý³É¹¦\);
Ö÷ÒªÁ÷³ÌͼÈçͼ4.1Ëùʾ£º
¿Í»§ÐÅÏ¢¹ÜÀí ²éѯ¿Í»§ÐÅÏ¢ ·µ»Ø Ð޸Ŀͻ§ÐÅÏ¢ Ð޸ijɹ¦£¬·µ»Ø ɾ³ý¿Í»§ÐÅÏ¢ ɾ³ý³É¹¦£¬·µ»Ø
ͼ4.1 ¿Í»§ÐÅÏ¢¹ÜÀíÁ÷³Ìͼ
5
ÖØÇì¿Æ¼¼Ñ§Ôº¡¶.NET¿ª·¢¼¼Êõ¡·¿Î³ÌÉè¼Æ
4.3 Ô±¹¤ÐÅÏ¢¹ÜÀí
Ô±¹¤ÐÅÏ¢¹ÜÀíµÄ¾ßÌ幦ÄÜÈçÏ£º¹ÜÀíÔ±¿ÉÒÔ¶ÔÔ±¹¤µÄ»ù±¾ÐÅÏ¢½øÐвéѯ¼°Ð޸ģ¬Ô±
¹¤±¾ÈË¿ÉÒÔ¶Ô×Ô¼ºµÄÃÜÂë½øÐÐÐ޸ģ¬¾ßÌåʵÏÖ´úÂëÈçÏ£º 1£©Ôö¼ÓÔ±¹¤ÐÅÏ¢Ö÷Òª´úÂë:
Class1 ss = new Class1();
string strSql2 = \;
strSql2 = string.Format(strSql2, textBox2.Text.Trim(), textBox3.Text.Trim(), comboBox1.Text, textBox1.Text.Trim());
ss.UpdateData(strLianjie, strSql2); MessageBox.Show(\Ôö¼Ó³É¹¦\);
2£©²éѯԱ¹¤ÐÅÏ¢Ö÷Òª´úÂë:
Class1 cc = new Class1();
string strSql = \; strSql = string.Format(strSql, textBox1.Text.Trim()); DataSet ds = cc.GetData(strLianjie, strSql); if (ds.Tables[0].Rows.Count == 0) {
MessageBox.Show(\¶Ô²»Æð,ÄúÒª²éѯµÄÔ±¹¤ºÅ²»´æÔÚ\); return; } else {
textBox2.Text = ds.Tables[0].Rows[0][\].ToString(); textBox3.Text = ds.Tables[0].Rows[0][\].ToString(); textBox4.Text = ds.Tables[0].Rows[0][\].ToString(); textBox5.Text = ds.Tables[0].Rows[0][\].ToString();
}
3£©ÐÞ¸ÄÔ±¹¤ÐÅÏ¢Ö÷Òª´úÂë:
string strSql = \;
strSql = string.Format(strSql, textBox3.Text.Trim(), textBox4.Text.Trim(), textBox5.Text.Trim(),textBox2.Text.Trim()); Class1 ss = new Class1();
ss.UpdateData(strLianjie, strSql);
MessageBox.Show(\Ð޸ijɹ¦\);
4.4 ¹ÜÀíÔ±Õ˺ŹÜÀí
¹ÜÀíÔ±Õ˺ŹÜÀíµÄ¾ßÌ幦ÄÜÈçÏ£ºÏµÍ³¹ÜÀíÔ±¿ÉÒÔ¶Ô¹ÜÀíÔ±Õ˺ŽøÐÐÔö¼Ó¡¢É¾³ý¡¢
³õʼ»¯ÃÜÂ룬¾ßÌåʵÏÖ´úÂëÈçÏ£º 1£©Ôö¼Ó¹ÜÀíÔ±Õ˺ÅÖ÷Òª´úÂ룺
6