Scribd
Upload
5 views6 pages

Three-Tier Data Management in C#

The document describes a three-tier architecture application for inserting and searching data in a database. The application has a presentation tier for the user interface, a business tier for application logic, and a data tier that directly accesses the database. The business tier calls methods on the data tier to insert and retrieve data. The data tier uses ADO.NET to connect to a SQL database and execute commands.

Uploaded by

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

Three-Tier Data Management in C#

The document describes a three-tier architecture application for inserting and searching data in a database. The application has a presentation tier for the user interface, a business tier for application logic, and a data tier that directly accesses the database. The business tier calls methods on the data tier to insert and retrieve data. The data tier uses ADO.NET to connect to a SQL database and execute commands.

Uploaded by

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

Assignment#2

Name:
Noor Saba
Roll No:
RC-167
Class:
BSCS
Subject:
VP
Section
B
CODE:

using System;

using [Link];

namespace ThreeTierDemo

public partial class MainForm : Form

public MainForm()

InitializeComponent();

private void insertButton_Click(object sender, EventArgs e)

string name = [Link];

int age = [Link]([Link]);

[Link](name, age);

[Link]("Data inserted successfully.");

private void searchButton_Click(object sender, EventArgs e)


{

string searchTerm = [Link];

var searchResults = [Link](searchTerm);

[Link]();

foreach (var result in searchResults)

[Link]($"Name: {[Link]}, Age: {[Link]}");

using [Link];

namespace ThreeTierDemo

class BusinessTier

public static void InsertData(string name, int age)

[Link](name, age);

public static List<Person> SearchData(string searchTerm)

{
var searchResults = [Link](searchTerm);

return searchResults;

using [Link];

using [Link];

namespace ThreeTierDemo

class DataTier

public static void InsertData(string name, int age)

using (var connection = new SqlConnection("<connection string>"))

[Link]();

using (var command = new SqlCommand("INSERT INTO People (Name, Age) VALUES (@name,
@age)", connection))

[Link]("@name", name);

[Link]("@age", age);

[Link]();
}

public static List<Person> SearchData(string searchTerm)

var results = new List<Person>();

using (var connection = new SqlConnection("<connection string>"))

[Link]();

using (var command = new SqlCommand("SELECT Name, Age FROM People WHERE Name LIKE
@searchTerm", connection))

[Link]("@searchTerm", $"%{searchTerm}%");

using (var reader = [Link]())

while ([Link]())

string name = [Link](0);

int age = reader.GetInt32(1);

[Link](new Person { Name = name, Age = age });

}
}

return results;

You might also like