I want to search the rows which matches given keyword.

I have a table where for one person i have several records.

I have combined several record for one person in one row with the following code and having total balance in this row.

Question

Now my challenge is i want to search the person by using keyword.Like if i give name it will display only that person row in the datagrid view??

*Form is attached with with post.

private void btnSaleSearch_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(myconnstrng);
//Create Datatable to hold the data frmo database
DataTable dt = new DataTable();
try
{
decimal j = 0;
string sql = "select Name, SUM(Balance_Amt) As Balance_Amt from tbl_Transactions_Rak Group By Name";
SqlCommand cmd = new SqlCommand(sql, conn);
//Sql data Adapter to hold the values from database temporarily
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//open Database connection
conn.Open();
adapter.Fill(dt);
dataGridView.DataSource = dt;
foreach (DataRow dr in dt.Rows)
{
j = j + Convert.ToDecimal(dr["Balance_Amt"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
{
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tayyab Jatoi7y ago
Hi when i have used given query but when i am trying to run the project its giving me below error

Incorrect syntax near the keyword 'from'.

string sql = "select Name, SUM(Balance_Amt) As Balance_Amt where name like '%searchedName%' from tbl_Transactions_Digdaga Group By Name";
Please help.
0
Amit Gupta7y ago
You can use where keyword in your query string sql = "select Name, SUM(Balance_Amt) As Balance_Amt from tbl_Transactions_Rak where name like '%searchedName%' Group By Name";
0