public int getId(string nombre)
{
Helpers.dbConection function = new Helpers.dbConection();
int id;
string query = @"select id from categorias where nombre = @catNombre";
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@catNombre", nombre);
dt = function.queryCmd(cmd);
id = Int32.Parse(dt.Rows[0]["id"].ToString());
return((int)id);
}