TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Santosh Kumar
NA
126
60.3k
How select values from checkbox list in C# asp.net
Oct 20 2014 6:52 AM
Hi,
I Have a search application in which contains the checkbox list of projects and text boxes for each projects with start date and end date, checklist items are binding dynamically from the databse, if there more projects then there are more checkboxes coming, while selecting all check boxes and searching the item(Search Button is there) then there is lots of round trip process is going on(3-Tier Application) which taking lots of time to fill the grid control, Is there any process to send the whole checkbox list's data and text boxe's data into database(Stored procedure) in single roundtrip and fetch records.
Customer List:Customer 1 StartDateTextBox EndatedateTextBox
Customer 2 StartDateTextBox EndatedateTextBox
Customer 3 StartDateTextBox EndatedateTextBox
Customer 4 StartDateTextBox EndatedateTextBox
Customer 5 StartDateTextBox EndatedateTextBox
Customer 6 StartDateTextBox EndatedateTextBox
Customer 7 StartDateTextBox EndatedateTextBox
Button Search
GridVew Result:
Here is the code which I am using currently
if (lbxProjectList.Items[i].Selected.Equals(true))
{
EmployeeBillingService gs = new EmployeeBillingService(this.ContextBO);
List<EmployeeBillingBO> gList = gs.GetEmployeeProjectDetails(Convert.ToInt32(ddlCustomerList.SelectedValue), Convert.ToInt32(lbxProjectList.Items[i].Value), Convert.ToDateTime(Session["DtStartDate"]), Convert.ToDateTime(Session["DtEndDate"]));
|
Reply
Answers (
1
)
SQL Query only returns one item (rather than complete list)
Microsoft report viewer