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
&
Ïà¹ØÎĵµ£º
ÌõÐÎÂëÊÇÆù½ñΪֹ×á¢ÊµÓõÄÒ»ÖÖ×Ô¶¯Ê¶±ð¼¼Êõ¡£ÌõÐÎÂë¼¼Êõ¾ßÓÐÒÔϼ¸¸ö·½ÃæµÄÓŵã
¡¡¡¡A£®ÊäÈëËٶȿ죺Óë¼üÅÌÊäÈëÏà±È£¬ÌõÐÎÂëÊäÈëµÄËÙ¶ÈÊǼüÅÌÊäÈëµÄ5±¶£¬²¢ÇÒÄÜʵÏÖ“¼´Ê±Êý¾ÝÊäÈ딡£
¡¡¡¡B£®¿É¿¿ÐԸߣº¼üÅÌÊäÈëÊý¾Ý³ö´íÂÊΪÈý°Ù·ÖÖ®Ò»£¬ÀûÓùâѧ×Ö·ûʶ±ð¼¼Êõ³ö´íÂÊΪÍò·ÖÖ®Ò»£¬¶ø²ÉÓÃÌõÐÎÂë¼¼ÊõÎóÂëÂʵ ......
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
Stephen Walther
Superexpert
ÊÊÓÃÓÚ£º
Microsoft ASP.NET 2.0
Microsoft Visual Studio 2005
¼ò½é
ÔÚ Microsoft ASP.NET 2.0 Framework ÖУ¬Êý¾Ý¿â·ÃÎʵõ½Á˼«´óµÄ¼ò»¯¡£ÀûÓÃÈ«Ð嵀 SqlDataSource ¿Ø¼þ£¬ÄúÎÞÐè±àдһÐдúÂë¾Í¿ÉÒÔÑ¡Ôñ¡¢¸üС¢²åÈëºÍɾ³ýÊý¾Ý¿âÊý¾Ý¡£
Éú³É¼òµ¥µÄÓ¦ÓóÌÐòʱ£¬SqlDataSource ¿ ......
¡¡¡¡.Net ÀïÉÏ´«´óÎļþʱ£¬»áÓöµ½³¬Ê±»òHTTP500´íÎ󣬽â¾öµÄ°ì·¨ÓÐÁ½ÖÖ£ºÒ»ÖÖÊÇÐÞ¸ÄÅäÖã¬ÁíÒ»ÖÖ¾ÍÊÇÓõÚÈý·½¿Ø¼þ¡£ÕâÀï½éÉÜÒ»ÏÂÐÞ¸ÄÅäÖõġ£
ÐèÒªÐ޸ĵÄÊÇ
ÔÚ C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIGĿ¼À
ÕÒµ½ÎļþmaxRequestLength="4096"
½«ÖµÐ޸ĴóһЩ£¬ÀýÈ磺102400
Õâ¸ö²ÎÊýµÄµ¥Î»Ó¦¸ÃÊ ......
¡¡¡¡×Ô´ÓÉÏ´ÎÓÐÁËÒ»´ÎÆÆ½âÑéÖ¤ÂëµÄ¾Ñéºó£¬¾ÍÒ»Ö±Ïë×Ô¼ºÐ´¸öÏñÑùµãµÄÑéÖ¤Âë¡£½ñÌìÎÞÁÄËùÒÔ¾ÍдÁË£¬×ÜÌåÉÏÀ´Ëµ»¹ËãºÜÂúÒâ¡£¾ÍÊÇÓÐʱ¸´ÔÓµÃÈâÑÛ¶¼¿´²»³öÊÇɶ£¨ÕâÒ²¸úͼƬ̫СÓйØÏµ£©¡£
¡¡¡¡Õâ¸öÑéÖ¤ÂëÖ§³ÖËæ»ú×ÖÌå¡¢×ÖÌå´óС¡¢×ÖÌåÑùʽ£¨ÆÕͨ¡¢´ÖÌ塢бÌ壩¡¢×ÖÌåÑÕÉ«¡¢×Ô¶¨Òå×Ö·ûµÈ¡£
¡¡¡¡´úÂëÖеÄlibFontÊÇ×ÖÌå¿â£¬libC ......