can´t use a stored procedure from vb.net
I am trying to call an sp from vb.net, my code is this:
Dim myConn As New MySqlConnection
Dim coneccion As New cConeccion
myConn = coneccion.conectar
Dim myCommand As New MySqlCommand
myCommand.Connection = myConn
myCommand.CommandText = "spInsertarCliente"
myCommand.CommandType = CommandType.StoredProcedure
myCommand.Parameters.Add("?nombre", ocliente.Nombre)
myCommand.Parameters("?nombre").Direction = ParameterDirection.Input
myCommand.Parameters.Add("?direccion", ocliente.Direccion)
myCommand.Parameters("?direccion").Direction = ParameterDirection.Input
myCommand.Parameters.Add("?telefono", ocliente.Telefono)
myCommand.Parameters("?telefono").Direction = ParameterDirection.Input
myCommand.Parameters.Add("?celular", ocliente.Celular)
myCommand.Parameters("?celular").Direction = ParameterDirection.Input
myCommand.Parameters.Add("?email", ocliente.Email)
myCommand.Parameters("?email").Direction = ParameterDirection.Input
myCommand.Parameters.Add("?tipo", ocliente.Tipo)
myCommand.Parameters("?tipo").Direction = ParameterDirection.Input
myCommand.ExecuteNonQuery()
This is the error:
Excepción no controlada del tipo 'System.Resources.MissingManifestResourceException' en mscorlib.dll
Información adicional: No se encontraron recursos adecuados para la referencia cultural especificada (o para la referencia cultural neutra) en el ensamblado proporcionado. Compruebe si "MySql.Data.MySqlClient.MySqlClient.Strings.resources" se ha incrustado o vinculado correctamente en el ensamblado "MySql.Data".
baseName: MySql.Data.MySqlClient.MySqlClient.Strings locationInfo: <null> resource file name: MySql.Data.MySqlClient.MySqlClient.Strings.resources assembly: MySql.Data, Version=1.0.5.13785, Culture=neutral, PublicKeyToken=c5687fc88969c44d
Sory for the error message, I´m from argentina and my vb.net is in spanish, en my english is not very good!!!
Thanks, Alejandro.
Subject
Views
Written By
Posted
can´t use a stored procedure from vb.net
3391
October 02, 2005 03:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.