//Image mainBackGroundImage; public frmMainForm() { byte i =0; PrivateDataEncode pde = new PrivateDataEncode(); myConn = new OleDbConnection(); myCom = new OleDbCommand(); myCom.CommandText="Select M_ID, M_Name, M_Type, M_Description From tblMasterInfor ORDER BY M_Type"; myCom.Connection = myConn; myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;Jet OLEDB:Database Password=whatthehellisgoingon"; try{ myConn.Open(); }catch(Exception e) { MessageBox.Show(ERROR_WHILE_LOADING_DATABASE + e.Message.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Dispose(); Application.Exit(); } myReader = myCom.ExecuteReader(); System.ComponentModel.ComponentResourceManager resources1 = new System.ComponentModel.ComponentResourceManager(typeof(frmMainForm)); InitializeComponent(); if (myReader.HasRows) { while (myReader.Read()) { this.tbTmp4LoadDynamic = new System.Windows.Forms.ToolStripButton(); this.tbTmp4LoadDynamic.Overflow = ToolStripItemOverflow.Never; if (myReader.GetByte(2) ==frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_DIAGNOSIS) { try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\diagnosis.bmp"); }catch(System.IO.FileNotFoundException){} }else if (myReader.GetByte(2) ==frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_TREATMENT) {//treatment try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\treatment.bmp");//career.bmp }catch(System.IO.FileNotFoundException){} }else { try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\career.bmp"); }catch(System.IO.FileNotFoundException){} } //this.tbTmp4LoadDynamic.Image = ((System.Drawing.Image)(resources.GetObject("mnuBtnPatientRecord.Image"))); this.tbTmp4LoadDynamic.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft; this.tbTmp4LoadDynamic.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta; this.tbTmp4LoadDynamic.Name = "tb" +myReader.GetValue(0).ToString(); this.tbTmp4LoadDynamic.Size = new System.Drawing.Size(90, 40); this.tbTmp4LoadDynamic.TextAlign = System.Drawing.ContentAlignment.MiddleRight; this.tbTmp4LoadDynamic.Click += new System.EventHandler(this.DynamicToolBarClick); this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta; this.tbTmp4LoadDynamic.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.ImageAndText; this.tbTmp4LoadDynamic.Text = myReader.GetString(1); this.tbTmp4LoadDynamic.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageBeforeText; this.tbTmp4LoadDynamic.DoubleClick += new EventHandler(DynamicToolBarClick); sepTmp = new ToolStripSeparator(); sepTmp.Name = "auto" + i++.ToString(); sepTmp.Size = new System.Drawing.Size(6, 1); this.tbMainToolBar.Items.AddRange(new System.Windows.Forms.ToolStripItem[]{sepTmp, tbTmp4LoadDynamic}); }// myReader.Read() }//myReader.HasRows myReader.Close(); this.frmMainForm_SizeChanged(null, null); }
//Image mainBackGroundImage; public frmMainForm() { byte i = 0; PrivateDataEncode pde = new PrivateDataEncode(); myConn = new OleDbConnection(); myCom = new OleDbCommand(); myCom.CommandText = "Select M_ID, M_Name, M_Type, M_Description From tblMasterInfor ORDER BY M_Type"; myCom.Connection = myConn; myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;Jet OLEDB:Database Password=whatthehellisgoingon"; try{ myConn.Open(); }catch (Exception e) { MessageBox.Show(ERROR_WHILE_LOADING_DATABASE + e.Message.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Dispose(); Application.Exit(); } myReader = myCom.ExecuteReader(); System.ComponentModel.ComponentResourceManager resources1 = new System.ComponentModel.ComponentResourceManager(typeof(frmMainForm)); InitializeComponent(); if (myReader.HasRows) { while (myReader.Read()) { this.tbTmp4LoadDynamic = new System.Windows.Forms.ToolStripButton(); this.tbTmp4LoadDynamic.Overflow = ToolStripItemOverflow.Never; if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_DIAGNOSIS) { try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\diagnosis.bmp"); }catch (System.IO.FileNotFoundException) {} } else if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_TREATMENT) { //treatment try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\treatment.bmp"); //career.bmp }catch (System.IO.FileNotFoundException) {} } else { try{ this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\career.bmp"); }catch (System.IO.FileNotFoundException) {} } //this.tbTmp4LoadDynamic.Image = ((System.Drawing.Image)(resources.GetObject("mnuBtnPatientRecord.Image"))); this.tbTmp4LoadDynamic.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft; this.tbTmp4LoadDynamic.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None; this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta; this.tbTmp4LoadDynamic.Name = "tb" + myReader.GetValue(0).ToString(); this.tbTmp4LoadDynamic.Size = new System.Drawing.Size(90, 40); this.tbTmp4LoadDynamic.TextAlign = System.Drawing.ContentAlignment.MiddleRight; this.tbTmp4LoadDynamic.Click += new System.EventHandler(this.DynamicToolBarClick); this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta; this.tbTmp4LoadDynamic.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.ImageAndText; this.tbTmp4LoadDynamic.Text = myReader.GetString(1); this.tbTmp4LoadDynamic.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageBeforeText; this.tbTmp4LoadDynamic.DoubleClick += new EventHandler(DynamicToolBarClick); sepTmp = new ToolStripSeparator(); sepTmp.Name = "auto" + i++.ToString(); sepTmp.Size = new System.Drawing.Size(6, 1); this.tbMainToolBar.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { sepTmp, tbTmp4LoadDynamic }); } // myReader.Read() } //myReader.HasRows myReader.Close(); this.frmMainForm_SizeChanged(null, null); }
public void LoadPatient(string patientID) { string strSQL;OleDbCommand myCom; OleDbDataReader myReader; int i, n, c; this.isEditPatient =true; strSQL = "SELECT Patient_Name, Patient_Address, Patient_Age, Patient_Gender, Patient_Tel, Patient_Career FROM tblPatient WHERE Patient_ID=" + patientID + ";"; myCom = refConn.CreateCommand(); myCom.CommandText = strSQL; myReader = myCom.ExecuteReader(); if (myReader.HasRows) { myReader.Read(); strPatientID = patientID; txtPatientName.Text = myReader.GetString(0); txtPatientAddress.Text = myReader.IsDBNull(1)?"":myReader.GetString(1); txtPatientAge.Text = myReader.GetByte(2).ToString(); cboPatientGender.SelectedIndex = myReader.GetByte(3); txtPatientPhone.Text = myReader.IsDBNull(4)?"":myReader.GetString(4); if (!myReader.IsDBNull(5)) { n = lstCareerID.Items.Count-1; c = myReader.GetInt32(5); for(i=0; i<n; i++) { if (int.Parse(lstCareerID.Items[i].ToString())==c) { cboPatientCareer.SelectedIndex =i; break; } } }else cboPatientCareer.SelectedIndex =-1; strPatientID = patientID; } }