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

Question

hi i need to select two fields in asp.net how to select it

i knw that to select a single field like this

"select name from tablename"

nw i need to select two fields (my code is "select name,date form table where name='"+textbox.text+"' and date='"+textbox2.text+"') is it correct or not.,

please correct it

Senthilkumar · Answer

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(VARCHARdate101) = CONVERT(VARCHARtextboxval101) 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(VARCHARdate101) = CONVERT(VARCHAR+TextBox2.Text+101)