How to bind dropdownlist when textbox selected index changed?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

I have one textbow with one dropdownlist as shown below,

ASP.NET

<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<table>
<tr>
<td>
<asp:TextBox ID="fromTxt" runat="server" AutoPostBack="true" 
        ontextchanged="fromTxt_TextChanged"></asp:TextBox>
        <asp:CalendarExtender ID="calExt1" runat="server" Format="dd/MM/yyyy" TargetControlID="fromTxt" PopupButtonID="fromTxt"></asp:CalendarExtender>
</td>
<td>
<asp:DropDownList ID="ddTodate" runat="server"></asp:DropDownList>
</td>
</tr>
</table>

I want to bind next 30 days date in dropdownlist(ddTodate) from textbox(fromtxt) textchanged event.

C#

protected void fromTxt_TextChanged(object sender, EventArgs e)
{
//I have to bind Dropdownlist with next 30 days date from the date selected in textbox.
}

for example,if i select date like (15/11/2014) in textbow(fromtxt) then the dropdownlist should bind like this,
16/11/2014
17/11/2014
18/11/2014
....
....
....
....
....
....
....
15/12/2014

Thanks in Advance,
R@JE$#

Posted 15-Nov-14 1:00am

Rajesh waran

Updated 15-Nov-14 1:35am

v4

Add a Solution

3 solutions

Solution 1

I think best option is load the data on Date Selection Changed event of calander control, but you can't directly handle it by server side, check this solutionhttp://forums.asp.net/post/4119866.aspx[^]
it will postback using javascript and you can load the dropdownlist data on button click event based on calendar selected date.

C#

DateTime fromDate = // selected calendar date..
List<string> dates = new List<string>();
for(int i=0; i< 15;i++)
{
    fromDate = fromDate.AddDays(1);
    dates.Add(fromDate.ToString("dd/MM/yyyy"));
}

set abow date list as datasource of your dropdown list

Posted 15-Nov-14 1:19am

DamithSL

Updated 15-Nov-14 1:37am

v2

Comments

Rajesh waran 15-Nov-14 7:37am

sorry sir, i forgot to tag sql-server-R2-2008.Now i have updated my question.
and thank you for the link that you have provided here.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

King Fisher · Accepted Answer · 2014-11-15T01:20:00

Solution 2

Hi R@jes#,
Better you can use CTE in Sql
Here is the Query and Modify it ,

SQL

DECLARE @Date Datetime = getdate()
Declare @endDate Datetime=Dateadd(month,1,@date);
;WITH CTE AS
(
    SELECT @Date as dates UNION ALL
    SELECT DATEADD(day,1,dates) FROM CTE where dates<@endDate
)
SELECT dates AS Date FROM CTE

Edited:

SQL

DECLARE @Date Datetime = getdate()
Declare @endDate Datetime=Dateadd(month,1,@date);
;WITH CTE AS
(
    SELECT @Date as dates,1 as no UNION ALL
    SELECT DATEADD(day,1,dates),no+1 FROM CTE where dates<@endDate
)
SELECT dates AS Date ,no FROM CTE

You can Bind The Query Result to your Dropdown List

Posted 15-Nov-14 1:20am

King Fisher

Updated 15-Nov-14 1:24am

v4

Comments

DamithSL 15-Nov-14 7:22am

I don't see any database related issue ask by OP.

King Fisher 15-Nov-14 7:23am

Sorry ,I just Suggest to do in Sql

DamithSL 15-Nov-14 7:26am

you mean taking next n days and binding to drop down functionality by using database? I think it is overkill, simple for loop or linq query can be used without going to db level

King Fisher 15-Nov-14 7:38am

i think ,instead of using For Loop we can use a simple Query for this,In case OP need to show Date for 3 months or more then what to do ? :)

DamithSL 15-Nov-14 7:45am

Query may be simple but it is adding another dependency just for generate list of dates. there is nothing you take from database, it is only do the date generation using SQL, you think C# is weak or inefficient for such task?

King Fisher 15-Nov-14 7:55am

Cool Damith.i don't mean that. :)

Rajesh waran 15-Nov-14 7:43am

