大家过来看看

[zoxn]

我的数据库中字段"出生日期"有一条记录为"1900-1-1",我想在datagrid中显示的时候清空
datagrid中的那个单元格.但下面的做法不对,大家看看问题怎么解决

Private Sub ButShow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButShow.Click
Dim SQLStr As String
Dim SQLConn As String
SQLConn = "server=(local);database=user1;user id=sa;password=sa"
Dim conn As SqlClient.SqlConnection = New SqlClient.SqlConnection(SQLConn)
SQLStr = "select * from test"
Dim sqlAdapter As SqlClient.SqlDataAdapter = New SqlDataAdapter(SQLStr, conn)
Dim ds As DataSet = New DataSet
sqlAdapter.Fill(ds)
Dim sqlcmd As SqlClient.SqlCommand = New SqlClient.SqlCommand(SQLConn, conn)
DataGrid1.DataSource = ds
End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButUpdate.Click
If DataGrid1.Item(0, 1) = "1900-01-01" Then
DataGrid1.Item(0, 1) = ""
End If
End Sub

提示错误是不能将空字符串赋给日期型数据,怎么解决?

[bbdog]

****If DataGrid1.Item(0, 1) = "1900-01-01" Then****
"1900-01-01"这样写不对吧，把字符串转成日期型试试？
不记得是哪个函数了，大概如：Convert.Date("1900-01-01")
查帮助。