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 sir,datalist 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 .