Here the code in classic asp, i want to do this in asp.net. I am using datalist in asp.net. How can i do this. Please help
<%
set con=Server.CreateObject("ADODB.Connection")
con.Open strcon
set rs=Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM category where article_allow=1",con,0,1
do while not rs.eof
article_visit=0
set rst=Server.CreateObject("ADODB.Recordset")
rst.Open "SELECT article_visit FROM article_list where cat_ID="&rs("cat_ID")&" and article_status=1",con,0,1
do while not rst.eof
article_visit=rst("article_visit")+article_visit
rst.MoveNext
loop
set rst=nothing
%>
Thanks in advance
Please provide me the code in c#
I convert the classic asp code to C# like this but it gives the result is 0, please check this code:
string article_visit="0";
SqlConnection con=Database.GetConnection();
DataTable data=new DataTable();
SqlCommand sqlQuery=new SqlCommand("select * from category where article_allow = 1", con);
SqlDataAdapter dataAdapter=new SqlDataAdapter(sqlQuery);
//Dim dataAdapter As New OdbcDataAdapter(sqlQuery, connectionString)
dataAdapter.Fill(data);
//Dim index As Integer = 0
int index=0;
do
{
article_visit="0";
SqlCommand cmd=new SqlCommand("SELECT article_visit FROM article_list where cat_ID=@cat_id and article_status=1",con);
cmd.Parameters.AddWithValue("@cat_id", data.Rows[index]["cat_ID"]);
dataAdapter=new SqlDataAdapter(cmd);
DataTable data1=new DataTable();
dataAdapter.Fill(data1);
int index1=0;
do
{
article_visit=int.Parse(data1.Rows[index1]["article_visit"].ToString()) + article_visit;
index1=index1+1;
}while(index1<data1.Rows.Count);
index=index+1;
}while(index<data.Rows.Count);