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

ASP.NetÖÐʹÓÃVB.Netµ÷Óô洢¹ý³Ì²¢µÃµ½·µ»ØÖµ


ASP.NetÖÐʹÓÃVB.Netµ÷Óô洢¹ý³Ì²¢µÃµ½·µ»ØÖµ
À´Ô´£ºqqreadÂÛ̳ ×÷Õߣº ³ö´¦£ºÇÉÇɶÁÊé 2006-08-03 ½øÈëÌÖÂÛ×é
//´æ´¢¹ý³Ì´úÂë
¡¡CREATE PROCEDURE [AddNewInvoiceInfo] (@sUserID int,@sClaimMethod varchar(50),@sInvoiceNum ¡¡varchar(50),@sInvoiceDate datetime,@sBuyCity varchar(50))AS
¡¡Insert Into SMB_InvoiceInfo (MemberID,ClaimMethod,InvoiceNum,InvoiceDate,InvoiceCity) Values ¡¡(@sUserID,@sClaimMethod,@sInvoiceNum,@sInvoiceDate,@sBuyCity)
¡¡return  @@IDENTITY
¡¡GO
//µ÷Óô洢¹ý³Ì´úÂë
¡¡Dim CN As New SqlConnection()
¡¡Dim InvoiceID As String
¡¡Try
    CN.ConnectionString = DBConStr
    CN.Open()
    Dim CMD As SqlCommand
    CMD = New SqlCommand(AddNewInvoiceInfo, CN)
    CMD.CommandType = CommandType.StoredProcedure
    CMD.Parameters.Add(New SqlParameter(@sUserID, SqlDbType.Int))
    CMD.Parameters(@sUserID).Value = CInt(UserID.Text)
    CMD.Parameters.Add(New SqlParameter(@sClaimMethod, SqlDbType.VarChar, 50))
    CMD.Parameters(@sClaimMethod).Value = TransName.Text
    CMD.Parameters.Add(New SqlParameter(@sInvoiceNum, SqlDbType.VarChar, 50))
    CMD.Parameters(@sInvoiceNum).Value = InvoiceNum.Text
    CMD.Parameters.Add(New SqlParameter(@sInvoiceDate, SqlDbType.DateTime))
    CMD.Parameters(@sInvoiceDate).Value = InvoiceDate.SelectedDate.Date
    CMD.Parameters.Add(New SqlParameter(@sBuyCity, SqlDbType.VarChar, 50))
    CMD.Parameters(@sBuyCity).Value = BuyCity.Text
    CMD.Parameters.Add(New SqlParameter(@sInvoiceID, SqlDbType.Int))
    CMD.Parameters(@sInvoiceID).Direction = ParameterDirection.ReturnValue
    CMD.ExecuteNonQuery()
    InvoiceID = CMD.Parameters(@sInvoiceID).Value.ToString()
    CMD.Dispose()
¡¡Catch ex As Exception
 &


Ïà¹ØÎĵµ£º

ASP.NET¹ØÓÚÌõÐÎÂëµÄÉú³ÉÎÊÌâ¼æÍøÒ³´òÓ¡

ÌõÐÎÂëÊÇÆù½ñΪֹ×î¾­¼Ã¡¢ÊµÓõÄÒ»ÖÖ×Ô¶¯Ê¶±ð¼¼Êõ¡£ÌõÐÎÂë¼¼Êõ¾ßÓÐÒÔϼ¸¸ö·½ÃæµÄÓŵã
¡¡¡¡A£®ÊäÈëËٶȿ죺Óë¼üÅÌÊäÈëÏà±È£¬ÌõÐÎÂëÊäÈëµÄËÙ¶ÈÊǼüÅÌÊäÈëµÄ5±¶£¬²¢ÇÒÄÜʵÏÖ“¼´Ê±Êý¾ÝÊäÈ딡£
¡¡¡¡B£®¿É¿¿ÐԸߣº¼üÅÌÊäÈëÊý¾Ý³ö´íÂÊΪÈý°Ù·ÖÖ®Ò»£¬ÀûÓùâѧ×Ö·ûʶ±ð¼¼Êõ³ö´íÂÊΪÍò·ÖÖ®Ò»£¬¶ø²ÉÓÃÌõÐÎÂë¼¼ÊõÎóÂëÂʵ ......

