// public static OleDbConnection connection;
// public static OleDbCommand command;
public DataTable GetData(string sql, string tblName)
{
SqlConnection conn = new ConnectDB2().connection();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, tblName);
return(ds.Tables[0]);
}
public int ExecuteData(string sql)
{
int i;
SqlConnection conn = new ConnectDB2().connection();
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
public DataTable GetData(string sql, string tblName, SqlParameterCollection parameters)
{
SqlConnection conn = new ConnectDB2().connection();
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
foreach (SqlParameter param in parameters)
{
da.SelectCommand.Parameters.AddWithValue(param.ParameterName, param.SqlDbType).Value = param.Value;
}
da.Fill(ds, tblName);
return(ds.Tables[0]);
}
private void connect()
{
Database database = (Database)cbo_databases.SelectedValue;
_connection = new ConnectDB2(database.dsn, database.user, database.password);
if (_connection._statusConnection)
{
_connection.closeConnection();
tool_label.Text = database.name_connection;
}
else
{
tool_label.Text = "Não foi possível conectar\n" + _connection._error;
}
}
public int ExecuteData(string sql, SqlParameterCollection parameters)
{
int i;
SqlConnection conn = new ConnectDB2().connection();
SqlCommand cmd = new SqlCommand(sql, conn);
foreach (SqlParameter param in parameters)
{
cmd.Parameters.AddWithValue(param.ParameterName, param.SqlDbType).Value = param.Value;
}
conn.Open();
i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
