protected void Page_Load(object sender, EventArgs e) { Response.Write( "Write a program that retrieves the images for all categories in the Northwind database and stores them as JPG files in the file system.<br>"); RepairYourDatabase(); string query = "SELECT Picture FROM [dbo].[Categories]"; SqlProvider.ExecuteSqlQueryReturnValue(query, null, delegate(SqlDataReader reader) { List <string> images = new List <string>(); while (reader.Read()) { var folder = Server.MapPath("\\Images\\Categories\\"); if (Helpers.DirectoryExist(folder)) { var filePath = folder + images.Count + ".Jpeg"; byte[] data = (byte[])reader["Picture"]; WriteBinaryFile(filePath, data); images.Add(filePath); } } grdResult.DataSource = images; grdResult.DataBind(); }); }
protected void Page_Load(object sender, EventArgs e) { Response.Write("Write a program that retrieves from the Northwind sample database in MS SQL Server the number of rows in the Categories table.<br>"); string query = "SELECT COUNT(*) from [dbo].[Categories]"; SqlProvider.ExecuteSqlQueryReturnValue(query, null, delegate(SqlDataReader reader) { grdResult.DataSource = reader; grdResult.DataBind(); }); }
protected void btnSearch_Click(object sender, EventArgs e) { string query = "SELECT ProductName FROM Products WHERE CHARINDEX (@SearchOption, ProductName)>0"; Dictionary <string, object> parametters = new Dictionary <string, object>(); parametters.Add("SearchOption", txtSearchOption.Text); SqlProvider.ExecuteSqlQueryReturnValue(query, parametters, delegate(SqlDataReader reader) { grdResult.DataSource = reader; grdResult.DataBind(); }); }
protected void Page_Load(object sender, EventArgs e) { Response.Write( "Write a program that retrieves from the Northwind database all product categories and the names of the products in each category. Can you do this with a single SQL query (with table join)?<br>"); string query = "SELECT c.CategoryName, p.ProductName From Categories c JOIN Products p ON c.CategoryID = p.CategoryID"; SqlProvider.ExecuteSqlQueryReturnValue(query, null, delegate(SqlDataReader reader) { grdResult.DataSource = reader; grdResult.DataBind(); }); }