public void enviardatos(string nombre_sp)
{
cadconexion cn = new cadconexion();
OdbcDataAdapter da = new OdbcDataAdapter();
OdbcCommand cmd = new OdbcCommand();
DataTable dt = new DataTable();
cmd.Connection = cn.odbc;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = nombre_sp;
cmd.Connection.Close();
cmd.Connection.Open();
da.SelectCommand = cmd;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
//public void enviardatos(string nombre_sp,string param1,string param2)
//{
// cadconexion cn = new cadconexion();
// OdbcDataAdapter da = new OdbcDataAdapter();
// OdbcCommand cmd = new OdbcCommand();
// DataTable dt = new DataTable();
// cmd.Connection = cn.odbc;
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText = nombre_sp;
// cmd.Parameters.Add(param1, Data.SqlDbType.VarChar).Value)
// cmd.Connection.Open();
// da.SelectCommand = cmd;
// cmd.ExecuteNonQuery();
// cmd.Connection.Close();
//}
public DataTable extraedatos(string nombre_sp, string tipo, string cadena)
{
cadconexion cn = new cadconexion();
OdbcDataAdapter da = new OdbcDataAdapter();
OdbcCommand cmd = new OdbcCommand();
DataTable dt = new DataTable();
cmd.Connection = cn.odbc;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = nombre_sp;
cmd.Parameters.AddWithValue(tipo, cadena);
cmd.Connection.Open();
da.SelectCommand = cmd;
cmd.Connection.Close();
da.Fill(dt);
return(dt);
}
public DataTable extraedatos(string nombre_sp)
{
DataTable dt = new DataTable();
cadconexion cn = new cadconexion();
OdbcDataAdapter da = new OdbcDataAdapter();
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = cn.odbc;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = nombre_sp;
cmd.Connection.Close();
cmd.Connection.Open();
da.SelectCommand = cmd;
da.Fill(dt);
cmd.Connection.Close();
return(dt);
}
public long scalar(string nombre_sp)
{
try
{
cadconexion cn = new cadconexion();
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = cn.odbc;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = nombre_sp;
cmd.Connection.Close();
cmd.Connection.Open();
long num = (long)cmd.ExecuteScalar();
cmd.Connection.Close();
return(num);
}
catch
{
return(0);
}
}
