vb.net 数据库求救

doktorkoo

各位，我的程序打算能让user 输入data进入database,可是现在的问题是程序走完时，跳出窗口说输入成功，可是在数据库里找不到资料。。。我试过很多方法，结果还是一样。。。希望会的人能帮帮我...以下就是我的代码

1.       Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Inventory ", CtnLogin)
   
2.         Dim builder As SqlCommandBuilder = New SqlCommandBuilder(adapter)
   
3.         Dim dataset As DataSet = New DataSet
   
4. 
   
5.         adapter.Fill(dataset, "Inventory")
   
6.         Dim datatable As DataTable = dataset.Tables("Inventory")
   
7. 
   
8.         Dim newRow As DataRow = datatable.NewRow()
   
9.         newRow("InventoryNo") = txtInventoryNo.Text
   
10.         newRow("StockItemNo") = 1
    
11.         newRow("InventoryPrice") = txtPrice.Text
    
12.         newRow("InventoryQuantity") = txtInventoryQuantity.Text
    
13.         newRow("InventoryMeasurement") = txtMeasurement.Text
    
14.         newRow("InventoryProcureMethod") = txtMethod.Text
    
15.         newRow("InventoryProcureDate") = Convert.ToDateTime(DateTimePicker1.Value)
    
16.         newRow("InventoryExpiryDate") = Convert.ToDateTime(DateTimePicker2.Value)
    
17.         newRow("UserNo") = "U001"
    
18. 
    
19.         datatable.Rows.Add(newRow)
    
20.         adapter.Update(dataset, "Inventory")
    
21.         MessageBox.Show("successfully inserted into database", "success info", MessageBoxButtons.OK, MessageBoxIcon.Information)
    
22.         CtnLogin.Close()

复制代码

tatt2

不好意思哦!有个小小的问题问你!!你可以拿DATA出来吗?
SELECT * FROM Inventory???

doktorkoo

回复 2# tatt2

可以拿啊，根据那个"SELECT * FROM Inventory" ,在用datareader 来execute

山野草夫

参考这里的例子，会不会是漏了builder.GetUpdateCommand()

http://msdn.microsoft.com/en-us/ ... adapter.update.aspx

doktorkoo

谢谢大家尝试帮忙，我已经找到原因了，原来是能走的，只是debugger问题