macamedyousuf-lang

try { if(con.State!=ConnectionState.Open) con.Open(); string searchValue = txtsearch.Text.Trim(); string query = "select *from Orders WHERE OrderID = @search OR OrderID LIKE @searchName"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@search", searchValue);...