private void MainForm_Load(object sender, EventArgs e)
{
this.synch_AccountsTableAdapter.Fill(this.synchDataDataSet.Synch_Accounts);
LoginDetails k = new LoginDetails();
Inside l = new Inside();
label4.Text = "Welcome," + l.GetMyName(k.GetUserID()) + "!";
timer1.Enabled = true;
timer1.Interval = 1000;
Connection g = new Connection();
using (SqlConnection con = new SqlConnection(g.connectionClass()))
{
using (SqlCommand cmd = new SqlCommand("SELECT Report_Title, Report_DateTime, Report_Recipient, Report_Content FROM Synch_Report WHERE Report_UserAccount=" + k.GetUserID(), con))
{
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
gridview.DataSource = dt;
gridview.AutoGenerateColumns = false;
gridview.Columns["Report_Title"].HeaderText = "Title";
gridview.Columns["Report_DateTime"].HeaderText = "Date Time Created";
gridview.Columns["Report_DateTime"].HeaderText = "Recipient";
gridview.Columns["Report_Content"].HeaderText = "Content";
}
}
}
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
Inside f = new Inside();
txtManager.Text = f.GetMyName(comboBox1.SelectedValue.ToString());
}