Here in my case i have some 50-60 customer data available in database
and i want to print them in a form of Receipt.
i have already designed the receipt by using label controls in page load event but
on page load it only display last value fetched by database.
how i can print all customer details at once ?
private void printmethod()
{
string CS = System.Configuration.ConfigurationManager.ConnectionStrings["SocietyCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("Select * from tblmember", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
lblIDs.Text = rdr.GetValue(1).ToString();
lblnames.Text = rdr.GetValue(3).ToString();
lblwings.Text = rdr.GetValue(4).ToString();
lblrooms.Text = rdr.GetValue(5).ToString();
}
}
}
this code only show value of last database row,
i dnt know how to dynamically assign label and value so that it will print all details from database.
Thanks in Advance
Anupam SinghPosted Oct 25, 2014, 9:46 AM
here is a simple example :
http://www.codeproject.com/Articles/81118/ITextSharp-Helper-Class
Tarun JaiswalPosted Oct 23, 2014, 11:44 PM
but my situation is far different from your solution print trick and code i already have but what m asking is for C# code which generate all details from database in a form of receipt like we get in Shop when we buy some product but in shop we get only one receipt that is ours but i want to generate all receipts that has been available in database.
Anupam SinghPosted Oct 23, 2014, 4:37 AM
You can see a sample here :http://www.aspsnippets.com/articles/print-aspnet-panel-contents-with-print-preview-using-javascript.aspx