public void button2_Click(object sender, EventArgs e) { DataTable dat; dat = Access.Get("*", "members WHERE user= '******'"); string W = dat.Rows[0][13].ToString(); Hide(); Schedual S1 = new Schedual(W, this.F, gend, name); S1.Show(); }
private void button2_Click(object sender, EventArgs e) { OleDbConnection connect2 = new OleDbConnection(); connect2.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Database1.accdb;Persist Security Info=False;"; connect2.Open(); OleDbCommand command2 = new OleDbCommand(); command2.Connection = connect2; command2.CommandText = "SELECT workout FROM members where user= '******'"; OleDbDataReader reader2 = command2.ExecuteReader(); reader2.Read(); string W = reader2["workout"].ToString(); Schedual S1 = new Schedual(W, this.F, gend, name); Hide(); S1.Show(); connect2.Close(); }