private void loadData(string keyword)
{
ClassCrud.sql = "SELECT id, firstname, lastname, address, CONCAT(firstname, '', lastname) as fullname, gender from tbl_biodata " +
"WHERE CONCAT(CAST(id as varchar), ' ', firstname, ' ' , lastname) LIKE @keyword::varchar " +
"OR TRIM(gender) LIKE @keyword::varchar ORDER By id asc";
//ClassCrud.sql = "Select * from tbl_biodata";
string keyWordStr = string.Format("%{0}%", keyword);
ClassCrud.command = new NpgsqlCommand(ClassCrud.sql, ClassCrud.npgsqlConnection);
ClassCrud.command.Parameters.Clear();
ClassCrud.command.Parameters.AddWithValue("keyword", keyWordStr);
DataTable dataTable = new DataTable();
dataTable = ClassCrud.PerformCrud(ClassCrud.command);
if (dataTable.Rows.Count > 0)
{
jmlRow = Convert.ToInt32(dataTable.Rows.Count.ToString());
}
else
{
jmlRow = 0;
}
toolStripStatusLabel1.Text = "Number of rows " + jmlRow;
DataGridView dataGridView = dataGridView1;
dataGridView.MultiSelect = false;
dataGridView.AutoGenerateColumns = true;
dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView.DataSource = dataTable;
dataGridView.Columns[0].HeaderText = "ID";
dataGridView.Columns[1].HeaderText = "First Name";
dataGridView.Columns[2].HeaderText = "Last Name";
dataGridView.Columns[3].HeaderText = "Address";
dataGridView.Columns[4].HeaderText = "Fulll Name";
dataGridView.Columns[0].Width = 25;
dataGridView.Columns[1].Width = 100;
dataGridView.Columns[2].Width = 100;
dataGridView.Columns[3].Width = 100;
dataGridView.Columns[4].Width = 100;
buttonInsert.Enabled = true;
}
private void execute(string psql_, string param)
{
ClassCrud.command = new NpgsqlCommand(psql_, ClassCrud.npgsqlConnection);
addParameter(param);
ClassCrud.PerformCrud(ClassCrud.command);
}
