using (SqlConnection con = new SqlConnection(CS)) { con.Open(); SqlCommand cmd2 = new SqlCommand("SELECT [Item_Name],[Order_ID],[Price] FROM [Work_Lab].[dbo].[ItemOrderDetails]", con); //SqlDataReader dr = cmd2.ExecuteReader(); SqlDataAdapter ds = new SqlDataAdapter(cmd2); DataTable dt = new DataTable(); ds.Fill(dt); if (dt.Rows.Count > 0) { Response.Output.Write("--------------------------<br/>"); Response.Output.Write("|Item Name|Order No|Price |<br/>"); Response.Output.Write("--------------------------<br/>"); foreach (DataRow row in dt.Rows) { string name = "|"+Convert.ToString(row["Item_Name"]).PadRight(8)+"|"; string orderId = Convert.ToString(row["Order_ID"]).PadRight(5)+"|"; string price = row["Price"].ToString() + "|<br/>"; Response.Output.Write(name); Response.Output.Write(orderId); Response.Output.Write(price); } Response.Output.Write("--------------------------"); } con.Close(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)