public ProfilePsychoForm(ChildDBConnect newDbCon, int idSpec, string typeDoc, DataRow selRow) { InitializeComponent(); this.selRow = selRow; pd = new PsychoData(); this.IsNew = false; this.dbCon = newDbCon; this.idSpec = idSpec; this.typeDoc = typeDoc; tbName.Text = selRow["name"].ToString(); // mtbDateDoc.Text = selRow["date_doc"].ToString(); dtDateDoc.Text = selRow["date_doc"].ToString(); if (selRow["psycho_doc"] == null) { bnOpen.Enabled = false; } else if (!Convert.IsDBNull(selRow["psycho_doc"])) { bufferDoc = (Byte[])selRow["psycho_doc"]; //System.DBNull } else { bnOpen.Enabled = false; } }
public ProfilePsychoForm(ChildDBConnect newDbCon, int idSpec, string typeDoc) { InitializeComponent(); pd = new PsychoData(); this.IsNew = true; this.dbCon = newDbCon; this.idSpec = idSpec; this.typeDoc = typeDoc; bnOpen.Enabled = false; }
private void LoadPsycho() { // dbCon = new ChildDBConnect(idSpec, "spec_psycho"); dbCon = new ChildDBConnect(idSpec, "spec_psycho", typeDoc); dgPsycho.Columns.Add(new DataGridViewTextBoxColumn()); dgPsycho.Columns[0].DataPropertyName = "id"; dgPsycho.Columns[0].HeaderText = "код"; dgPsycho.Columns[0].Visible = false; dgPsycho.Columns.Add(new DataGridViewTextBoxColumn()); dgPsycho.Columns[1].DataPropertyName = "id_spec"; dgPsycho.Columns[1].HeaderText = "код"; dgPsycho.Columns[1].Visible = false; CalendarColumn col = new CalendarColumn(); { col.DataPropertyName = "date_doc"; col.HeaderText = "Дата документа"; col.Width = 90; col.MinimumWidth = 90; col.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; } dgPsycho.Columns.Add(col); DataGridViewTextBoxColumn textColumn = new DataGridViewTextBoxColumn(); { textColumn.DataPropertyName = "name"; textColumn.HeaderText = "Наименование документа"; textColumn.Width = 200; textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } dgPsycho.Columns.Add(textColumn); dgPsycho.DataSource = new DataView(dbCon.GetDataTable("spec_psycho")); }