Click here to Skip to main content
15,892,746 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
P
VB
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"
Posted
Updated 17-Feb-14 1:57am
v2

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.
 
Share this answer
 
Comments
Ni!E$H_WAGH 18-Feb-14 4:20am    
Thanks
you can use stored Procedure. Check details
Overview of SQL Server Stored Procedure[^]
 
Share this answer
 
Comments
Ni!E$H_WAGH 18-Feb-14 4:20am    
Thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900