Incorrect syntax near ','.

[don420]

cmd = New SqlClient.SqlCommand("select(pname,MRP,rate,dis) from stock_table where pid = '" & Val(ComboBox1.Text) & "'", con)
adapter.SelectCommand = cmd
adapter.Fill(ds1)
i am getting the error in the last line ..
plzzz help
thanks in advance

 

[Menthos]

Remove the brackets from your Select fields.

cmd = New SqlClient.SqlCommand("select(pname,MRP,rate,dis) from stock_table where pid = '" & Val(ComboBox1.Text) & "'", con)

should be....

cmd = New SqlClient.SqlCommand("select pname,MRP,rate,dis from stock_table where pid = '" & Val(ComboBox1.Text) & "'", con)