Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql×¢Èë - .NET¼¼Êõ / C#

ÎÒдÁËÒ»¸öÓû§×¢²áºóÊý¾Ý´æÈëÊý¾Ý¿â£¬¿ÉÊǾÍÊÇ´æ²»½øÈ¥
ÏÂÃæÊÇ´úÂ룺string sql = "";
  Óû§ user = new Óû§();
  user.Name = textBox1.Text;
  user.MiMa = textBox2.Text;
  user.QMiMa = textBox3.Text;
  user.Sex = comboBox1.Text;
  user.Age = Convert.ToInt16(textBox4.Text);
  if (user.Name != null)
  {
  if (user.MiMa != null)
  {
  if (user.MiMa == user.QMiMa)
  {
  sql = "insert into user(Óû§Ãû,ÃÜÂë,ÄêÁä,ÐÔ±ð) values ('" + textBox1.Text + "'," + Convert.ToInt16(textBox2.Text) + "," + Convert.ToInt16(textBox4.Text) + ",'" + comboBox1.Text + "')";


   
   
  OleDbCommand command = new OleDbCommand(sql,con );
  con.Open();
  int num = Convert.ToInt32(command.ExecuteNonQuery());
  if (num == 1)
  {

  this.Close();
  }
   
 


Ïà¹ØÎÊ´ð£º

ÀûÓÃC#±àдtxtת»¯µ½xmlµÄ³ÌÐò

txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔ­Êý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