ÊÖ°ÑÊÖ½ÌÄã×öASP.NETÁôÑÔ±¾


ûÓÐÏëµ½ÕæµÄÕâô·½±ã!¸ü¼Ó¼á¶¨ÎÒѧϰASP.NETµÄ¾öÐÄ! ÏÖÔÚÎÒÃÇÒ»ÆðÀ´¿´¿´°É
1,ÇëÈ·¶¨ÄãµÄµçÄÔ°²×°ÁËÒÔϵÄÈí¼þ£¡
1.1£¬    WINDWOS 2000ÒÔÉϰ汾(±Ø×°)
1.2£¬    .NET Framework(±Ø×°)
1.3£¬    Visual Studio .NET 2005(±Ø×°)
2,½¨Á¢Ò»¸öACCESSÊý¾Ý¿â,
3,Í϶¯VS2005 µÄGRIDVIEW µ½ ......

ʹÓÃASP.NET 2.0ÔÚWebÒ³ÃæÍêÃÀµØ»­³ö±ýͼ

 ¸ÅÄÆäʵ˼··Ç³£¼òµ¥£¬¾ÍÏñ»­»­Ò»Ñù£¬ÄãÄÔÖеıýͼÏëɶÑù×ӵģ¬¾Í°ÑËüÔÚÍøÒ³Àï»­³öÀ´¶øÒÑ¡£ÏàÐÅ´ó¼ÒСʱºò¶¼»­¹ý»­£¬²»Í¬µÄÊÇ£¬Ð¡Ê±ºò£¬ÔÚÖ½ÉÏ»­£¬ÏÖÔÚÔÚÍøÒ³ÉÏ»­¡£
ÕâÊÇÎÒÄÔ×ÓÀï±ýͼµÄÑù×Ó£º<¼¤¹â´«Õæ»ú>
C#ºǫ́ʾÀý´úÂ룺<¼¤¹âÒ»Ìå»ú>
using System;
using System.Data;
using System.Configur ......

vbµ÷ÓÃexcel·½·¨´óÈ«

ÔÚVBÖÐÒªÏëµ÷ÓÃExcel£¬ÐèÒª´ò¿ªVB±à³Ì»·¾³“¹¤³Ì”²Ëµ¥ÖеēÒýÓÔÏîÄ¿£¬²¢Ñ¡È¡ÏîÄ¿ÖеēMicrosoft Excel 11.0 object library”Ïî¡£ÓÉÓÚÄãµÄExcel°æ±¾²»Í¬£¬ËùÒÔÕâ¸öÑ¡ÏîµÄ°æ±¾ºÅÒ²ÊDz»Í¬µÄ¡£
    ÒòΪEXCELÊÇÒÔ²ã´Î½á¹¹×éÖ¯¶ÔÏóµÄ£¬Æä¶ÔÏóÄ£ÐÍÖк¬ÓÐÐí¶à²»Í¬µÄ¶ÔÏóÔªËØ¡£
&n ......

¹ØÓÚѧºÃasp¼°asp.netµÄ¾­Àú

      ¶ÔÓÚÒ»¸öÏëѧºÃASP¼°asp.netµÄ¹ýÀ´ÈËÀ´Ëµ,ѧϰµÄ¹ý³ÌÊÇÓÐȤ¼°ÕÛÄ¥È˵Ä,µ±Äã×ö³öµÚÒ»¸öʵÑéµÄʱºòÄãµÄÐÄÇéÊǼ¤¶¯µÄ,ÎÒÊDZÏÒµÒÔÀ´Ò»²½Ò»²½µÄ×Ôѧ¹ý³ÌÖÐ×ܽáÁËһЩºÃµÄ¾­ÑéÈÿ´µ½ÕâÆªÎÄÕµÄÈËÉÙ×ßһЩÍä·,ÏÂÃæÐ´µÄ¶¼ÊÇÕë¶Ô³õѧÕß,Ò²ÊÇÎÒ×Ô¼ºÊÇÔõô´ÓÁã»ù´¡µ½ÏÖÔÚ¿ÉÒÔ¿ª·¢Ò»Ð©¶«Î÷µÄ¹ý³Ì.
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