How to show datalist inside gridview.?

Question

how to show data in datalist inside gridview from database

Susanta Rout · Answer

html ----------------------- Name '> Date code behind -------------------------------- protected void Page_Load(object sender EventArgs e) { show(); } public void show() { SqlConnection cn = new SqlConnection(user id=sa;password=sa123;server=localhost;database=Test); SqlDataAdapter da = new SqlDataAdapter(select distinct NAME from Temp cn); DataTable dt = new DataTable(); da.Fill(dt); grdView.DataSource = dt; grdView.DataBind(); } public void show_status() { } protected void grdView_RowDataBound(object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //int name = Convert.ToInt32(grdView.DataKeys[e.Row.RowIndex].Values[0]); Label lblname = (Label)e.Row.FindControl(lblName); DataList DataList1 = ((DataList)e.Row.FindControl(dlview)); SqlConnection cn = new SqlConnection(user id=sa;password=sa123;server=localhost;database=Test); SqlDataAdapter da1 = new SqlDataAdapter(select STATUS from Temp where NAME=+lblname.Text+ cn); DataTable dt1 = new DataTable(); da1.Fill(dt1); DataList1.DataSource = dt1; DataList1.DataBind(); } } } database.....table Susanta 2015-06-05 00:00:00.000 P HARI 2015-06-05 00:00:00.000 P Gopal 2015-06-06 00:00:00.000 P Sita 2015-06-06 00:00:00.000 A Susanta 2015-06-06 00:00:00.000 P Susanta 2015-06-07 00:00:00.000 P Susanta 2015-06-08 00:00:00.000 P NULL NULL NULL i want to print like this Susanta P P P P Sita A Hari P Gopal P

Rajeesh Menoth · Answer

Hi Check this one.. http://forums.asp.net/t/1410638.aspx?Bind+datalist+inside+a+gridview+column

Susanta Rout · Answer

i want the reverse one rajesh sirdatalist inside gridview

Rajeesh Menoth · Answer

Hi Refer this article.. http://www.c-sharpcorner.com/Blogs/13924/datalist-have-gridview-inside.aspx http://stackoverflow.com/questions/8901237/gridview-inside-datalist-asp-net

Susanta Rout · Answer

i want to bind asp:datalist control inside asp:gridview sir

Sujeet Suman · Answer

Susanta please once use below code to bind your GridView: public partial class Asp : System.Web.UI.Page { SqlConnection con; public Asp() { con = new SqlConnection(Your Connection String); } protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { DisplayRecord(); } } public DataTable DisplayRecord() { SqlDataAdapter Adp = new SqlDataAdapter(select * from company con); DataTable Dt = new DataTable(); Adp.Fill(Dt); grid1.DataSource = Dt; grid1.DataBind(); return Dt; } } For more details please once go through below link: http://www.c-sharpcorner.com/UploadFile/b43a5b/retrieving-data-in-gridview-in-Asp-Net/ If this is helpful for you then please accept my Answer .