C#

SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "update VopMessage_tbl set StartDate=@StartDate , EndDate=@EndDate , StartTime=@StartTime , EndTime=@EndTime where MarkedListNumber=@MarkedListNumber";
            cmd.Connection = con;
            cmd.Parameters.Add("@StartDate", SqlDbType.NVarChar);
            cmd.Parameters.Add("@EndDate", SqlDbType.NVarChar);
            cmd.Parameters.Add("@StartTime", SqlDbType.NVarChar);
            cmd.Parameters.Add("@EndTime", SqlDbType.NVarChar);
            cmd.Parameters.Add("@MarkedListNumber", SqlDbType.Int);
            con.Open();
            for (int t = 0; t < messageSequence.Count; t++)
            {
                MessageInfo minfo = (MessageInfo)messageSequence[t];
                for (int f = 0; f < Set30bytesMessage.Count; f++)
                {
                    VopMessage vms = (VopMessage)Set30bytesMessage[f];
                    if (minfo.ListNumber == vms.ListNumber)
                    {
                        cmd.Parameters["@StartDate"].Value = minfo.StartDate;
                        cmd.Parameters["@EndDate"].Value = minfo.EndDate;
                        cmd.Parameters["@StartTime"].Value = minfo.StartTime;
                        cmd.Parameters["@EndTime"].Value = minfo.EndTime;
                        
                    }
                }
            }
            cmd.ExecuteNonQuery();
            con.Close();