private void button1_Click(object sender, EventArgs e)
{
connection.Open();
OleDbDataAdapter da1 = new OleDbDataAdapter("select * from userDetail", connection);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
string id = "";
int count = 0;
for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
{
if (ds1.Tables[0].Rows[i][4].ToString() == "true")
{
id = ds1.Tables[0].Rows[i][0].ToString();
}
}
OleDbDataAdapter da2 = new OleDbDataAdapter("select * from menu", connection);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
if (ds2.Tables[0].Rows[i][4].ToString() == "true")
{
count++;
}
}
int t = 0;
string[] temp = new string[4] {
"", "", "", ""
};
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
if (ds2.Tables[0].Rows[j][4].ToString() == "true")
{
temp[t] = ds2.Tables[0].Rows[j][0].ToString();
t++;
}
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = connection;
cmd.CommandText = "update userDetail set mID1 = '" + temp[0] + "', mID2 = '" + temp[1] + "', mID3 = '" + temp[2] + "', mID4 = '" + temp[3] + "' where userID = '" + id + "'";
cmd.ExecuteNonQuery();
}
connection.Close();
orderPage op = new orderPage();
op.ShowDialog();
}
private void btnOrder_Click(object sender, EventArgs e)
{
orderPage op = new orderPage();
op.ShowDialog();
}