MySQL Forums
Forum List  »  Stored Procedures

can´t use a stored procedure from vb.net
Posted by: alejandro de rosa
Date: October 02, 2005 03:16PM

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.

Options: ReplyQuote


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.