private void Frm_Kvarovi_Load(object sender, EventArgs e)
{
//get all Kvarovi
Kvarovi.KvarsDataTable dtKvarovi = new Kvarovi.KvarsDataTable();
DAKvarovi.GetKvarovi(dtKvarovi);
dataGridKvarovi.DataSource = dtKvarovi;
}
public static void GetKvarovi(Kvarovi.KvarsDataTable dtKvarovi)
{
//open connection
SqlConnection cn = Connection.GetConnection();
if (cn.State == System.Data.ConnectionState.Closed)
{
cn.Open();
}
try
{
SqlCommand cmd = new SqlCommand("usp_Kvarovi", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtKvarovi);
}
finally
{
}
}