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();
}
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÎÒÓÐÒ»¸öÀàËÆµÄxmlµÄ string£¬Ïëͨ¹ý±éÀúÔõô¸öxml Êä³öÎÒÏëÒªµÄelementµÄÖµ
xml Ϊ£º
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_XML_ME ......