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); } } } } }