I am trying to do the following:
myDT =
C_Articulo.Cargar_Codigo_Articulo(int.Parse(Txt_Id_Producto.Text));
int auxidcodigo;
string auxtipocodigo, auxcodigo;
if (myDT.Rows.Count > 0)
{
auxidcodigo = int.Parse(myDT.Columns[0].ToString());
auxtipocodigo = myDT.Columns[1].ToString();
auxcodigo = myDT.Columns[2].ToString();
DGV_Codigos_Producto.Rows.Add(auxidcodigo, auxtipocodigo,
auxidcodigo);
}
The method Cargar_Codigo_Articulo has the following code:
//------------------------------------------------------------------
public DataTable Cargar_Codigo_Articulo(int L_Id_Articulo)
{// Devuelve todos los codigos de un determinado articulo
MySql.Data.MySqlClient.MySqlConnection conn;
String ConStr;
Global_Proc CGlobal = new Global_Proc();
ConStr = CGlobal.BuscarConnString(CGlobal.archivoConfiguracion);
try
{
conn = new MySql.Data.MySqlClient.MySqlConnection();
conn.ConnectionString = ConStr;
conn.Open(); //Abro la conexion
// Crea el command de la consulta
MySql.Data.MySqlClient.MySqlCommand CommSql = new
MySql.Data.MySqlClient.MySqlCommand();
// Asigno la conexion al command
CommSql.Connection = conn;
// Ingreso la consulta a ejecutar
CommSql.CommandText = "Select
codigo_articulo.Id_Tipo_Codigo,parametro.Descripcion,codigo_articulo.codigo
"
+"from codigo_articulo inner join
parametro "
+"on parametro.Id_Parametro =
codigo_articulo.Id_Tipo_Codigo where "
+"Id_Articulo = @PId_Articulo "
+ "order by
parametro.Descripcion asc";
CommSql.Parameters.AddWithValue("@PId_Articulo",
L_Id_Articulo);
MySql.Data.MySqlClient.MySqlDataAdapter myDA =
new
MySql.Data.MySqlClient.MySqlDataAdapter(CommSql);
DataTable myDT = new DataTable();
myDA.Fill(myDT);
conn.Close(); //Cierro la conexion
return myDT;
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
return null;
// Aqui deberia enviar algun tipo de mensaje sobre la
excepcion
}
}// fin del Metodo Cargar_Grupo_Parametro
//------------------------------------------------------------------
but the problem is that in the line
auxidcodigo = int.Parse(myDT.Columns[0].ToString());
Throw a incorrect fomat exception.
How can I fix this?
Greetings and thks
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
