how to take print from a saved table

Question

in one table i save data i need to take printout that table like this name selvi adddress karaikudi product name closeup price 15 total 15 i need to take print using asp.net

Iftikar Hussain · Answer

these for web application only. I am not sure why are confused about the code I paste it Regards Iftikar

selvi subramanian · Answer

i need it in web application

Iftikar Hussain · Answer

Please refer the my previous post. It is in asp.net only in winform we dont have HTML control Regards Iftikar

selvi subramanian · Answer

Thanks Iftikar Hussain. but i need it in asp.net using c#

Iftikar Hussain · Answer

Hi First you display the data from sql to asp.net. in your aspx Name adddress product name price total function printdata() { window.print(); } in your code namespace WebApplication2 { public partial class WebForm4 : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { LoadData(); } private void LoadData() { string constring = @Data Source=SQLEXPRESS;Initial Catalog=YourDatabase;Persist Security Info=True;User ID=UserId;Password=YourPassword; using (SqlConnection con = new SqlConnection(constring)) { using (SqlCommand cmd = new SqlCommand(select nameadddressproduct_namepricetotal from yourtable con)) { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Label1.Text = reader[name].ToString(); Label2.Text = reader[adddress].ToString(); Label3.Text = reader[product_name].ToString(); Label4.Text = reader[price].ToString(); Label5.Text = reader[total].ToString(); } reader.Close(); con.Close(); } } } } } Regards Iftikar

Sanjeeb Lenka · Answer

1st prepare the desgn and bind the data then print it refer to this link http://www.aspdotnet-suresh.com/2012/10/print-aspnet-gridview-data-using-c.html