private void BindGridData() { EWA_Messages objEWA = new EWA_Messages(); BL_Messages objBL = new BL_Messages(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.FacultyId = Session["UserCode"].ToString(); objEWA.Action = "FetchStaffMessage"; ds = objBL.BindGrdViewAnnouncement_BL(objEWA); if (ds.Tables[0].Rows.Count == 0) { GrdViewAnnouncement.DataSource = ReturnEmptyDataTable(); GrdViewAnnouncement.DataBind(); GrdViewAnnouncement.Columns[3].Visible = false; GrdViewAnnouncement.Rows[0].Cells[0].ColumnSpan = 3; GrdViewAnnouncement.Rows[0].Cells[1].Visible = false; GrdViewAnnouncement.Rows[0].Cells[2].Visible = false; lblNoMessageFound.Visible = true; } else { // GrdViewAnnouncement.DataSource = db.Displaygrid(" SELECT DISTINCT ms.MessageId, md.StaffUserCode, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent FROM tblMessageSave AS ms INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StaffUserCode = '" + objEWA.FacultyId + "'))) AND (ms.OrgId = '" + objEWA.OrgId + "') "); GrdViewAnnouncement.DataSource = db.Displaygrid(" SELECT DISTINCT ms.MessageId, md.StaffUserCode, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent FROM tblMessageSave AS ms INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StaffUserCode = '" + objEWA.FacultyId + "'))) AND (md.StaffUserCode = '" + objEWA.FacultyId + "') AND (ms.OrgId = '" + objEWA.OrgId + "') ORDER BY ms.MessageId DESC "); GrdViewAnnouncement.DataBind(); // GrdViewAnnouncement.DataBind(); dsGrdViewAnnouncement = ds.Copy(); } }
protected void BindGridData() { EWA_Messages objEWA = new EWA_Messages(); BL_Messages objBL = new BL_Messages(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.StudentId = Session["UserCode"].ToString(); objEWA.Action = "FetchStudentMessage"; ds = objBL.BindGrdViewAnnouncement_BL(objEWA); //SqlCommand cmd1 = new SqlCommand(" SELECT DISTINCT ms.MessageId, er.FirstName + ' ' + er.MiddleName + ' ' + er.LastName AS 'Sender', ms.Subject, CONVERT(varchar, md.SendDate, 107) AS 'SendDate', ms.MessageContent, md.StudentUserCode FROM tblMessageSave AS ms INNER JOIN tblEmployee AS er ON ms.StaffUserCode = er.UserCode INNER JOIN tblMessageDetails AS md ON ms.MessageId = md.MessageId WHERE (ms.MessageId IN (SELECT MessageId FROM tblMessageDetails WHERE (StudentUserCode = '" + objEWA.StudentId + "'))) AND (ms.OrgId = '" + objEWA.OrgId + "') AND (md.StudentUserCode = '" + objEWA.StudentId + "') order by (MessageId) desc", cn); //SqlDataAdapter adp1 = new SqlDataAdapter(); //DataSet ds1 = new DataSet(); //adp1.SelectCommand = cmd1; //adp1.Fill(ds1); if (ds.Tables[0].Rows.Count == 0) { GrdViewAnnouncement.DataSource = ReturnEmptyDataTable(); GrdViewAnnouncement.DataBind(); GrdViewAnnouncement.Columns[3].Visible = false; GrdViewAnnouncement.Rows[0].Cells[0].ColumnSpan = 3; GrdViewAnnouncement.Rows[0].Cells[1].Visible = false; GrdViewAnnouncement.Rows[0].Cells[2].Visible = false; lblNoMessageFound.Visible = true; } else { GrdViewAnnouncement.DataSource = ds; GrdViewAnnouncement.DataBind(); dsGrdViewAnnouncement = ds.Copy(); } }