Database db = new Database();

var reader = db.select("select * from users");
while (reader.Read())
{
    //reader["userid"].ToString();
}

string[] value = { txtUsername.Text, txtPassword.Text, cmbSex.Text };
string[] column = { "username", "password", "sex" };
db.save("users", column, value);

//or

db.cud("INSERT INTO users (username,password,sex) VALUES ('" + txtUsername.Text + "','" + txtPassword.Text + "','" + cmbSex.Text + "')","Successfully Saved");

db.cud("Sql Query Here","Successfully Saved/Updated/Deleted");

//optional
string[] customheader = { "User ID", "Username", "Gender" };
//the table methods
db.table("select userid,username,sex from users", dgvUsers, customheader);

UI_events ui = new UI_events();

frmDashboard dash = new frmDashboard();
ui.FormShow(dash, "Fill");

frmMain frmain = new frmMain();
ui.Show(frmain, this);

frmMain frmain = new frmMain();
ui.Dialog(frmain);

void loadChartSample()
{
    /*
    * SERIES MALE
    */

    // Array Legend
    string[] X = { "BSIT", "BSED" };
    // Add item to array Legend
    X = X.Concat(new string[] { "AB" }).ToArray(); 
    // new X is "BSIT", "BSED", "AB"


    // Array Value
    int[] Y = { 12, 14 };
    // Add item to array
    Y = Y.Concat(new int[] { 2 }).ToArray(); 
    // Y = 12, 14, 2


    // Pass to Chart Methods = Male Series
    ui.chart(chartUser, "Male", X, Y, "Column");

    //_________________________________________________________________________________
    
    /*
    * NEW SERIES FEMALE
    */

    // new 
    string[] x2 = { "BSIT", "BSED", "AB" };
    int[] y2 = { 6, 0, 16 };

    // Female
    ui.chart(chartUser, "Female", x2, y2, "Column");
}

/*
* SERIES SEX
*/
string[] X = {};
int[] Y = {};

var reader = db.select("select count(*) as c, sex from users group by sex");
while (reader.Read())
{
    X = X.Concat(new string[] { reader["sex"].ToString() }).ToArray();
    Y = Y.Concat(new int[] { Int32.Parse(reader["c"].ToString()) }).ToArray();
}

// Chart Methods
// ChartSeries = "Sex"; ChartType = "Column";
ui.chart(chartUser, "Sex", X, Y, "Column");

Validations validate = new Validations();

TextBox[] txt = { txtUsername, txtPassword, txtCPassword };
ComboBox[] cmb = { cmbSex };
if (!validate.txtRequired(txt) || !validate.cmbRequired(cmb))
    return;

private void txtUsername_KeyPress(object sender, KeyPressEventArgs e)
{
    validate.alphanum(e);
}

/*
* Database Information
*/
public static string dbname = "dbinformation";
public static string dbuser = "root";
public static string dbpassword = "";

public static string upload_path = @"c:\C-Sharf Classes\";
public static string allowedImage = "Image Files|*.jpg;*.jpeg;*.png";
public static string allowedFile = "Excel Files(.xls ,.xlsx)| *.xls ;*.xlsx|PDF Files(.pdf)|*.pdf|Text Files(*.txt)|*.txt|Word Files(.docx ,.doc)|*.docx;*.doc";