好像你写得对吧。。 submitDataadapt = New SqlDataAdapter("Insertmaintain", databaseConnection) submitDataadapt.InsertCommand = New SqlCommand("Insertmaintain", databaseConnection) submitDataadapt.InsertCommand.CommandType = CommandType.StoredProcedure submitDataadapt.InsertCommand.Parameters.Add(New SqlParameter("@city_no", SqlDbType.Decimal)) submitDataadapt.InsertCommand.Parameters("@city_no").Value = strCityno
把引号去掉。。 "txtpassword.text" --〉 txtpassword.text
SqlParameter myBigclassid = new SqlParameter("@bigclassid",SqlDbType.Int,4); myBigclassid.Value = txtUserName.text; myCommand.Parameters.Add(myBigclassid);我用的是SP
SqlDbType.VarChar 后面不用长度... 试试呢!!
這個沒有問題,看看: Sub UpDateOrders() Dim MyCommandUpDateOrders as OleDbCommand Dim UpDateOrdersCmd As String = "Update [min] set Orders=@Orders where id="&id MyCommandUpDateOrders = New OleDbCommand(UpDateOrdersCmd, MyConnection) MyCommandUpDateOrders.parameters.add("@Orders",now.tostring) MyCommandUpDateOrders.Connection.Open() MyCommandUpDateOrders.ExecuteNonQuery() MyCommandUpDateOrders.Connection.Close() End Sub
submitDataadapt = New SqlDataAdapter("Insertmaintain", databaseConnection)
submitDataadapt.InsertCommand = New SqlCommand("Insertmaintain", databaseConnection)
submitDataadapt.InsertCommand.CommandType = CommandType.StoredProcedure submitDataadapt.InsertCommand.Parameters.Add(New SqlParameter("@city_no", SqlDbType.Decimal))
submitDataadapt.InsertCommand.Parameters("@city_no").Value = strCityno
"txtpassword.text" --〉 txtpassword.text
myBigclassid.Value = txtUserName.text;
myCommand.Parameters.Add(myBigclassid);我用的是SP
SqlDbType.VarChar 后面不用长度... 试试呢!!
Sub UpDateOrders()
Dim MyCommandUpDateOrders as OleDbCommand
Dim UpDateOrdersCmd As String = "Update [min] set Orders=@Orders where id="&id
MyCommandUpDateOrders = New OleDbCommand(UpDateOrdersCmd, MyConnection)
MyCommandUpDateOrders.parameters.add("@Orders",now.tostring)
MyCommandUpDateOrders.Connection.Open()
MyCommandUpDateOrders.ExecuteNonQuery()
MyCommandUpDateOrders.Connection.Close()
End Sub