public static Resultados FGeneral(string query, params SqlParameter[] parametros)
{
Resultados result = new Resultados();
result.dtResult = new DataTable();
SqlCommand cmd = new SqlCommand();
string strcon = ConfigurationManager.ConnectionStrings["conx"].ConnectionString;
SqlConnection con = new SqlConnection(strcon);
SqlDataAdapter adap = new SqlDataAdapter();
cmd.Connection = con;
cmd.CommandText = query;
cmd.CommandType = CommandType.StoredProcedure;
adap.SelectCommand = cmd;
foreach (var parametro in parametros)
{
cmd.Parameters.Add(parametro);
}
try
{
con.Open();
adap.Fill(result.dtResult);
con.Close();
result.mensaje = "OK";
}
catch (Exception ex) { result.mensaje = ex.Message; }
return(result);
}
public static Resultados FGeneral(string query)
{
Resultados result = new Resultados();
result.dtResult = new DataTable();
string strcon = ConfigurationManager.ConnectionStrings["conx"].ConnectionString;
SqlConnection con = new SqlConnection(strcon);
SqlDataAdapter adap = new SqlDataAdapter(query, con);
try {
con.Open();
adap.Fill(result.dtResult);
con.Close();
result.mensaje = "OK";
} catch (Exception ex) { result.mensaje = ex.Message; }
return(result);
}
