C# Select Statement Source Code Example

Posted by on Sunday, December 6, 2009 · Leave a Comment 

C# Select Statement Source Code Example

Purpose: – Illustrates using Sql Select in C# to write Output Table.
Prerequistes:

  1. Install C# (Express or Standard Edition)
  2. Install SQL Server Express
  3. Download Northwind Database
  4. Attach Northwind Database to Databases in Sql Express

Notes:

  • Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
  • You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Program.cs

Instructions:

  1. Use Visual Studio 2022
  2. Create new project; select Console Application; name of Project could be CSharp_Syntax.
  3. Right-click project name in solution explorer; add new folder; name of folder could be DatabaseADONET
  4. Right-click folder; add class; class name could be clsSqlSelect.cs
  5. Copy code into clsSqlSelect.cs
  6. Copy code into Program.cs
  7. Click green arrow to start with debugging

Step 1: Use View Plain to Cut-n-paste code into clsSqlSelect.cs

using System;
using System.Data;
using System.Data.SqlClient;
public class clsSqlSelect
{
static SqlConnection con;
 
 
public void Main()
{
con = new SqlConnection("Server=(local)\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI");
 
// Create the command object
string str = "SELECT EmployeeID, FirstName, LastName FROM Employees";
SqlCommand cmd = new SqlCommand(str, con);
 
SqlDataAdapter da = new SqlDataAdapter(cmd);
 
DataSet ds = new DataSet();
 
da.Fill(ds, "Employees");
 
//DataColumn dc;
foreach ( DataColumn dc in ds.Tables[0].Columns) {
Console.Write("{0,15}", dc.ColumnName);
}
 
Console.Write("\n");
 
		//DataRow dr;
foreach ( DataRow dr in ds.Tables[0].Rows) {
int i;
for (i = 1; i < = ds.Tables[0].Columns.Count; i++) {
Console.Write("{0,15}", dr[i - 1]);
}
Console.Write("\n");
}
Console.ReadLine();
}
 
}

Step 2: Use View Plain to Cut-n-paste code into Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
 
namespace CSharp_Syntax
{
class Program
{
static void Main(string[] args)
{
//DatabaseADONET
 
clsSqlSelect mySqlSelect = new clsSqlSelect();
mySqlSelect.Main();
 
}
}
}

Filed under Code Samples · Tagged with , , ,