How do i get this Format in asp.net?

Question

Hi I want to Bind the student details From sql server to aspx page Like this format..

NAME	XXX	Date of berth	01/04/1998
Sex	Male	Address	11,sss,sss-01
Class	10th	Section	A

In asp.net Which Control Should i use...

it's important any one help me out..as soon as possible...

Sanjeeb Lenka · Answer

for this scenario Repeater is best to use. ex: Name: '> Date of Birth: '> Sex: '> Address: '> Class: '> section: '> then bind the reapeter to dataset. protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(Server=Laku-Pc;Database=MYDB;User Id=sa;Password=laku;); SqlDataAdapter da = new SqlDataAdapter(select * from student con); DataSet ds = new DataSet(); da.Fill(ds); Repeater1.DataSource = ds; Repeater1.DataBind(); }

Iftikar Hussain · Answer

in your aspx Demo table { border-collapse: collapse;font-family:Arial;font-size:12px;border:1px solid gray } table tr { height: 25px; } table td { border:1px solid gray } NAME XXX Date of berth 01/04/1998 Sex Male Address 11ssssss-01 Class 10th Section A in your code behind protected void Page_Load(object sender EventArgs e) { LoadData(); } private void LoadData() { string constring = @Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUserId;Password=MyPassword; using (SqlConnection conn = new SqlConnection(constring)) { conn.Open(); SqlCommand cmd = new SqlCommand(select NameDobSexAddressClassSection from Employee where empid=@EmpId conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@EmpId empId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { LblName.Text = reader[Name].ToString(); LblDob.Text = reader[Dob].ToString(); LblSex.Text = reader[Sex].ToString(); LblAddress.Text = reader[Address].ToString(); LblClass.Text = reader[Class].ToString(); LblSection.Text = reader[Section].ToString(); } reader.Close(); conn.Close(); } } Regards Iftikar

selva kumar · Answer

Can u tell me the reference how do i use to get this format..

Iftikar Hussain · Answer

Hi You can use Repeater control if you do want to use SortingPaging. Otherwise Gridview is another option. Refer this http://www.encodedna.com/2013/01/asp.net-gridview-edit-delete.htm Regards Iftikar