- TS TS
- #21
yes po marami napo ako tinatry na mga codes sa google,YøùTùbé ayaw mg run. im using c# sqlmysql database mo?
yes po marami napo ako tinatry na mga codes sa google,YøùTùbé ayaw mg run. im using c# sqlmysql database mo?
yes po mysql po gamit komysql database mo?
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
ganyan nga yung code ko kaso ung datagrid ko meron sariling setupah 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
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