Scribd
Upload
262 views18 pages

WinForm App with Database Example

This document provides steps to create a Windows Forms application in C# that connects to a SQL Server database and retrieves data to display in a DataGridView. It involves creating database tables, adding a WinForms project and classes to connect to the database and retrieve data, displaying the data on a form, and storing the connection string in an App.config file. The application demonstrates using ADO.NET to connect to a database and populate a UI element with retrieved data.

Uploaded by

miroljub
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
262 views18 pages

WinForm App with Database Example

This document provides steps to create a Windows Forms application in C# that connects to a SQL Server database and retrieves data to display in a DataGridView. It involves creating database tables, adding a WinForms project and classes to connect to the database and retrieve data, displaying the data on a form, and storing the connection string in an App.config file. The application demonstrates using ADO.NET to connect to a database and populate a UI element with retrieved data.

Uploaded by

miroljub
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 18

WinForm/C#

Database App
using ADO.NET

Hans-Pe7er Halvorsen, M.Sc.


Database Tables

2
Execute the dierent
Scripts inside SQL Server
Management Studio

3
This Example shows how to create a WinForm
App that gets Data from a Database into a
DataGridView

4
Add a WinForm Project

5
Add a New Class to the
Project (StudentData.cs)

StudentData.cs 6
Create the Code, e.g., like this (StudentData.cs):

SQL Query A View that collects data


from several tables

Improvements: Use Try... Catch ...

7
Add a New Class (StudentWinForm.cs)

8
Add Code in Class

Add a Reference to the


Assembly in the Logic Tier

9
Code for Class StudentWinForm.cs

using System.Data; Since we are using the DataSet Class



using Tuc.School.LogicTier;

namespace Tuc.School.WinFormApp
{
class StudentWinForm
{

public DataSet GetStudent(string connectionString)
{
StudentData studentData = new StudentData();

return studentData.GetStudentDB(connectionString);
}

}
}

10
Create Form

Label

DataGridView

11
Create Form Code

12
WinForm Code
using System.Configuration;
using Tuc.School.WinFormApp; Note!

namespace WinFormApp
{
ConnecZonString is
public partial class Form1 : Form stored in App.cong
{

private string connectionString =
ConfigurationManager.ConnectionStrings["SCHOOLConnectionString"].ConnectionString;

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
FillStudentGrid();

}

private void FillStudentGrid()
{

DataSet ds = new DataSet();

StudentWinForm studentList = new StudentWinForm();

ds = studentList.GetStudent(connectionString);

dataGridViewStudentInformation.DataSource = ds.Tables[0];

}
}
}
13
Note! Add System.ConguraZon Reference

14
Create DB ConnecZonString in App.cong
<?xml version="1.0" encoding="utf-8" ?>
<configuration>

<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>


<connectionStrings>
<add name="SCHOOLConnectionString" connectionString="Data Source=macwin8;Initial Catalog=SCHOOL;Persist Security
Info=True;User ID=sa;Password=xxxxxx"
providerName="System.Data.SqlClient" />
</connectionStrings>


</configuration>

15
Test it

It works!!! 16
Recommended Li7erature

Tutorial: IntroducZon to Database Systems


h7p://home.hit.no/~hansha/?tutorial=database
Tutorial: Structured Query Language (SQL)
h7p://home.hit.no/~hansha/?tutorial=sql
Tutorial: Using SQL Server in C#
Tutorial: IntroducZon to Visual Studio and C#
h7p://home.hit.no/~hansha/?tutorial=csharp

17
Hans-PeKer Halvorsen, M.Sc.
Telemark University College
Faculty of Technology
Department of Electrical Engineering, InformaVon Technology and CyberneVcs


E-mail: [email protected]
Blog: hKp://home.hit.no/~hansha/

18

You might also like