How to display data in dropdown from Database According betbeen Range
Hi sir. I want to display data from dropdown list According given range.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Suthish NairPosted Feb 4, 2011, 2:44 PM
So other members can easily find the answers.
Krishna GaradPosted Feb 3, 2011, 7:23 AM
manoj kumarPosted Feb 3, 2011, 6:12 AM
I want make a Emailer. I want to select id from database for send.
select id from database according my range .then send mail all id..how it possible.
Krishna GaradPosted Feb 3, 2011, 5:30 AM
manoj kumarPosted Feb 3, 2011, 5:26 AM
I have another question. Can i bind Textbox
Krishna GaradPosted Feb 3, 2011, 5:25 AM
Suthish NairPosted Feb 3, 2011, 5:22 AM
Krishna GaradPosted Feb 3, 2011, 5:12 AM
Suthish NairPosted Feb 3, 2011, 5:04 AM
I alread said Krishna, its a bad way of coding. Always use Parametrised Queries.
REFER
Krishna GaradPosted Feb 3, 2011, 4:52 AM
SqlDataAdapter da = new SqlDataAdapter("select * from Account Where Rownum Between "+TextBox1.Text+" And "+TextBox2.Text,con);
manoj kumarPosted Feb 3, 2011, 4:47 AM
Incorrect syntax near 'And100'.
how it possible.
Krishna GaradPosted Feb 3, 2011, 2:35 AM
SqlDataAdapter da = new SqlDataAdapter("select * from Account Where Rownum Between"+TextBox1.Text+"And"+TextBox2.Text,con);
manoj kumarPosted Feb 3, 2011, 2:32 AM
Krishna GaradPosted Feb 3, 2011, 2:18 AM
Select * From TableName Where RowNum between 50 and 100Krishna GaradPosted Feb 3, 2011, 2:12 AM
manoj kumarPosted Feb 3, 2011, 2:06 AM
but this is not my requirment. I want to display data by Given Range to textbox
Ex:--1to100 values display in dropdown..
Krishna GaradPosted Feb 3, 2011, 2:01 AM
DDlEmail.DataSource =ds.Tables[0];
DDlEmail.DataValueField = "AccountName";//will contain value
DDlEmail.DataTextField = "AccountName";//will display text
DDlEmail.DataBind();