ASP.NetÊÂÎñÎÊÌâ ²ËÄñÇó¸ßÊÖ½â´ð ¸Ð¼¤²»¾¡
ÎÒÓÐ2Õűí
1.MyUser±í (Óû§±í)ÀïÃæÓÐ
Ö÷¼ü ID int
ÐÕÃû Name String
2.MyInfo±í (ÐÅÏ¢±í)ÀïÃæÓÐ
Ö÷¼ü ID int
Íâ¼ü UserId int //Æ¥ÅäÉϱíMyUserÖеÄID Ö÷Íâ¼ü¹ØÏµ
ÎÊÌ⣺
ÎÒÓà SqlTransaction ÊÂÎñ´¦Àí Èç Ìí¼ÓÒ»¸öÓû§(User) ²¢ÌîдÓû§ÐÅÏ¢(Info);
ÓÃÊÂÎñµÄ»° Ôõô×öÄØ£¿
SqlPath = "(local);database=clip;uid=sa;pwd=123456;";
SqlConnecton conn = new SqlConnecton(SqlPath);
conn.open();
SqlTransaction Transaction = conn.BeginTransaction();
rollbak = conn.BeginTransaction();
comm = new SqlCommand();
comm.Connection = conn;
comm.Transaction = Transaction;
comm.ExecuteNonQuery();
String sql = "INSERT INTO MyUser (name) values('ÕÅÈý')";
comm.CommandText = sql;
comm.ExecuteNonQuery();//ºÃÏñÕâÀﻹû´æµ½Êý¾Ý¿â ÊÇÔàÊý¾Ý£¿ ²»ÖªµÀÔÚÔõôÍùÏÂÃæÐ´ÁË ²ËÄñ ÇëÖ¸½Ì°¡¡£¡£
¼ÓÉÏtry catch finallyÕâЩ£¬
Ö´ÐеĴúÂëдÔÚtry¿éÖУ¬×îºóÌá½»ÊÂÎñ¡£
ÊÂÎñ»Ø¹öµÄ´úÂëдÔÚcatchÖУ¬
finally¿éÖйرÕÁ¬½Ó¡£
²»ÊÇÕâ¸öÒâ˼°¡£¡
ÎÒÒªÔõô»ñµÃcomm.ExecuteNonQuery();ûÓзµ»Ø½á¹û Èç¹ûÎÒÄÃ
SqlDataRead read = comm.ExecuteReader();
read["ID"].ToString();//ÕâÀï»á±¨´í£¿
Õý³£µÄ²½ÖèÊÇÊ²Ã´ÄØ
·µ»ØÓ°
Ïà¹ØÎÊ´ð£º
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
·¢¸øÎÒÒ»·Ý 280535258@qq.com лл Òª·Ö¿ÉÒÔ˵ ¶àÉÙ¶¼ÐÐ
²Î¿¼£º£º£¡£¡£¡£¡
ǰ̨
<%@ Page language="c#" Codebehind="Domain.aspx.cs" AutoEventWireup="false" Inherits=&q ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
ÀýÈçÎÒÓÐÒ»¼þÊ¡£½ñÌìÍê³É°Ù·ÖÖ®20£¬¾ÍÓÃÒ»¸öÔ²ÐΣ¬·ÖÁ½²¿·Ö£¬Ò»²¿·Ö»¡Çø£¨Ò»ÖÖÑÕÉ«£©ÊÇÏÔʾÒÔÍê³É²¿·Ö£¬ÁíÒ»²¿·ÖÓÃÁíÒ»ÖÖÑÕÉ«ÏÔʾ£¬±íʾΪÍê³É²¿·Ö£¬²¢°ÑÊý×ÖдÔÚÉÏÃæ£¬ÕâÑùµÄ»°£¬ÔõôʵÏÖ£¬ÓÐûÓÐʲôʵÀý¡£»òÕßÒª ......