private void Frm_slobodneSobe_Load(object sender, EventArgs e)
{
DS_Studentikus.SobasDataTable dtSoba = new DS_Studentikus.SobasDataTable();
DAStudentikus.getSlobodneSobe(dtSoba);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dtSoba;
}
public static void getSlobodneSobe(DS_Studentikus.SobasDataTable dtSobe)
{
SqlConnection cm = Connection.GetConnection();
if (cm.State == ConnectionState.Closed)
{
cm.Open();
}
try
{
SqlCommand cmd = new SqlCommand("si001_student.procedura1", cm);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtSobe);
}
finally
{
}
}
