逐个获取数据表记录 [英] fetch datatable record one by one

问题描述

如何获取数据表中的记录

i完成它但我只有一个记录...当我去第二条记录......它没有返回值..

how to fetch record in datatable
i done it but i got only one record...when i going to seccond record...its no return value..

DataTable dt = new DataTable();

        string memberid = Session["useridno"].ToString();
        string senderid =  Request.QueryString["Id"].ToString();

        //clsregisterinfo.SenderId = senderid;
        clsregisterinfo.ReceiverId = memberid;

        dt = clsregisterinfo.fetch_friendrequest();
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count;i++ )
            {
                if (dt.Rows[i]["Reg_Id"].ToString() == senderid)
                {
                    btninterest.Enabled = false;
                    btninterest.Visible = false;
                }
            }
        }
        else
        {
            btninterest.Enabled = true;
            btninterest.Visible = true;
        }

推荐答案

这种方法几乎是正确的。检查第二行中是否有此项目的数据。 />


另外，如果你在循环中放入一次启用条件，每次循环运行时这都会改变。

检查你是否想要这个功能。

This approach is almost correct.Check if there is data for this item in the second row.

In addition, if you are putting enabled condition once in the loop, this will change everytime the loop runs.
Check if you want this functionality.

if (dt.Rows[i]["Reg_Id"].ToString() == senderid)
{
    btninterest.Enabled = false;
    btninterest.Visible = false;
}

这篇关于逐个获取数据表记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！