我想更新数据库内容但收到错误。 [英] I wanted to update the database content but getting error .

问题描述

P

rotected Sub grv_set_func_obj_RowUpdating(sender As Object, e As GridViewUpdateEventArgs)


        cmd.CommandText = "update MBO_Details set MBO_FUNC_OBJ=@func_obj,MBO_MEASURED_VAR=@measurd_var,MBO_DEADLINE=@tar_dt,MBO_WEIGHT_FACT=@wt_fact  where id=@id;" _
            & "select id,MBO_FUNC_OBJ,MBO_MEASURED_VAR,MBO_DEADLINE,MBO_WEIGHT_FACT from MBO_Details where MBO_EMP_CODE='40000001' "
        MsgBox(cmd.CommandText)
        cmd.Parameters.Add("@id", SqlDbType.BigInt).Value = ID
        cmd.Parameters.Add("@func_obj", SqlDbType.NVarChar).Value = Func_obj
        cmd.Parameters.Add("@measurd_var", SqlDbType.NVarChar).Value = measurd_var
        cmd.Parameters.Add("@tar_dt", SqlDbType.NVarChar).Value = tar_dt
        cmd.Parameters.Add("@wt_fact", SqlDbType.NVarChar).Value = wt_fact
        con.Open()
        grv_set_func_obj.EditIndex = -1
        grv_set_func_obj.DataSource = GetDataTDetails(cmd)
        grv_set_func_obj.DataBind()
        MsgBox(cmd.ExecuteNonQuery())
        con.Close()

    End Sub
    Private Function GetDataTDetails(ByVal cmd As SqlCommand) As DataTable
        Dim dt As New DataTable()
        Dim con As New SqlConnection(strConnString)
        Dim sda As New SqlDataAdapter()
        cmd.CommandType = CommandType.Text
        cmd.Connection = con
        con.Open()
        sda.SelectCommand = cmd
        sda.Fill(dt)
        Return dt
    End Function
End Class

请查看错误查询输入字符串格式不正确

Please look though the query for error saying "Input string was not in a correct format"

推荐答案

我不确定您是否可以混合UPDATE和像你一样在单个查询中使用SELECT语句。



尝试执行两个不同的查询;第一个用于更新数据库，第二个用于选择数据。



祝你好运。

I'm not sure you can mix an UPDATE and a SELECT statements in a single query like you did.

Try to execute two distinct queries instead; the first one to UPDATE your database, and the second one to SELECT your data.

Good luck.

你可以使用存储过程。查看详细信息

SQL Server存储过程概述 [ ^ ]

you can use stored Procedure. Check details
Overview of SQL Server Stored Procedure[^]

这篇关于我想更新数据库内容但收到错误。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！