01.using System;
02.using System.Collections.Generic;
03.using System.ComponentModel;
04.using System.Data;
05.using System.Drawing;
06.using System.Linq;
07.using System.Text;
08.using System.Windows.Forms;
09.using System.Data.OleDb;
10.using System.IO;
11.
12.namespace LoginFormCS
13.{
14.
15.
16. public partial class frmMain : Form
17. {
18. public frmMain()
19. {
20. InitializeComponent();
21. }
22.
23. string strUser;
24. public string _strUser
25. {
26. get { return strUser; }
27. set { strUser = value; }
28. }
29.
30. public void LoadInfor()
31. {
32. OleDbConnection objConn = new OleDbConnection();
33. OleDbCommand objCmd = new OleDbCommand();
34. OleDbDataAdapter dtAdapter = default(OleDbDataAdapter);
35. DataTable dt = new DataTable();
36. string strConnString = null;
37. string strSQL = null;
38. string directory = Path.GetDirectoryName(Application.ExecutablePath);
39.
40.
41. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + directory + "\\database.mdb;Jet OLEDB:Database Password=;";
42. objConn.ConnectionString = strConnString;
43. objConn.Open();
44.
45. strSQL = "SELECT * FROM member WHERE Username = '" + strUser + "' ";
46.
47. dtAdapter = new OleDbDataAdapter(strSQL, objConn);
48. dtAdapter.Fill(dt);
49.
50. if (dt.Rows.Count > 0)
51. {
52. this.lblUser.Text = strUser;
53. this.lblName.Text = dt.Rows[0]["Name"].ToString();
54. this.lblEmail.Text = dt.Rows[0]["Email"].ToString();
55. }
56.
57. objConn.Close();
58. objConn = null;
59. }
60.
61. private void btnBack_Click(object sender, EventArgs e)
62. {
63. frmLogin frm = new frmLogin();
64. frm.Show();
65. this.Hide();
66. }
67. }
68.}
