K
KeesBlunder
Guest
Hello,
I am trying to alter the column type in a SQLce database from nvarchar to datetime.
But there is an error on MODIFY
cmd = New SqlCeCommand("ALTER TABLE Gegevens MODIFY Startdatum datetime", con)
If con.State = ConnectionState.Closed Then con.Open()
myDA = New SqlCeDataAdapter(cmd)
myDataSet = New DataSet()
myDA.Fill(myDataSet, "MyTable")
If con.State = ConnectionState.Open Then con.Close()
Continue reading...
I am trying to alter the column type in a SQLce database from nvarchar to datetime.
But there is an error on MODIFY
cmd = New SqlCeCommand("ALTER TABLE Gegevens MODIFY Startdatum datetime", con)
If con.State = ConnectionState.Closed Then con.Open()
myDA = New SqlCeDataAdapter(cmd)
myDataSet = New DataSet()
myDA.Fill(myDataSet, "MyTable")
If con.State = ConnectionState.Open Then con.Close()
Continue reading...