static void Main(string[] args)
{
SqlConnection dbCon = NorthwindDBConnection.Connect();
dbCon.Open();
using (dbCon)
{
SqlCommand command = new SqlCommand(
"SELECT c.CategoryName, p.ProductName " +
"FROM Categories c " +
"JOIN Products p " +
"ON c.CategoryID = p.CategoryID " +
"GROUP BY c.CategoryName, p.ProductName", dbCon);
SqlDataReader reader = command.ExecuteReader();
using (reader)
{
while (reader.Read())
{
string categoryName = (string)reader["CategoryName"];
string productName = (string)reader["ProductName"];
Console.WriteLine("{0} - {1}", categoryName, productName);
}
}
}
}
static void Main(string[] args)
{
SqlConnection dbCon = NorthwindDBConnection.Connect();
dbCon.Open();
using (dbCon)
{
SqlCommand command = new SqlCommand(
"SELECT CategoryName, Description FROM Categories", dbCon);
SqlDataReader reader = command.ExecuteReader();
using (reader)
{
while (reader.Read())
{
string categoryName = (string)reader["CategoryName"];
string categoryDescription = (string)reader["Description"];
Console.WriteLine("{0} - {1}", categoryName, categoryDescription);
}
}
}
}
static void Main(string[] args)
{
SqlConnection dbCon = NorthwindDBConnection.Connect();
dbCon.Open();
using (dbCon)
{
InsertIntoProducts("Rakia", 1, 1, "0.7ml", 10.56M, 7, 5, 1, true, dbCon);
Console.WriteLine("Rakia Inserted!");
}
}
static void Main(string[] args)
{
SqlConnection dbCon = NorthwindDBConnection.Connect();
dbCon.Open();
using (dbCon)
{
SqlCommand command = new SqlCommand(
"SELECT COUNT(CategoryID) FROM Categories", dbCon);
int categoriesCount = (int)command.ExecuteScalar();
Console.WriteLine("Categories count: " + categoriesCount);
}
}
static void Main(string[] args)
{
string searchedString = Console.ReadLine();
if (Regex.IsMatch(searchedString, "[^0-9a-zA-Z]", RegexOptions.CultureInvariant))
{
searchedString = "[" + searchedString + "]";
}
SqlConnection dbCon = NorthwindDBConnection.Connect();
dbCon.Open();
using (dbCon)
{
SqlParameter searchParameter = new SqlParameter();
searchParameter.ParameterName = "@searchParameter";
searchParameter.Value = string.Format("%{0}%", searchedString);
SqlCommand getCategories = new SqlCommand(
"SELECT ProductName " +
"FROM Products " +
"WHERE ProductName LIKE @searchParameter", dbCon);
getCategories.Parameters.Add(searchParameter);
var reader = getCategories.ExecuteReader();
using (reader)
{
Console.WriteLine("Matches:");
while (reader.Read())
{
string line = (string)reader["ProductName"];
Console.WriteLine(line);
}
}
}
}
static void Main(string[] args)
{
int fileOffset = 78;
// Pictures will be in the project folder
string picturePath = "../../Picture";
string pictureExtension = ".jpg";
SqlConnection dbCon = NorthwindDBConnection.Connect();
dbCon.Open();
using (dbCon)
{
SqlCommand command = new SqlCommand(
"SELECT Picture, CategoryID " +
"FROM Categories", dbCon);
SqlDataReader reader = command.ExecuteReader();
using (reader)
{
while (reader.Read())
{
byte[] pictureBytes = (byte[])reader["Picture"];
int categoryID = (int)reader["CategoryID"];
MemoryStream stream = new MemoryStream(
pictureBytes, fileOffset,
pictureBytes.Length - fileOffset);
Image image = Image.FromStream(stream);
using (image)
{
image.Save(picturePath + categoryID + pictureExtension, ImageFormat.Jpeg);
}
}
}
}
}
