protected void LinkButtonInbox_Click(object sender, EventArgs e) { MultiView2.ActiveViewIndex = 2; string query = "SELECT Message, [From], Datetime, Seen, Id FROM Messages WHERE [To] ='Admin' ORDER BY Datetime DESC, [From];select f.FilePath, f.Datetime,f.[From],f.Seen,f.Id from Files f where f.[To]='Admin' order by f.Datetime desc"; dbConnect db = new dbConnect(); DataSet dset = db.executeSelectStatemant(query); ListViewMessages.DataSource = dset.Tables[0]; ListViewMessages.DataBind(); ListViewFiles.DataSource = dset.Tables[1]; ListViewFiles.DataBind(); }
protected void LinkButtonInbox_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 2; string query = "SELECT Message, [From], Datetime, Seen, Id FROM Messages WHERE [To] ='Dept-" + id + "' ORDER BY Datetime DESC, [From]"; dbConnect db = new dbConnect(); DataSet dset = db.executeSelectStatemant(query); if (!dset.HasErrors && dset.Tables[0].Rows.Count > 0) { ListViewMessages.DataSource = dset.Tables[0]; ListViewMessages.DataBind(); } query = "select f.FilePath, f.Datetime,f.[From],f.Seen,f.Id from Files f where f.[To]='Dept-" + id + "' order by f.Datetime desc"; dset.Clear(); dset = db.executeSelectStatemant(query); if ((!dset.HasErrors) && dset.Tables[0].Rows.Count > 0) { ListViewFiles.DataSource = dset.Tables[0]; ListViewFiles.DataBind(); } }