How to print table data in asp.net page

Question

0.00/5 (No votes)

See more:

I have one table data.I have inserted data into one table like employee table.Now when i click on insert button ,it will insert data.But after that i want to show the updated table data in next asp page.as I am new to .net please provide me simple code so that i can eaisly understand.I want to print the table data in a page ,while it is loading itself(in the page load i want to write the code of it).Please provide simple solution.

Posted 19-Nov-12 21:35pm

vinod.sambangi

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sarathtamil · Answer 1 · 2012-11-19T21:41:00

Solution 1

using select Query....
protected void Page_Load(object sender, EventArgs e)
{

SqlConnection con=new Sqlconnection("Data Source=.\\sqlexpress;Initial Catalog=DatabaseName;Integrated Security=True");
SqlCommand cmd=new SqlCommand("Select * from employee",con);
SqlDataReader dr=cmd.ExecuteReader()'
While(dr.Read())
{
TextBox1.Text=dr.GetValue(0).ToString();//first value of a employee table
TextBox2.Text=dr.GetValue(1).ToString();//second value of a employee table
TextBox3.Text=dr.GetValue(2).ToString();//third value of a employee table
.
.
.
}
}
Try This Code....

Posted 19-Nov-12 21:41pm

sarathtamil

Updated 19-Nov-12 21:49pm

v2

Comments

vinod.sambangi 20-Nov-12 3:58am

It was saying error in this line, "While(dr.Read())" as While does not exist in the current context

vinod.sambangi 20-Nov-12 4:15am

Please tell me

sarathtamil 21-Nov-12 23:17pm

while(dr.Read())//while is lower case letter..........

sarathtamil 21-Nov-12 23:17pm

while is small letter....