C# SQL - Whats the most efficient way to obtain one result?

Question

As title really. I want to object just one specific value from a colum on one row of a SQL database. The PHP code I would use would be: $result = mysql_query("SELECT price FROM delivery WHERE id='$id'"); echo mysql_result($result,0); That would get me the price from what ever autoinc id I choose. As I'm new to C# its quite tricky to get my head around as there seems to be many different methods to obtain the same results. Any help would be appreciated, thanks! EDIT I'm using System.Data.SqlClient as, so far, its done me proud. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

If data type of PRICE column you want to retrieve is a scalar value and you'll get only one record then I assume the most efficient way would be ExecuteScalar() method. Here's a little sample code: string conString="Data Source=local;Initial Catalog=...." SQLConnection con=new SQLConnection(conString); SQLCommand cmd=new SQLCOmmand("SELECT price FROM delivery WHERE =@ID",con) cmd.Parameters.Add("@ID", SqlDbType.Int).Value=125//Off course it just a sample value con.Open(); float price=(decimal)cmd.ExecuteScalar(); ...... con.Close();//don't forget