I need to select two fields in asp.net how to select it

Hi Selvi,

There are some spelling errors in your query.

Usually if you want to check the numeric field then you need to like this.

SELECT name, date FROM table_name WHERE id=5 //no need to use single quote.

For varchar, text.. other than numeric field

SELECT name, date FROM table_name WHERE name='test' // need to use single quote.

Lets come to your actual query.

SELECT name, date FROM table_name WHERE name='ss' AND CONVERT(VARCHAR,date,101) = CONVERT(VARCHAR,textboxval,101)

Because it always problem with date time comparision.

You may have different input of date time in the textbox, which may not match with table value.

I mean somebody used to get the datetime format in dd/mm/yyyy or mm/dd/yy like that.

SELECT name, date FROM table_name WHERE name='"+TextBox1.Text+"' AND CONVERT(VARCHAR,date,101) = CONVERT(VARCHAR,"+TextBox2.Text+",101)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.