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 { } }