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); } }