本文實例講述了C#更新SQLServer中TimeStamp字段(時間戳)的方法。分享給大家供大家參考。具體實現方法如下:
public partial class Form1 : Form{    private SqlConnection mCnn = null;    private long TimeStampValue;    public Form1()    {      InitializeComponent();      mCnn = new SqlConnection();      mCnn.ConnectionString = "Data Source=192.168.18.205;Database=" +              "Test;Uid=sa;Pwd=kicpassword";      mCnn.Open();    }    //讀取    private void btnReadTimeStamp_Click(object sender, EventArgs e)    {      //使用convert(bigint,FTimeStamp) MyTimeStamp把FTimeStamp轉換為bigint整數類型      string strSQL = "Select Top 1 FCaption,convert(bigint,FTimeStamp) MyTimeStamp,FTimeStamp From t_TimeStamp";      SqlCommand Cmd = new SqlCommand(strSQL, mCnn);      SqlDataReader Reader = Cmd.ExecuteReader();      while (Reader.Read())      {        long value = (long)Reader["MyTimeStamp"];        TimeStampValue = value;        //在此處把TimeStamp的值賦值給變量,用于更新時判斷        txtTimeStamp.Text = value.ToString();        txtTimeStampHex.Text=value.ToString("X16");      }      Reader.Close();      Reader = null;    }    //更新    private void btnUpdateTimeStamp_Click(object sender, EventArgs e)    {      //Where條件加上TimeStamp的判斷,必須和讀取的一致,用于并發操作      string strSQL = "Update t_TimeStamp Set FCaption = '修改記錄'" +        " Where FTimeStamp =" + TimeStampValue.ToString();      SqlCommand cmd = new SqlCommand(strSQL, mCnn);      int UpdateCount = cmd.ExecuteNonQuery();      if (UpdateCount <= 0)      {        MessageBox.Show("更新失敗!");      }      else      {        MessageBox.Show("更新成功!");                        }    }}希望本文所述對大家的C#程序設計有所幫助。
新聞熱點
疑難解答