public static void getUplate(DS_Uplate.view_UplateDataTable dt_Uplate) { dt_Uplate.Clear(); using (SqlConnection cn = Connection.GetOpenConnection()) { DS_UplateTableAdapters.view_UplateTableAdapter adapter = new DS_UplateTableAdapters.view_UplateTableAdapter(); adapter.Fill(dt_Uplate); } }
public frm_reportUplate(DS_Uplate.view_UplateDataTable dt_uplate, string fName, string lName, string from, string to, string kurs) { this.dt_uplate = dt_uplate; this.fName = fName; this.lName = lName; this.from = from; this.to = to; this.kurs = kurs; InitializeComponent(); }
public static void getUplate_by_NameAndDate(DS_Uplate.view_UplateDataTable dt_Uplate, string fName, string lName, DateTime from, DateTime to) { dt_Uplate.Clear(); using (SqlConnection cn = Connection.GetOpenConnection()) { SqlCommand com = new SqlCommand("usp_Uplate_by_NameAndDate", cn); com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = fName; com.Parameters.Add("@LastName", SqlDbType.NVarChar).Value = lName; com.Parameters.Add("@DateFrom", SqlDbType.DateTime).Value = from; com.Parameters.Add("@DateTo", SqlDbType.DateTime).Value = to; SqlDataAdapter adapter = new SqlDataAdapter(com); adapter.Fill(dt_Uplate); } }
private void btn_newCustomList_Click(object sender, EventArgs e) { customList = new DS_Uplate.view_UplateDataTable(); gB_customList.Visible = true; }