How to display data in dropdown from Database According betbeen Range

Question

Hi sir. I want to display data from dropdown list According given range.

Suthish Nair · Answer

This is happening because of bad coding habits. I alread said Krishna, its a bad way of coding. Always use Parametrised Queries. REFER

Krishna Garad · Answer

just give the space like SqlDataAdapter da = new SqlDataAdapter("select * from Account Where Rownum Between "+TextBox1.Text+" And "+TextBox2.Text,con);

Suthish Nair · Answer

If this query got resolved then please Accept the post that helped you as Answer . So other members can easily find the answers.

Krishna Garad · Answer

yes you can loop through the records and can send the mail to concern mailid.

manoj kumar · Answer

Thanks sir. 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 Garad · Answer

if you don't mind can elaborate what kind of binding you need.

manoj kumar · Answer

Thanks Sir.. I have another question. Can i bind Textbox

Krishna Garad · Answer

ya with this only we can resist those normal errors. like syntax errors....

Suthish Nair · Answer

Its a development standarad, all developers must follow.

Krishna Garad · Answer

Actually while developing go with some tier model of designing and always follow the stored procedure. But the programmer fills comfort in writing queries what we can do Suthish we have to respond them in their manner only. But next I'll take care .

manoj kumar · Answer

Thanks sir.This is correct query bt give me some error. Incorrect syntax near 'And100'. how it possible.

Krishna Garad · Answer

You can paas this query to DataAdapter object like bello SqlDataAdapter da = new SqlDataAdapter("select * from Account Where Rownum Between"+TextBox1.Text+"And"+TextBox2.Text,con);

manoj kumar · Answer

ok.But it is static.i want give the value run time then display..this is you query for programm.

Krishna Garad · Answer

you may use the query like bellow Select * From TableName Where RowNum between 50 and 100

Krishna Garad · Answer

Ya then you need to modify your select statement.

manoj kumar · Answer

Thanks for qick reply. but this is not my requirment. I want to display data by Given Range to textbox Ex:--1to100 values display in dropdown..

Krishna Garad · Answer

If i'm not wrong you want to display the column data in dropdownlist with textfield as well as valuefield then you can simply use like this DDlEmail.DataSource =ds.Tables[0]; DDlEmail.DataValueField = "AccountName";//will contain value DDlEmail.DataTextField = "AccountName";//will display text DDlEmail.DataBind();

How to display data in dropdown from Database According betbeen Range

Answers (17)