代码如下:【没有实现取最大的两位数,TEXTBOX1里面只显示01,应该显示03】
【注意:请在VB里面实现,因为C字段数据已经是读取处理后的】
mycommand.CommandText = "select C from B"
mycommand.Connection = mycn
Try
mycn.Open()
Dim mysqlreader As Data.SqlClient.SqlDataReader = mycommand.ExecuteReader
mysqlreader.Read()
If IsNumeric(mysqlreader.GetString(0)) = True And Len(mysqlreader.GetString(0)) = 2 Then ‘判断C的值是否为2位数字’
TextBox1.Text = Trim(a) & mysqlreader.GetString(0) ‘
此处是没有实现的地方’
Else
TextBox1.Text = Trim(a) + "01"
End If
Catch ex As Exception
MsgBox(ex.ToString)
End Try