I have a SQL Server table with in Indetity column (value auto
generated).
I have tried to write my own updatecommand code.
I can't get it to work.
An error says that says Sku and rid are invalid column names. I don't
know why.
I even modified the Updatecommand the a bare bones
"UPDATE dbo.test1 SET sku = @SKU"
At least this gave me a different error!
The error says error in Prepared statement
"@SKU(20) Update dbo.test1 SET sku = @SKU"
Can anyone help?
Thanks,
Stu
Public da As Data.SqlClient.SqlDataAdapter, ds As DataSet, conn As
Data.SqlClient.SqlConnection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
da.Update(ds, "CustSKUDateSettings")
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the
'Viaware_arc_testDataSet1.CustSKUDateSettings' table. You can move, or
remove it, as needed.
Dim conn As New Data.SqlClient.SqlConnection
conn.ConnectionString = "..."
ds = New DataSet
da = New Data.SqlClient.SqlDataAdapter
da.SelectCommand = New Data.SqlClient.SqlCommand
da.SelectCommand.Connection = conn
da.InsertCommand = New Data.SqlClient.SqlCommand
da.InsertCommand.Connection = conn
da.UpdateCommand = New Data.SqlClient.SqlCommand
da.UpdateCommand.Connection = conn
da.SelectCommand.CommandText = "Select rid, custnum, sku,
search_date_type, date_range, date_sort_order, days_to_start,
days_to_end from CustSKUDateSettings"
da.Fill(ds, "CustSKUDateSettings")
DataGridView1.DataSource = ds.Tables("CustSKUDateSettings")
da.UpdateCommand.CommandText = " UPDATE dbo.test1 " & _
"SET sku = @SKU, " & _
"WHERE rid = @rid " & _
"CustNum = @CustNum, " &
_
"search_date_type =
@search_date_type," & _
"date_range =
@date_range," & _
"date_sort_order =
@date_sort_order," & _
"days_to_start =
@days_to_start," & _
"days_to_end =
@days_to_end " & _
da.UpdateCommand.CommandType = System.Data.CommandType.Text
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@rid", System.Data.SqlDbType.Int, 4,
"rid"))
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@SKU", System.Data.SqlDbType.Char,
20, "dbo.test1.sku"))
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@CustNum",
System.Data.SqlDbType.[Char], 15, "CustNum"))
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@search_date_t ype",
System.Data.SqlDbType.[Char], 1, "search_date_type"))
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@date_range",
System.Data.SqlDbType.[Char], 1, "date_range"))
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@date_sort_ord er",
System.Data.SqlDbType.[Char], 1, "date_sort_order"))
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@days_to_start ",
System.Data.SqlDbType.Int, 4, "days_to_start"))
da.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@days_to_end",
System.Data.SqlDbType.Int, 4, "days_to_end"))
*** Sent via Developersdex
http://www.developersdex.com ***