protected void Page_Load(object sender, EventArgs e)
{
this.UnobtrusiveValidationMode = System.Web.UI.UnobtrusiveValidationMode.None;
string strSQLUser = null;
string strSQLMessage = null;
strSQLUser = "******";
connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("VanierFaces.accdb") + ";Persist Security Info=False;");
connection.Open();
cmd = new OleDbCommand(strSQLUser, connection);
OleDbDataAdapter adpU = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
adpU.Fill(ds);
GridViewUser.DataSource = ds;
GridViewUser.DataBind();
strSQLMessage = "SELECT sender, message, date_sent FROM tblMessages WHERE receiver = 'ewq'";
cmd = new OleDbCommand(strSQLMessage, connection);
OleDbDataAdapter adpM = new OleDbDataAdapter(cmd);
DataSet dsM = new DataSet();
adpM.Fill(dsM);
GridViewMessage.DataSource = dsM;
GridViewMessage.DataBind();
username = Session["username"].ToString();
userProfile = Session["userProfile"].ToString();
}
private void fillMessage()
{
string Error = "";
DBMessage msgObj = new DBMessage();
DataTable table = msgObj.getAllMessage(ref Error);
GridViewMessage.DataSource = table;
GridViewMessage.DataBind();
}
private void GridViewMessageBind()
{
GridViewMessage.DataSource = Connection.dbTable("SELECT * FROM message ORDER BY ID DESC");
GridViewMessage.DataBind();
}
private void GridViewMessageBind()
{
GridViewMessage.DataSource = Connection.dbTable("SELECT Date_Sent, Message FROM message WHERE Recipient='" + recipientlbl.Text + "' ORDER BY ID DESC");
GridViewMessage.DataBind();
}
