获取不了存储过程输出参数
Dim mess As String
myConn = New SqlConnection("server=LENOVO-B9B16E97;uid=sa;pwd=111111;database=navigate")
myConn.Open()
myComm = New SqlCommand("Addpoint", myConn)
myComm.CommandType = CommandType.StoredProcedure
myComm.Parameters.Add("@p_PlaNo", SqlDbType.Char, 10)
myComm.Parameters("@p_PlaNo").Value = Trim(TextBox5.Text)
myComm.Parameters.Add("@p_PlaName", SqlDbType.Char, 20)
myComm.Parameters("@p_PlaName").Value = Trim(TextBox7.Text)
myComm.Parameters.Add("@p_Weather", SqlDbType.VarChar, 20)
myComm.Parameters("@p_Weather").Value = Trim(TextBox17.Text)
myComm.Parameters.Add("@p_Information", SqlDbType.VarChar, 30)
myComm.Parameters("@p_Information").Value = Trim(TextBox6.Text)
myComm.Parameters.Add("@p_ZipCode", SqlDbType.VarChar, 10)
myComm.Parameters("@p_ZipCode").Value = Trim(TextBox8.Text)
myComm.Parameters.Add("@p_PlaX", SqlDbType.VarChar, 10)
myComm.Parameters("@p_PlaX").Value = Trim(TextBox3.Text)
myComm.Parameters.Add("@p_PlaY", SqlDbType.VarChar, 10)
myComm.Parameters("@p_PlaY").Value = Trim(TextBox4.Text)
myComm.Parameters.Add("@p_mess", SqlDbType.VarChar, 20)
myComm.Parameters("@p_mess").Direction = ParameterDirection.Output
myDataread = myComm.ExecuteReader
mess = CStr(myComm.Parameters.Item("@p_mess").Value).Trim
MessageBox.Show(mess)
----------------------------------------------------------------------------------------------------
这一段可以插入数据但是在mess = CStr(myComm.Parameters.Item("@p_mess").Value).Trim
这一句会产生异常