ÊäÈëÉí·ÝÖ¤ºÅ
µã»÷²éѯ£¬ÐÅÏ¢Êä³ö
ÐÅÏ¢´íÎó ¶ÔÊä³öµÄ³Ë¿Í½øÐкËʵ
È·ÈÏÐÅÏ¢
¶©Æ±
´úÂëÈçÏ£º
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 System.Data.SqlClient;
namespace plant {
public partial class Form3 : Form {
public Form3() {
InitializeComponent(); }
private void button3_Click(object sender, EventArgs e) {
string conStr = \Source=GAO-PC\\\\SQL2005;Initial Catalog=plant;User ID=sa;Password=aa\;
SqlConnection conn = new SqlConnection(conStr); conn.Open();
string sql = \ * from ¿Í¨ª»§¡ì where Éí¦¨??='\ + number.Text + \;
SqlDataAdapter cmd = new SqlDataAdapter(sql, conn); DataSet ds = new System.Data.DataSet();
cmd.Fill(ds, \);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = ds.Tables[\].ToString(); conn.Close(); } } }
¡¾Ð³˿Í×¢²á¡¿·½Ê½£»
aÌø×ªµ½¸Ã½çÃæ£»
bÊäÈëÏà¹ØÐÅÏ¢Ö®ºó,°üÀ¨¿Í»§ÐÕÃû£¬¿Í»§ÐÔ±ð£¬Éí·ÝÖ¤ºÅ£»ÁªÏµµç»°¡£¿Í»§ÀàÐ͵ȣ»
c½«ÐÅÏ¢ÊäÈëµ½Êý¾Ý¿âÖÐ
ÊäÈë»ù±¾ÐÅÏ¢
µã»÷È·ÈÏ
½«ÐÅÏ¢²åÈëµ½Êý¾Ý¿âÖÐ
¶©Æ±
´úÂëÈçÏ£º
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 System.Data.SqlClient; namespace plant {
public partial class Form4 : Form {
public Form4() {
InitializeComponent(); }
private void button1_Click(object sender, EventArgs e) {
string conStr1 = \Source=GAO-PC\\\\SQL2005;Initial Catalog=plant;User
ID=sa;Password=aa\;
SqlConnection conn1 = new SqlConnection(conStr1); conn1.Open();
string sql1 = \¿Í¨ª»§¡ì(¿Í»§ÐÕÃû,¿Í»§ÐÔ±ð,Éí·ÝÖ¤ºÅ,ÁªÏµµç»°,¿Í»§ÀàÐͨª) values( '\ + name.Text + \,'\ + sex.Text + \ + number.Text + \ + phone.Text + \ + style.Text + \;
SqlCommand cmd1 = new SqlCommand(sql1, conn1); int i = cmd1.ExecuteNonQuery();
MessageBox.Show(\г˿ÍÌí¼Ó³É¹¦|\); cmd1.Dispose(); conn1.Close(); }
private void Form4_Load(object sender, EventArgs e) {
}
}
ÏîÄ¿Ãû³Æ£º²âÊÔ ÈÕÆÚ£º2013.1.17 µØµã£ºÒÝ·òÂ¥404
ÏêϸÉè¼Æ½×¶ÎÒѾ³õ²½Íê³É£¬¿ªÊ¼ÏµÍ³µÄ²âÊÔºÍά»¤½×¶Î£¬ÈçÏ£º
¡¶²âÊԼƻ®¡·
1ÒýÑÔ
1.1±àдĿµÄ
²âÊÔ·ÖÎö±¨¸æÊÇÔÚ²âÊÔ·ÖÎöµÄ»ù´¡ÉÏ£¬¶Ô²âÊԵĽá¹ûÒÔ¼°²âÊÔµÄÊý¾ÝµÈ¼ÓÒԼǼºÍ·ÖÎö×ܽᡣËüÒ²ÊDzâÊÔ¹ý³ÌÖеÄÒ»¸öÖØÒª»·½Ú£¬Í¬Ê±£¬ËüÒ²ÊǶÔÈí¼þÐÔÄܵÄÒ»¸ö×ܵķÖÎöºÍÈϿɼ°¶Ô²»×ãÖ®´¦µÄ˵Ã÷¡£Òò´Ë£¬²âÊÔ·ÖÎö±¨¸æ¶ÔÓÚ½ñºó¶ÔÈí¼þµÄ¹¦ÄܵļÓÇ¿£¬²»×ãÖ®´¦µÄÃÖ²¹µÈ¶¼Æð×ÅÊ®·ÖÖØÒªµÄÌá¸Ù×÷Óá£ÁíÍ⣬Ëü»¹ÓÐÀûÓÚ½ñºóÈí¼þ¿ª·¢ ÕßÔĶÁÔ³ÌÐò£¬¸ù¾Ý²âÊÔÌṩµÄÊý¾ÝºÍ½á¹û£¬·ÖÎöÔ´úÂë£¬ÕÆÎÕ¸÷º¯ÊýµÄ¹¦Äܺ;ÖÏÞÐÔ¡£´Ó¶øËõ¶ÌÈí¼þ¿ª·¢ÕßµÄÔÙ¿ª·¢Ê±¼äºÍËùºÄ·ÑµÄ¾«Á¦£®×ʽð¡£
´ÓÕâ·½ÃæÉÏ£¬ÎÒÃDz»ÄÑ·¢ÏÖ£¬²âÊÔ·ÖÎö±¨¸æËùÖ¸Ã÷µÄ¶ÔÏóÖ÷ÒªÊÇÕë¶ÔÓÚÈí¼þ¿ª·¢ Õß¡£