如何从dataTable读取所有行以检查以前的记录 [英] how to read all the rows from dataTable to check previous records

问题描述

大家好，



我想读取以前记录的dataTable，



表示，如果记录已经是他们今天的日期，然后它应该发出警报。



ni有数据表插入这些记录，



现在我想将这些记录与DatePicker的文本框进行比较。



Plzzz建议......



谢谢

Hi guys,

I want to read dataTable for previous records,

means, if the records are already their for Today's date, then it should throw an alert.

n i have datatable where these records are inserted,

now i want to compare those records with the textbox of DatePicker.

Plzzz Suggest...

Thanks

推荐答案

foreach(DataRow dr in dt.Rows) // dt => your datatable
{
    if(dr["Name"].ToString() == nameTxt.Text)
    {
        // do something here...
        // same check for your date thing...
    }
}

希望这会有所帮助你，祝你好运:)



-KR

Hope this will help you,Good Luck :)

-KR

protected void txtvDate_TextChanged1(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            dt = DAL.GenericSP_RS(1, "Sp_GetVehicleTrack", "");
            foreach (DataRow row in dt.Rows)
            {
                foreach (var item in row.ItemArray)
                {
                    DateTime dtc = Convert.ToDateTime(txtvDate.Text);
                    DateTime idt = Convert.ToDateTime(item);
                    if (dtc == idt)
                    {
                        Response.Redirect("VehicleManagement.aspx?idt=" + txtvDate.Text);
                       //lblmsg.Text =  "Record already inserted!";
                    }
                }
            }
        }

这篇关于如何从dataTable读取所有行以检查以前的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！