public static void getRadniciByNLU(DSRadinici.RadniksDataTable dtRadnici, string Imetxt, string Prezimetxt, string Usernametxt) { dtRadnici.Clear(); SqlConnection cn = Connection.GetConnection(); if (cn.State == ConnectionState.Closed) { cn.Open(); } try { SqlCommand cmd = new SqlCommand("usp_GetRadnikByNLU", cn); cmd.CommandType = CommandType.StoredProcedure; if (Imetxt != "") { cmd.Parameters.Add("@Ime", SqlDbType.NVarChar).Value = Imetxt; } if (Prezimetxt != "") { cmd.Parameters.Add("@Prezime", SqlDbType.NVarChar).Value = Prezimetxt; } if (Usernametxt != "") { cmd.Parameters.Add("@Username", SqlDbType.NVarChar).Value = Usernametxt; } SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dtRadnici); } finally { cn.Close(); } }
public static void getRadnici(DSRadinici.RadniksDataTable dtRadnici) { dtRadnici.Clear(); SqlConnection cn = Connection.GetConnection(); if (cn.State == ConnectionState.Closed) { cn.Open(); } try { SqlCommand cmd = new SqlCommand("usp_Select_Radniks", cn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dtRadnici); } finally { cn.Close(); } }