How to show datalist inside gridview.?

Susanta Rout

11y1.2kLearn iOS Programming

how to show data in datalist inside gridview from database

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Susanta Rout11y ago

html

-----------------------

Name

Date

<%#Eval("STATUS")%>

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 Menoth11y ago
Hi,

Check this one..

http://forums.asp.net/t/1410638.aspx?Bind+datalist+inside+a+gridview+column
0
Susanta Rout11y ago
i want the reverse one rajesh sir,datalist inside gridview
0
Rajeesh Menoth11y ago
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
0
Susanta Rout11y ago
i want to bind asp:datalist control inside asp:gridview sir
0
Sujeet Suman11y ago
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.
0