public partial class PacientDocForm: Formvoid textBox1_TextChanged (object sender, EventArgs e)
{if (textBox1.Text! = "")
{this.pacientBindingSource.Filter = "fam_p = '" + textBox1.Text + "' or name_p = '" + textBox1.Text + "'";
}
{this.pacientBindingSource.Filter = "";
}. pacientDataGridView.Refresh ();
} void pacientDataGridView_RowEnter (object sender, DataGridViewCellEventArgs e)
{string text = "Server = (local); Initial Catalog = Bolnica; Trusted_connection = Yes"; conn = new SqlConnection (text); ((this.pacientDataGridView.SelectedRows.Count> 0 ))
{string sql_text = "SELECT id_pr AS ID, data_pr AS [Дата прийому], time_pr AS [Час прийому], special AS Спеціальність, fam_d AS Лікар FROM Priem INNER JOIN Doctor ON Priem.id_d = Doctor.id_d WHERE Priem.id_p = "+ pacientDataGridView.SelectedRows [0]. Cells [0]. Value.ToString (); da = new SqlDataAdapter (sql_text, conn); dt = new DataTable ();. Fill (dt );. DataSource = dt.DefaultView;. AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;. SelectionMode = DataGridViewSelectionMode.FullRowSelect;. MultiSelect = false;
}
В
Рисунок 17 - Форма В«Історія хворобиВ»
Опис форми В«Історія хворобиВ»:
public partial class IstBolForm: Form
{int id; myConnection; IstBolForm (int priemid)
{InitializeComponent (); = priemid; = new SqlConnection (
"Server = Надечка-ПК;" +
"Connection Timeout = 30;" +
"Database = Bolnica;" +
"Trusted_Connection = true");
{myConnection.Open ();
} (Exception c)
{MessageBox.Show (c.ToString ());
}
{SqlDataReader myReader = null; myCommand = new SqlCommand ("SELECT * FROM dbo.Pacient INNER JOIN dbo.Priem ON Priem.id_p = Pacient.id_p WHERE Priem.id_pr = '" + id . ToString () + "'", myConnection); = myCommand.ExecuteReader (); (myReader.Read ())
{diagnozTextBox.Text = myReader ["diagnoz"]. ToString (); _lechTextBox.Text = myReader ["info_lech"]. ToString ();. Text = myReader ["name_p" ]. ToString ();. Text = myReader ["fam_p"]. ToString ();
}. Close ();
} (Exception d) {} ​​
} void priemBindingNavigatorSaveItem_Click (object sender, EventArgs e)
{
} void button1_Click (object sender, EventArgs e)
{try
{SqlCommand myCommand = new SqlCommand ("UPDATE dbo.Priem diagnoz = '" + diagnozTextBox.Text...
