数据怎么插入 （.net）

[sunchengrui2008]

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ads As AccessDataSource
ads = New AccessDataSource()
ads.InsertCommand = "insert into ExpenditureCategory (CategoryName) values (?)"
ads.InsertParameters.Add("CategoryName", Session("CategoryName"), TextBox1.Text)
End Sub


拜托了，各位大哥！！！！

[宝_爸]

ads.InsertCommand = "insert into ExpenditureCategory (CategoryName) values ('"+ TextBox1.Text+"')"

[nosuchtracter]

直接写SQL语句的还真想不起来了。

ads.insertcommand="INSERT INTO Shippers (CategoryName) VALUES (@CategoryName)">
ads.InsertParameters.Add("@CategoryName", Session("CategoryName"), TextBox1.Text) 

MSDN上查的

[YnSky]

到网上下载点代码.多看看
代码多的是.关键是学会思想.

[sunchengrui2008]

多谢各位

[flyerwing]

ads.InsertCommand = "insert into ExpenditureCategory (CategoryName) values ('"+ TextBox1.Text+"')"
试下