[syahman]

how is command for get the specific data such as price in the table in where the condition is the name and insert into the textbox. i want this data for the calculation. anyone can show the example coding will helpful.

[Core]

Basically, you have to start with SQL basics. I see that you are working with VB.NET, here is a tutorial that will guide you through the fundamentals of SQL in C#, but you can easily adapt it to VB.NET.

To accomplish your specific task, you will only have to build a unique SQL query, therefore I would strongly advice you to take a look at several SQL tutorials to get the basic understanding of how it all works.

[ramesh866]

its pretty simple.. use this command obj to retrieve the data.

		SqlCommand cmd = new SqlCommand("select price from product_table where product_name='"+TextBox1.Text+"'",cn);

then use data reader or bind it to grid view for viewing the data