C#中如何将一个数据表的当前行某个列的值与当前日期比较?(100分)

F

flysand

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-05-25

• #1

//Tables[0]中有一字段ADate,如何把当前记录的ADate值与当前日期比较?
SqlCeDataAdapter m_oDA = new SqlCeDataAdapter();
m_oDs.Clear();
m_oDA.SelectCommand = new SqlCeCommand(s,this.m_oCn);
m_oDA.Fill(m_oDs);
this.bmCars = this.BindingContext[m_oDs.Tables[0]];
this.bmCars.Position=0;
......

 

O

onlyonekgx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-05-25

• #2

vDate=m_oDA.Tables[0]["ADate"]

 

F

flysand

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-05-25

• #3

不对,编译出错:
if (m_oDs.Tables[0]["tdate"]<date())
无法将带 [] 的索引应用于“System.Data.DataTable”类型的表达式

 

O

onlyonekgx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-05-25

• #4

m_oDs.Tables[0].Rows[0]["tdate"]

 

F

flysand

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-05-25

• #5

应该是:m_oDs.Tables[0].Columns["tdate"]

 

F

flysand

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-05-25

• #6

if (m_oDs.Tables[0].Columns["tdate"]<DateTime.Today)
晕死,还是不对:运算符“<”无法应用于“System.Data.DataColumn”和“System.DateTime”类型的操作数

 

D

Delphi_MM

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-23

• #7

Convert.ToDateTime(m_oDA.Tables[0]["ADate"]) < DateTime.Today

 

C

Codemoocow

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-17

• #8

两DateTime比较要看你要求的精确度了，直接比较的精确度是1/100毫秒。
如：
DateTime nNow1 = DateTime.Now;
Sleep(10);
DateTime nNow2 = DateTime.Now;
nNow1 = nNow2 ?
当然是不等于了。但可以将年、月、日、时、分、秒都拆出来，自己进行比较。

 

Z

zizaiyou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-09

• #9

int i=this.bmCars.Position;
DateTime selectDt=Convert.ToDateTime(m_oDs.Tables[0].Rows["tdate"].ToString());
if(selectDt<DateTime.ToDay)
.....