Hi @King_fisher it's fine.but your solution shows output like this,
2014-11-15 18:05:07.143 1
2014-11-16 18:05:07.143 2
2014-11-17 18:05:07.143 3
2014-11-18 18:05:07.143 4
2014-11-19 18:05:07.143 5
2014-11-20 18:05:07.143 6
2014-11-21 18:05:07.143 7
2014-11-22 18:05:07.143 8
2014-11-23 18:05:07.143 9
2014-11-24 18:05:07.143 10
2014-11-25 18:05:07.143 11
2014-11-26 18:05:07.143 12
2014-11-27 18:05:07.143 13
2014-11-28 18:05:07.143 14
2014-11-29 18:05:07.143 15
2014-11-30 18:05:07.143 16
2014-12-01 18:05:07.143 17
2014-12-02 18:05:07.143 18
2014-12-03 18:05:07.143 19
2014-12-04 18:05:07.143 20
2014-12-05 18:05:07.143 21
2014-12-06 18:05:07.143 22
2014-12-07 18:05:07.143 23
2014-12-08 18:05:07.143 24
2014-12-09 18:05:07.143 25
2014-12-10 18:05:07.143 26
2014-12-11 18:05:07.143 27
2014-12-12 18:05:07.143 28
2014-12-13 18:05:07.143 29
2014-12-14 18:05:07.143 30
2014-12-15 18:05:07.143 31

but what i want is, dropdownlist should show next 30 days date from the date selected which means if i select 15/11/2014,then dropdown should start from 16/11/2014 and end with 15/12/2014 like this order,

2014-11-16 18:05:07.143
2014-11-17 18:05:07.143
2014-11-18 18:05:07.143
2014-11-19 18:05:07.143
2014-11-20 18:05:07.143
2014-11-21 18:05:07.143
2014-11-22 18:05:07.143
2014-11-23 18:05:07.143
2014-11-24 18:05:07.143
2014-11-25 18:05:07.143
2014-11-26 18:05:07.143
2014-11-27 18:05:07.143
2014-11-28 18:05:07.143
2014-11-29 18:05:07.143
2014-11-30 18:05:07.143
2014-12-01 18:05:07.143
2014-12-02 18:05:07.143
2014-12-03 18:05:07.143
2014-12-04 18:05:07.143
2014-12-05 18:05:07.143
2014-12-06 18:05:07.143
2014-12-07 18:05:07.143
2014-12-08 18:05:07.143
2014-12-09 18:05:07.143
2014-12-10 18:05:07.143
2014-12-11 18:05:07.143
2014-12-12 18:05:07.143
2014-12-13 18:05:07.143
2014-12-14 18:05:07.143
2014-12-15 18:05:07.143

King Fisher 15-Nov-14 7:49am

Then Just Change into this:
DECLARE @Date Datetime = Dateadd(DAY,1,getdate());
Declare @endDate Datetime=Dateadd(month,1,getdate());

Rajesh waran 15-Nov-14 7:54am

Great! working good.This what i need.
using sql server it's fine,but i have one doubt,if i want to show next 45 days date what can i do?

King Fisher 15-Nov-14 8:00am

so you won't try anything :)
if (you want to Add Date like 30,45,60,90)
{
Declare @endDate Datetime=Dateadd(Day,45,getdate());
}
else if(you want to Add Monht like 1,2,3,10))
{
Declare @endDate Datetime=Dateadd(Month,1,getdate());

}
else //year
{
Declare @endDate Datetime=Dateadd(Year,1,getdate());
}
:)

Rajesh waran 15-Nov-14 8:07am

Thank you.Got solution.My +5

King Fisher 15-Nov-14 8:10am

Welcome :)

aarif moh shaikh · Accepted Answer · 2014-11-15T01:58:00

Solution 3

Try This ... You Will Get Your Solution..

C#

DateTime fromDate = [Your calender Date (TextBox date)];

   for(int i=0; i< 30;i++)
   {
       fromDate = fromDate.AddDays(1);
           ddTodate.Items.Insert(i,fromDate.ToString("dd/MM/yyyy"));

   }

Thanks
AARIF SHAIKH

Posted 15-Nov-14 1:58am

aarif moh shaikh

Comments

Rajesh waran 15-Nov-14 8:08am

Thank you. Good one got solution.

aarif moh shaikh 18-Nov-14 5:29am

Thanks... Rajesh

Rajesh waran 18-Nov-14 5:38am

you're Welcome.