/////////////////ASPX/////////////////////
<asp

ataList id="DataList1" runat="server">
<ItemTemplate>
<table>
<tr>
<td>
<%# DataBinder.Eval(Container, "DataItem.CI_Billing_Email")%>
</td>
<td>
<%# DataBinder.Eval(Container, "Cart_ID")%>
</td>
</tr>
</table>
</ItemTemplate>
</asp

ataList>
//////////////////////////////////////////////////////
////////////////CODEBEHIN////////////////////
this.RDBCartList1.getHTML ();
cmd=RDBCartList1.SQL;
baglantim=new SqlConnection ();
baglantim.ConnectionString =data.Connection.ConnectionString;
baglantim.Open ();
SqlCommand mycmd=new SqlCommand(cmd,baglantim);
mycmd.ExecuteNonQuery ();
/*
rd=mycmd.ExecuteReader ();
while (rd.Read())
{
SqlDataReader rd;
Response.Write (rd["Cart_ID"] +"<br>");
}
*/
SqlDataAdapter da = new SqlDataAdapter ();
DataSet ds =new DataSet();
da.SelectCommand =mycmd;
da.Fill (ds,"MyTable");
DataList1.DataSource =ds;
DataList1.DataBind ();
When I run my code The datalist returns nothing to the screen . I tested my
connection and query , it works. When i run the code with comment (inside /*
*/ block) it works perfect. I think there is a problem with my datalist ?
What can be the problem ?