private void frm_ListofKorisnici_Load(object sender, EventArgs e)
{
DS_Studentikus.KorisniksDataTable dtKorisnici = new DS_Studentikus.KorisniksDataTable();
DAGetAllKorisnici.GetAllKorisnici(dtKorisnici);
dgKorisnicii.AutoGenerateColumns = false;
dgKorisnicii.DataSource = dtKorisnici;
}
public static void GetTrenutniKorisnici(DS_Studentikus.KorisniksDataTable dtKorisnici)
{
SqlConnection cn = Connection.GetConnection();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
try
{
SqlCommand cmd = new SqlCommand("si001_student.usp_TrenutniGosti", cn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtKorisnici);
}
finally { }
}
