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