Íùmysql¿âÖвåÈëÒ»ÌõÊý¾Ý£¨´Ë±íÓÐ×ÔÔö³¤ÁУ©£¬ÔÚc#´úÂëÀïÈçºÎд1¾äsql£¬²åÈëºó·µ»ØÕâ¸ö×ÔÔö³¤ÁÐÖµ
Õâ¸ö²»¹ØC#µÄʰɣ¬ÕâÊÇsqlÓï¾ä½â¾öµÄÊÂÇé
¼ÈÈ»ÊÇ×ÔÔöÁУ¬¼ÈÈ»ÊÇвåÈëµÄÒ»Ìõ¼Ç¼£¬ÄÇôÕâÌõ¼Ç¼µÄÕâ¸ö×Ö¶ÎÖµ£¬¾ÍÊÇ×î´óµÄ
ËùÒÔ¡£¡£
insertÍê±Ïºó£¬select max(×ÔÔöÁÐ×Ö¶Î) from ±í
¾Í¿ÉÒÔÁË¡£¡£
......
C# code:
MySql.Data.MySqlClient.MySqlConnection con = new MySqlConnection("Database=beephpcms;Data Source=localhost;User Id=root;Password=root");
con.Open();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySqlCommand("update phpcms_c_news set conten ......
C# code:
**////*************************************//
/// <summary>
/// 26¸öÈÕÎÄÆ¬¼ÙÃû±àÂë
/// </summary>
/// <param>ÁºÔ¶È«</param>
/// <param>2006.8.10</param>
///*************************************//
using System;
using System.Text;
namespace JAP ......
СµÜ²ËÄñ£¬´ÓÍøÉÏÕÒÁËÒ»¸ö¶ÁÈ¡xmlµÄ°ì·¨£¬×Ô¼º¸Äдºó´úÂëÈçÏ£º
C# code:
XmlDocument xmlDoc = new XmlDocument();
XmlTextReader reader = new XmlTextReader(HttpContext.Current.Server.MapPath("..\\TestSet.xml"));
xmlDoc.Load(reader);
XmlNodeList nodeList ......
asp.net(C#)Ò»¸ö¼òµ¥µÄÈý²ã¼Ü¹¹°¸Àý
±ÈÈçÀûÓÃÈý²ã¼Ü¹¹£¬´ÓÊý¾Ý¿âÀï¶ÁÈ¡Êý¾Ý£¡Èý¸ö²ã´ÎµÄÔ´Â룡£¡
Êý¾Ý·ÃÎʲ㡢ҵÎñ²ã¡¢½çÃæ£¬·ÃÎʲã¿ÉÓÃSqlhelper£¬ÒµÎñ²ãʵÏÖ½«DataTableÖ®ÀàµÄÊý¾Ý±ä³ÉobjectʵÌå¶ÔÏ󣬲¢ÌáÈ¡µ÷Ó÷ÃÎʲãÓë·µ»ØUI²ãÊý¾ÝµÄ·½·¨
¹Ø¼üÊÇ˼Ï룬ÔÙ¶àµÄ²ã´ÎÒ²ÊÇÈóÌÐò¸üÇåÎú·½±ãÍÆÕ¹¡£¸÷²ãÖ®¼äµÄ½Ó¿Ú² ......
select count(*) from Stu Ôõô°ÑÕâ¸ö²éѯ½á¹ûÔÚlableÉÏÏÔʾ?
lable.Text=??
·µ»ØµÄÊÇÒ»¸öobject£¬Ö±½ÓTostring()¾ÍÐÐÁË
´úÂëÔõôд?
public string GetCount()
{
string R = string.Empty;
......