C#更新SQLServer中TimeStamp字段(时间戳)的方法
本文实例讲述了C#更新SQLServer中TimeStamp字段(时间戳)的方法。分享给大家供大家参考。具体实现方法如下:
publicpartialclassForm1:Form { privateSqlConnectionmCnn=null; privatelongTimeStampValue; publicForm1() { InitializeComponent(); mCnn=newSqlConnection(); mCnn.ConnectionString="DataSource=192.168.18.205;Database="+ "Test;Uid=sa;Pwd=kicpassword"; mCnn.Open(); } //读取 privatevoidbtnReadTimeStamp_Click(objectsender,EventArgse) { //使用convert(bigint,FTimeStamp)MyTimeStamp把FTimeStamp转换为bigint整数类型 stringstrSQL="SelectTop1FCaption,convert(bigint,FTimeStamp)MyTimeStamp,FTimeStampFromt_TimeStamp"; SqlCommandCmd=newSqlCommand(strSQL,mCnn); SqlDataReaderReader=Cmd.ExecuteReader(); while(Reader.Read()) { longvalue=(long)Reader["MyTimeStamp"]; TimeStampValue=value; //在此处把TimeStamp的值赋值给变量,用于更新时判断 txtTimeStamp.Text=value.ToString(); txtTimeStampHex.Text=value.ToString("X16"); } Reader.Close(); Reader=null; } //更新 privatevoidbtnUpdateTimeStamp_Click(objectsender,EventArgse) { //Where条件加上TimeStamp的判断,必须和读取的一致,用于并发操作 stringstrSQL="Updatet_TimeStampSetFCaption='修改记录'"+ "WhereFTimeStamp="+TimeStampValue.ToString(); SqlCommandcmd=newSqlCommand(strSQL,mCnn); intUpdateCount=cmd.ExecuteNonQuery(); if(UpdateCount<=0) { MessageBox.Show("更新失败!"); } else { MessageBox.Show("更新成功!"); } } }
希望本文所述对大家的C#程序设计有所帮助。