how to send parameters in sql statement using data adapter.

[Sophia Rekhi]

Hi all, how to send parameters in sql statement using data adapter. Ex: select * from emp where eno=2 here eno=2 is given dynamically through textbox in a webform.how can insert parameter values to that sql statement.

[Kunal P]

select * from emp where eno= '"+Textbox1.Text+"

Kunal

[Mazdak]

Look for SqlParameter and SqlCommand .

Mazy
"This chancy chancy chancy world."

[Sophia Rekhi]

Thanks kunal,it is working have a nice day