public class Salary { . . . public List<TripAllowanceDT> tripAllowancedt { get; set; } } public class TripAllowanceDT { public int id { get; set; } public string BookingNumber { get; set; } public int NewBookingId { get; set; } public string TripAllowance { get; set; } public DateTime MultidayFromDate { get; set; } public int EmployeeId { get; set; } }
SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString; conn.Open(); SqlCommand sc = new SqlCommand("SP", conn); sc.Parameters.AddWithValue("AllowanceDT", EmployeeSalary.tripAllowancedt); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(sc); sc.CommandType = CommandType.StoredProcedure; da.Fill(dt);
@AllowanceDT TableType_UpdateAllowance ReadOnly
sc.Parameters.AddWithValue("AllowanceDT", EmployeeSalary.tripAllowancedt);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)