Basic stuff, search. Here's a simple example tho...
string commandText = "SELECT column1, column2 FROM MyTable Where Column1 IS NOT NULL"
var results = new DataSet();
var connectionString = ConfigurationManager
.ConnectionStrings["MyConnectionStringName"].ConnectionString;
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
using (var command = new SqlCommand(commandText, connection))
{
var adapter = new SqlDataAdapter(command);
adapter.Fill(results);
}
}
if (results.Tables.Count > 0)
{
var firstTable = results.Tables[0];
foreach(var row in firstTable.Rows)
{
}
}