What is the code to retrieve data from sql in Net?

Answer 1

at the top

using System.Data.SqlClient;

in the main body (perhaps a click event)

//creates a connection object with a given connection string

SqlDataConnection conn = New SqlDataConnection("connection String");

//creates a command object with the sql and the connection it is to use

SqlCommand cmd = new SqlCommand("SQL String",conn);

//create a data reader to store the data retrieved from the database

SqlDataReader rdr;

//open the connection

conn.Open();

//executes the sql and stores the result in the rdr (Use if there is more than one //cell retrieved from database e.g all records where a value is greater than 0

rdr = cmd.ExecuteReader();

//if there is only one cell retrieved such as only the orderid for a specific order then //use:

variable = cmd.ExecuteScalar();

//then do something with the data WARNING: the connection MUST be open to use the data reader but not with the scalar method

//close the connection

conn.Close();

Hope this helps!

steve