🔒 Closed Pa help po sa c# codes

[Picathuu]

mysql database mo?

yes po marami napo ako tinatry na mga codes sa google,youtube ayaw mg run. im using c# sql

 

[That Poppy]

gumawa ka nlang ng private void tulad nito


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





MySqlDataReader readerSelect = cmd.ExecuteReader();



if (readerSelect.Read())
{
setupDG(); //reset datagrid1 and listbox1
int i = 0;
do
{
dg1.Rows.Add(readerSelect["ctrlno"].ToString(),
readerSelect["date"].ToString(),
readerSelect["vesselname"].ToString(),
readerSelect["lastport"].ToString(),
readerSelect["voyageno"].ToString(),
readerSelect["logtime"].ToString(),
readerSelect["eta"].ToString(),
readerSelect["ata"].ToString(),
readerSelect["berth"].ToString(),
readerSelect["date_depart"].ToString(),
readerSelect["berth_departure"].ToString(),
readerSelect["nextport"].ToString(),
readerSelect["voyageno_depart"].ToString(),
readerSelect["etd"].ToString(),
readerSelect["atd"].ToString());



i++;
} while (readerSelect.Read());
}
else
{
//display no data on grid
setupDG();
dg1.Rows.Add("No available Data", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
}
readerSelect.Close();

}
catch (Exception e)
{
MessageBox.Show("Something went wrong!\n System says: " + e, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
condatabase.Close();

}
}

tpos ganito ilagay mo sa search button

private void btn_search_Click(object sender, EventArgs e)
{

string valueToSearch = txt_search.Text.ToString();
filterdatagrid(valueToSearch);
}


itong code ko ay gawin mo lng basehan dahil sure ko iba ang takbo ng system mo sa akin kumuha ka lang ng tips dito

 

[Picathuu]

mysql database mo?

yes po mysql po gamit ko

 

[Picathuu]

gumawa ka nlang ng private void tulad nito


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





MySqlDataReader readerSelect = cmd.ExecuteReader();



if (readerSelect.Read())
{
setupDG(); //reset datagrid1 and listbox1
int i = 0;
do
{
dg1.Rows.Add(readerSelect["ctrlno"].ToString(),
readerSelect["date"].ToString(),
readerSelect["vesselname"].ToString(),
readerSelect["lastport"].ToString(),
readerSelect["voyageno"].ToString(),
readerSelect["logtime"].ToString(),
readerSelect["eta"].ToString(),
readerSelect["ata"].ToString(),
readerSelect["berth"].ToString(),
readerSelect["date_depart"].ToString(),
readerSelect["berth_departure"].ToString(),
readerSelect["nextport"].ToString(),
readerSelect["voyageno_depart"].ToString(),
readerSelect["etd"].ToString(),
readerSelect["atd"].ToString());



i++;
} while (readerSelect.Read());
}
else
{
//display no data on grid
setupDG();
dg1.Rows.Add("No available Data", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
}
readerSelect.Close();

}
catch (Exception e)
{
MessageBox.Show("Something went wrong!\n System says: " + e, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
condatabase.Close();

}
}

tpos ganito ilagay mo sa search button

private void btn_search_Click(object sender, EventArgs e)
{

string valueToSearch = txt_search.Text.ToString();
filterdatagrid(valueToSearch);
}


itong code ko ay gawin mo lng basehan dahil sure ko iba ang takbo ng system mo sa akin kumuha ka lang ng tips ditoView attachment 139323

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

 

[That Poppy]

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

ganyan nga yung code ko kaso ung datagrid ko meron sariling setup

 

[Picathuu]

ano senisetup mo bos sa datagrid ?

 

[That Poppy]

i mean naka code ung setup nung datagrid ko. kasi db pwde mo nmn i setup un sa properties ng datagrid

 

[Picathuu]

gumawa ka nlang ng private void tulad nito


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





MySqlDataReader readerSelect = cmd.ExecuteReader();



if (readerSelect.Read())
{
setupDG(); //reset datagrid1 and listbox1
int i = 0;
do
{
dg1.Rows.Add(readerSelect["ctrlno"].ToString(),
readerSelect["date"].ToString(),
readerSelect["vesselname"].ToString(),
readerSelect["lastport"].ToString(),
readerSelect["voyageno"].ToString(),
readerSelect["logtime"].ToString(),
readerSelect["eta"].ToString(),
readerSelect["ata"].ToString(),
readerSelect["berth"].ToString(),
readerSelect["date_depart"].ToString(),
readerSelect["berth_departure"].ToString(),
readerSelect["nextport"].ToString(),
readerSelect["voyageno_depart"].ToString(),
readerSelect["etd"].ToString(),
readerSelect["atd"].ToString());



i++;
} while (readerSelect.Read());
}
else
{
//display no data on grid
setupDG();
dg1.Rows.Add("No available Data", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
}
readerSelect.Close();

}
catch (Exception e)
{
MessageBox.Show("Something went wrong!\n System says: " + e, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
condatabase.Close();

}
}

tpos ganito ilagay mo sa search button

private void btn_search_Click(object sender, EventArgs e)
{

string valueToSearch = txt_search.Text.ToString();
filterdatagrid(valueToSearch);
}


itong code ko ay gawin mo lng basehan dahil sure ko iba ang takbo ng system mo sa akin kumuha ka lang ng tips ditoView attachment 139323

#ano pong gagawin dito mga boss ?