Notes

/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [OrderID]
,[CustomerID]
,[EmployeeID]
,[OrderDate]
,[RequiredDate]
,[ShippedDate]
,[ShipVia]
,[Freight]
,[ShipName]
,[ShipAddress]
,[ShipCity]
,[ShipRegion]
,[ShipPostalCode]
,[ShipCountry]
FROM [Northwind].[dbo].[Orders]



__________________________-
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [EmployeeID]
,[LastName]
,[FirstName]
,[Title]
,[TitleOfCourtesy]
,[BirthDate]
,[HireDate]
,[Address]
,[City]
,[Region]
,[PostalCode]
,[Country]
,[HomePhone]
,[Extension]
,[Photo]
,[Notes]
,[ReportsTo]
,[PhotoPath]
FROM [Northwind].[dbo].[Employees]




__

Select top 5 * from Products ORDER BY UnitPrice;

-----------------


using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Runtime.Intrinsics.Arm;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp4
{
internal class DataAdapter
{
SqlConnection conn;
SqlConnection conn1;
string connectionString = "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Northwind;Integrated Security=SSPI";
string connectionString1 = "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Practice6;Integrated Security=SSPI";
public DataAdapter()
{
conn = new SqlConnection(connectionString);
conn1 = new SqlConnection(connectionString1);
}
static void Main()
{
DataAdapter d = new DataAdapter();
// d.ReaddataInNorthwind();
// d.ReadDataInPracticeDB();
d.ReaddataTopFive();
}
public void ReaddataTopFive()
{
SqlDataReader rdr = null;
try
{
conn.Open();
//SqlCommand cmd = new SqlCommand("Select top 5 * from Customers", conn);
SqlDataAdapter d = new SqlDataAdapter("Select top 5 * from Products ORDER BY UnitPrice", conn);


DataSet ds = new DataSet();
d.Fill(ds, "data");




foreach (DataRow row in ds.Tables["data"].Rows)
{
Console.WriteLine(row["ProductName"]);

}



/* while (rdr.Read())
{
Console.WriteLine(rdr[1] + "tttt" + rdr[2]);
}*/

}
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
}

public void ReaddataInNorthwind()
{
SqlDataReader rdr = null;
try
{
conn.Open();
//SqlCommand cmd = new SqlCommand("Select top 5 * from Customers", conn);
SqlDataAdapter d = new SqlDataAdapter("Select top 5 * from Employees", conn);
SqlDataAdapter d1 = new SqlDataAdapter("Select top 5 * from Orders", conn);

DataSet ds = new DataSet();
d.Fill(ds,"data");
d1.Fill(ds, "data1");
// DataRelation dr = new DataRelation("combined", ds.Tables["data"].Columns["EmployeeID"], ds.Tables["data1"].Columns["EmployeeID"]);
//ds.Relations.Add(dr);



foreach (DataRow row in ds.Tables["data"].Rows)
{
Console.WriteLine(row["ContactName"]);

}
Console.WriteLine();
foreach (DataRow row in ds.Tables["data1"].Rows)
Console.WriteLine(row["ProductName"]);


/* while (rdr.Read())
{
Console.WriteLine(rdr[1] + "tttt" + rdr[2]);
}*/

}
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
}
public void ReadDataInPracticeDB()
{
SqlDataReader rdr = null;
try
{
conn.Open();
//SqlCommand cmd = new SqlCommand("Select top 5 * from Customers", conn);
SqlDataAdapter d = new SqlDataAdapter("Select * from Orders", conn1);
SqlDataAdapter d1 = new SqlDataAdapter("Select * from Product", conn1);

DataSet ds = new DataSet();
d.Fill(ds, "data");
d1.Fill(ds, "data1");
// DataRelation dr = ds.Relations.Add("combined data", ds.Tables["data"].Columns["CustomerID"], ds.Tables["data1"].Columns["CustomerID"]);



foreach (DataRow row in ds.Tables["data"].Rows)
{
Console.WriteLine(row["CustomerID"]);

}
Console.WriteLine();
foreach (DataRow row in ds.Tables["data1"].Rows)
Console.WriteLine(row["name"]);


/* while (rdr.Read())
{
Console.WriteLine(rdr[1] + "tttt" + rdr[2]);
}*/

}
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
}




}
}