如何使用存储过程向数据库插入记录?
我自己写了一点代码,但是出现如下错误{"'dbo' 附近有语法错误。"}
以下是我的代码:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim i%
Dim row As GridViewRow
Dim s As String
Dim sum As Decimal
For i = 0 To GridView1.Rows.Count - 1
row = GridView1.Rows(i)
s = row.Cells(3).Text
sum = sum + Decimal.Parse(s)
SqlDataSource1.InsertParameters.Clear()
SqlDataSource1.InsertParameters.Add("UserID", Session("loginname"))
SqlDataSource1.InsertParameters.Add("Listname", GridView1.Rows(i).Cells(0).Text)
SqlDataSource1.InsertParameters.Add("Price", GridView1.Rows(i).Cells(1).Text)
SqlDataSource1.InsertParameters.Add("Number", GridView1.Rows(i).Cells(2).Text)
SqlDataSource1.InsertParameters.Add("Time", DateTime.Today.ToShortDateString)
SqlDataSource1.InsertCommand = "dbo.InsertCart"
Session("TodayTime") = DateTime.Today.ToShortDateString
SqlDataSource1.Insert()
Next
SqlDataSource2.InsertParameters.Clear()
SqlDataSource2.InsertParameters.Add("UserID", Session("loginname"))
SqlDataSource2.InsertParameters.Add("Name", GridView2.Rows(0).Cells(0).Text)
SqlDataSource2.InsertParameters.Add("Adress", GridView2.Rows(0).Cells(2).Text)
SqlDataSource2.InsertParameters.Add("Telephone", GridView2.Rows(0).Cells(3).Text)
SqlDataSource2.InsertParameters.Add("Totel", sum)
SqlDataSource2.InsertParameters.Add("Zhuangtai", "未送餐")
SqlDataSource2.InsertCommand = "dbo.InsertPeisong"
SqlDataSource2.Insert()
Response.Write("<script> window.onload = function() {alert('订单保存成功,我们会尽快配送');location.href='returnlist.aspx'}</script>")
End Sub
这个是客户端存储过程的代码
ALTER PROCEDURE [dbo].[InsertCart]
(
@UserID varchar(20),
@ListName varchar(20),
@Price Decimal(15,2),
@Number int,
@DingcanTime datetime
)
AS
set nocount off
insert into dbo.cart
(UserID,ListName,Price,Number,DingcanTime) values (@UserID,@ListName,@Price,@Number,@DingcanTime)
ALTER PROCEDURE InsertPeisong
(
@UserID varchar(20),
@Name varchar(20),
@Telephone varchar(11),
@Adress varchar(100),
@Totel decimal(15,2),
@Zhuangtai varchar(10)
)
AS
insert into Peisong
(UserID,Name,Telephone,Adress,Totel,Zhuangtai) values (@UserID,@Name,@Telephone,@Adress,@Totel,@Zhuangtai)
RETURN
请问到底哪里出错了?