Asp.net ÊÂÎñ´¦Àí
ÊÂÎñ´¦ÀíÊÇÔÚÊý¾Ý´¦Àíʱ¾³£Óöµ½µÄÎÊÌ⣬¾³£Óõ½µÄ·½·¨ÓÐÒÔÏÂ3ÖÖ×ܽáÕûÀíÈçÏ£º ·½·¨1£ºÖ±½ÓдÈëµ½sql ÖÐ ÔÚ´æ´¢¹ý³ÌÖÐʹÓà BEGIN TRANS, COMMIT TRANS, ROLLBACK TRANS ʵÏÖ Óŵ㣺ÊÂÎñÂß¼°üº¬ÔÚÒ»¸öµ¥¶ÀµÄµ÷ÓÃÖУ¬ÓÐÔËÐÐÒ»¸öÊÂÎñµÄ×î¼ÑÐÔÄÜ£¬Á¢ÓÚÓ¦ÓóÌÐò¡£ÏÞÖÆ£º ÊÂÎñÉÏÏÂÎĽö´æÔÚÓÚÊý¾Ý¿âµ÷ÓÃÖУ¬Êý¾Ý¿â´úÂëÓëÊý¾Ý¿âϵͳÓйء£
·½·¨2 £ºÊ¹ÓÃADO.NET ʵÏÖ
ʹÓÃADO.NET ʵÏÖ£¬Ê¹ÓÃÕâÖÖ·½Ê½µÄÓŵãÊÇ¿ÉÒÔÔÚÖмä²ãÀ´¹ÜÀíÊÂÎñ£¬µ±È»ÄãÒ²¿ÉÒÔÑ¡ÔñÔÚÊý¾Ý²ãÀ´ÊµÏÖ¡£ SqlConnection ºÍOleDbConnection ¶ÔÏóÓÐÒ»¸ö BeginTransaction ·½·¨£¬Ëü¿ÉÒÔ·µ»Ø SqlTransaction »òÕßOleDbTransaction ¶ÔÏó¡£¶øÇÒÕâ¸ö¶ÔÏóÓÐ Commit ºÍ Rollback ·½·¨À´¹ÜÀíÊÂÎñ£¬±¾ÀýΪ¸üÐÂÊý¾Ý¿âÖÐijÕűíµÄÒ»¸öʾÀý¡£ Óŵã: ¼òµ¥ÐÔ ºÍÊý¾Ý¾ÝÊÂÎñ²î²»¶àµÄ¿ì ¶ÀÁ¢ÓÚÊý¾Ý¿â£¬²»Í¬Êý¾Ý¿âµÄרÓдúÂë±»Òþ²ØÁË È±µã: ÊÂÎñ²»ÄÜ¿çÔ½¶à¸öÊý¾Ý¿âÁ¬½Ó ÊÂÎñÖ´ÐÐÔÚÊý¾Ý¿âÁ¬½Ó²ãÉÏ£¬ËùÒÔÐèÒªÔÚÊÂÎñ¹ý³ÌÖÐά»¤Ò»¸öÊý¾Ý¿âÁ¬½Ó ADO.NET·Ö²¼ÊÂÎñÒ²¿ÉÒÔ¿çÔ½¶à¸öÊý¾Ý¿â£¬µ«ÊÇÆäÖÐÒ»¸öSQL SERVER Êý¾Ý¿âµÄ»°£¬Í¨¹ýÓÃSQL SERVERÁ¬½Ó·þÎñÆ÷Á¬½Óµ½±ðµÄÊý¾Ý¿â£¬µ«ÊÇÈç¹ûÊÇÔÚDB2ºÍOrcalÖ®¼ä¾Í²»¿ÉÒÔ¡£ÒÔÉÏÁ½ÖÖÊÂÎñÊǾ³£Óõ½µÄÊÂÎñ´¦Àí·½·¨¡£
·½·¨3 COM+ÊÂÎñ£¨·Ö²¼Ê½ÊÂÎñ£©
.NET Framework ÒÀ¿¿ MTS/COM+ ·þÎñÀ´Ö§³Ö×Ô¶¯ÊÂÎñ¡£COM+ ʹÓà Microsoft Distributed Transaction Coordinator (DTC) ×÷ΪÊÂÎñ¹ÜÀíÆ÷ºÍÊÂÎñе÷Æ÷ÔÚ·Ö²¼Ê½»·¾³ÖÐÔËÐÐÊÂÎñ¡£ÕâÑù¿Éʹ .NET Ó¦ÓóÌÐòÔËÐпç¶à¸ö×ÊÔ´½áºÏ²»Í¬²Ù×÷ ¶¨ÒåÒ»¸öCOM+ÊÂÎñ´¦ÀíµÄÀà TransactionScope scope = new TransactionScope(TransactionScopeOption.Required) TransactionOptionö¾ÙÀàÐÍÖ§³Ö5¸öCOM+Öµ£¨Disabled,NotSupported,Required,RequiresNew,Supported£© Disabled ºöÂÔµ±Ç°ÉÏÏÂÎÄÖеÄÈκÎÊÂÎñ¡£ NotSupported ʹÓ÷ÇÊÜ¿ØÊÂÎñÔÚÉÏÏÂÎÄÖд´½¨×é¼þ¡£ Required Èç¹ûÊÂÎñ´æÔÚÔò¹²ÏíÊÂÎñ£¬²¢ÇÒÈçÓбØÒªÔò´´½¨ÐÂÊÂÎñ¡£ RequiresNew ʹÓÃÐÂÊÂÎñ´´½¨×é¼þ£¬¶øÓ뵱ǰÉÏÏÂÎĵÄ״̬Î޹ء£ Supported &nb
Ïà¹ØÎĵµ£º
try
{
// ÒªÌá½»±íµ¥µÄURI×Ö·û´®¡£
string uriString = "http://localhost:1165/WebTest/MyLogin.aspx";
//// ......
protected void Button1_Click(object sender, EventArgs e)
{
string strsql = "select * from TreeViewTemp where parentID=0";
DataTable dt = db.GetDataTable(strsql);
StringWriter sw = new StringWriter();
//StreamWriter sw = new Strea ......
Êý¾Ý°ó¶¨ÒÔ¼°Container.DataItemµÄ¾ßÌå·ÖÎö
Áé»îµÄÔËÓÃÊý¾Ý°ó¶¨²Ù×÷
°ó¶¨µ½¼òµ¥ÊôÐÔ:<%#UserName%>
°ó¶¨µ½¼¯ºÏ:<asp:ListBox id="ListBox1" datasource='<%# myArray%>' runat="server">
°ó¶¨µ½±í´ïʽ:<%#(class1.property1.ToString() + "," + class1.property2.ToString())%>
°ó¶¨µ½·½·¨·µ» ......
ÉèÖÃSharpDevelop£¬Ê¹ÆäÄܱàдºÍÔËÐÐAsp.net¡£
ÔÚ¿´ÏÂÎĵÄʱºò£¬ÇëÈ·¶¨ÄúµÄϵͳװÉÏÁËIIS£¬FontPageÀ©Õ¹£¬×°ÁË.Net¿ò¼Ü¡£ºÃÏÖÔÚ¿ªÊ¼ÎҵĽ²Êö¡£
Èç¹ûÄú×°µÄ.Net¿ò¼ÜÊÇ1.1°æµÄ£¬ÇëÉú³ÉÒÔÏÂBATÎļþ¡£
Îļþ£ºAsp.Net_1.1_Setup.bat
c:
......