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