how to take print from a saved table

selvi subramanian

13y1.3k

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

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

Regards,
Iftikar
selvi subramanian13y ago
i need it in web application
Iftikar Hussain13y ago
Please refer the my previous post. It is in asp.net only, in winform we dont have HTML control

Regards,
Iftikar
selvi subramanian13y ago
Thanks Iftikar Hussain. but i need it in asp.net using c#

Iftikar Hussain13y ago

Hi,
First you display the data from sql to asp.net.

in your aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm4.aspx.cs" Inherits="WebApplication1.WebForm4" %>

Name
adddress
product name
price
total

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 name,adddress,product_name,price,total 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 Lenka13y ago
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