The main objective of Windows-based programming is to create applications that are linked to databases, have user-friendly interfaces (Windows forms), and are capable of running on most platforms.The C# language having this capability by creating winforms to connecting data sources using ADO.NET technology.
ADO.NET is the .NET technology for interacting with data sources.By using System.Data.SqlClient Namespace the .NET framework connect to database and perform queries on that and get the data from data source.
The below sample C# windows form application is explains how the application is connecting to SQL server data source and display table data in grid of application.
Execution Process:
First enter Credentials in those required text boxes for Connect to the SQL Server, then click on Connect button. If the credentials are valid the application is connect to SQL server and bind all table list to combo box, after selecting table as item in that combo box the data will display in grid control as a table.
Source Code:
}
privatevoid Form1_Load(objectsender, EventArgs e)
using System;
usingSystem.Collections.Generic;
using System.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespaceConnectToSQLusingCsharpApp
{
public partial class Form1 : Form
{
stringserver = "";
stringdbName = "";
stringuName = "";
stringpsw = "";
stringstrConAddr = "";
SqlConnectionsqlCon; //For Connecting to sql
SqlCommandsqlCmd;// For passing Command to sql
SqlDataReadersqlDrd;// For storing Output Data from sql command
DataTabledt;
publicForm1()
{
InitializeComponent();
}
privatevoid btnConnect_Click(objectsender, EventArgs e)
{
btnConnect.Enabled = false;
cmbTable.Items.Clear();
server = txtServer.Text;
dbName = txtDb.Text;
uName = txtUname.Text;
psw = txtPsw.Text;
try
{
strConAddr = "SERVER = " + server + "; Initial Catalog = " + dbName + "; UID = " + uName + "; PWD = " + psw + "";
sqlCon = new SqlConnection(strConAddr);
sqlCon.Open();
sqlCmd = new SqlCommand("SELECT name FROM sys.Tables", sqlCon);
sqlDrd =sqlCmd.ExecuteReader();
while(sqlDrd.Read())
{
cmbTable.Items.Add(sqlDrd["name"].ToString());
}
if(sqlCon.State == ConnectionState.Open)
sqlCon.Close();
sqlDrd.Dispose();
btnConnect.Text = "Connected";
}
catch(Exception ea)
{
MessageBox.Show("Error: "+ea.Message.ToString());
server = "";
dbName = "";
uName = "";
psw = "";
}
btnConnect.Enabled = true;
cmbTable.Focus();
privatevoid cmbTable_SelectedIndexChanged(object sender, EventArgse)
{
try
{
sqlCon = new SqlConnection(strConAddr);
if(sqlCon.State == ConnectionState.Closed)
sqlCon.Open();
sqlCmd = new SqlCommand("SELECT * FROM [" +cmbTable.SelectedItem.ToString() + "]",sqlCon);
sqlDrd =sqlCmd.ExecuteReader();
dt = newDataTable();
dt.Load(sqlDrd);
dGrdTbl.DataSource = dt;
if(sqlCon.State == ConnectionState.Open)
sqlCon.Close();
sqlDrd.Dispose();
dt.Dispose();
}
catch(Exception etbl)
{
MessageBox.Show("Error: " + etbl.Message.ToString());
}
}
{
btnConnect.Text = "Connect";
}
}
}
For downloading entire visual studio solution file for thisApplication CLICK HERE
