001.namespace _0
002.{
003. public partial class frmMain : Form
004. {
005. OleDbDataAdapter oda;
006. OleDbCommandBuilder ocb;
007. DataTable dt;
008.
009. public frmMain()
010. {
011. InitializeComponent();
012. }
013.
014. private void button1_Click(object sender, EventArgs e)
015. {
016. OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\Project\\0\\0\\0\\Database.mdb");
017. DataTable dt = new DataTable();
018. OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM tb_Student WHERE Fname = '" + this.txtSearch.Text + "'", conn);
019.
020.
021. oda.Fill(dt);
022.
023. if (dt.Rows.Count > 0)
024. {
025. this.txtName.Text = (string)dt.Rows[0]["Fname"];
026. this.txtLname.Text = (string)dt.Rows[0]["Lname"];
027. }
028.
029. dataGridSearch.DataSource = dt;
030. dataGridSearch.Columns[0].HeaderText = "ID";
031. dataGridSearch.Columns[0].Width = 50;
032. dataGridSearch.Columns[1].HeaderText = "คำนำหน้า";
033. dataGridSearch.Columns[1].Width = 100;
034. dataGridSearch.Columns[2].HeaderText = "ชื่อ";
035. dataGridSearch.Columns[2].Width = 100;
036. dataGridSearch.Columns[3].HeaderText = "นามสกุล";
037. dataGridSearch.Columns[3].Width = 100;
038. dataGridSearch.Columns[4].HeaderText = "ชื่อพฤติกรรม";
039. dataGridSearch.Columns[4].Width = 300;
040. dataGridSearch.Columns[5].HeaderText = "วันที่";
041. dataGridSearch.Columns[5].Width = 100;
042.
043.
044. }
045.
046. private void frmMain_Load(object sender, EventArgs e)
047. {
048. OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\Project\\0\\0\\0\\Database.mdb");
049. oda = new OleDbDataAdapter("SELECT * FROM tb_Student", conn);
050. dt = new DataTable();
051. oda.Fill(dt);
052. dataGridSearch.DataSource = dt;
053. dataGridSearch.Columns[0].HeaderText = "ID";
054. dataGridSearch.Columns[0].Width = 50;
055. dataGridSearch.Columns[1].HeaderText = "คำนำหน้า";
056. dataGridSearch.Columns[1].Width = 100;
057. dataGridSearch.Columns[2].HeaderText = "ชื่อ";
058. dataGridSearch.Columns[2].Width = 100;
059. dataGridSearch.Columns[3].HeaderText = "นามสกุล";
060. dataGridSearch.Columns[3].Width = 100;
061. dataGridSearch.Columns[4].HeaderText = "ชื่อพฤติกรรม";
062. dataGridSearch.Columns[4].Width = 300;
063. dataGridSearch.Columns[5].HeaderText = "วันที่";
064. dataGridSearch.Columns[5].Width = 100;
065. }
066.
067. private void btnUpdate_Click(object sender, EventArgs e)
068. {
069. ocb = new OleDbCommandBuilder(oda);
070. oda.Update(dt);
071. MessageBox.Show("บันทึกการเเก้ไขเรียบร้อยแล้ว", "ผลการทำงาน");
072. }
073.
074. private void button4_Click(object sender, EventArgs e)
075. {
076. if (MessageBox.Show("ต้องการปิดโปรแกรม ?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
077. {
078. Application.Exit();
079. }
080. }
081.
082.
083.
084. private void button3_Click(object sender, EventArgs e)
085. {
086. PrintDialog printDialog = new PrintDialog();
087. printDialog.Document = printDocument1;
088. printDialog.UseEXDialog = true;
089.
090. if (DialogResult.OK == printDialog.ShowDialog())
091. {
092. printDocument1.DocumentName = "Test Page Print";
093. printDocument1.Print();
094. }
095. }
096.
097.
098. private void printDocument1_PrintPage_1(object sender, System.Drawing.Printing.PrintPageEventArgs e)
099. {
100. Bitmap bm = new Bitmap(this.dataGridSearch.Width, this.dataGridSearch.Height);
101. dataGridSearch.DrawToBitmap(bm, new Rectangle(0, 0, this.dataGridSearch.Width, this.dataGridSearch.Height));
102. e.Graphics.DrawImage(bm, 0, 0);
103. }
104.
105. private void btnSeeall_Click(object sender, EventArgs e)
106. {
107. OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\Project\\0\\0\\0\\Database.mdb");
108. oda = new OleDbDataAdapter("SELECT * FROM tb_Student", conn);
109. dt = new DataTable();
110. oda.Fill(dt);
111. dataGridSearch.DataSource = dt;
112. dataGridSearch.Columns[0].HeaderText = "ID";
113. dataGridSearch.Columns[0].Width = 50;
114. dataGridSearch.Columns[1].HeaderText = "คำนำหน้า";
115. dataGridSearch.Columns[1].Width = 100;
116. dataGridSearch.Columns[2].HeaderText = "ชื่อ";
117. dataGridSearch.Columns[2].Width = 100;
118. dataGridSearch.Columns[3].HeaderText = "นามสกุล";
119. dataGridSearch.Columns[3].Width = 100;
120. dataGridSearch.Columns[4].HeaderText = "ชื่อพฤติกรรม";
121. dataGridSearch.Columns[4].Width = 300;
122. dataGridSearch.Columns[5].HeaderText = "วันที่";
123. dataGridSearch.Columns[5].Width = 100;
124. }
125. }
126.}
Quote:
