private void BindGrid() { MySqlConnection con = new MySqlConnection(constr); MySqlCommand cmd = new MySqlCommand("SELECT * FROM images where Image_ID in (" + String.Join(",", getImage_ID()) + ")", con); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gvImages.DataSource = dt; gvImages.DataBind(); } private List<int> getImage_ID() { List<int> i = new List<int>(); MySqlConnection con = new MySqlConnection(constr); con.Open(); string query = "Select Come_Image_ID1, Leave_Image_ID from register where Students_ID='" + getStudents_ID() + "' AND Come_Image_ID IS NOT NULL AND Leave_Image_ID IS NOT NULL"; MySqlCommand cmd = new MySqlCommand(query); cmd.Connection = con; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { foreach (DbDataRecord s in reader) { i.Add(s.GetInt32(0)); i.Add(s.GetInt32(1)); } } reader.Close(); return i; }
while (reader.Read()) { reader.Add(s.GetInt32(0)); reader.Add(s.GetInt32(1)); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)