private void filterdatagrid(string valueToSearch)
{
try
{
condatabase.Open();
// MySqlCommand cmd = new MySqlCommand("Select * from vesselmonitoring where date between curdate() and date_add(curdate(),interval 2 day) ", condatabase);
MySqlCommand cmd = new MySqlCommand("Select * from vesselmonitoring where concat (`month`,`date`,`vesselname`,`lastport`,`date_depart`,`nextport`) like '%" + valueToSearch + "%'", condatabase);
private void filterdatagrid(string valueToSearch)
{
try
{
condatabase.Open();
// MySqlCommand cmd = new MySqlCommand("Select * from vesselmonitoring where date between curdate() and date_add(curdate(),interval 2 day) ", condatabase);
MySqlCommand cmd = new MySqlCommand("Select * from vesselmonitoring where concat (`month`,`date`,`vesselname`,`lastport`,`date_depart`,`nextport`) like '%" + valueToSearch + "%'", condatabase);
ah thanks boss try ko mamaya kailangan lang po kasi mg search sa records sa database and then display into datagrid i have 1 textbox and 1 botton name of buton ay search
ah thanks boss try ko mamaya kailangan lang po kasi mg search sa records sa database and then display into datagrid i have 1 textbox and 1 botton name of buton ay search
private void filterdatagrid(string valueToSearch)
{
try
{
condatabase.Open();
// MySqlCommand cmd = new MySqlCommand("Select * from vesselmonitoring where date between curdate() and date_add(curdate(),interval 2 day) ", condatabase);
MySqlCommand cmd = new MySqlCommand("Select * from vesselmonitoring where concat (`month`,`date`,`vesselname`,`lastport`,`date_depart`,`nextport`) like '%" + valueToSearch + "%'", condatabase);