Alter Table with no data

[KeesBlunder]

With this i put a new table in a SQLCE database .

That works .

cmd = New SqlCeCommand("ALTER TABLE Datum ADD Specs NVARCHAR(50)", con)

If con.State = ConnectionState.Closed Then con.Open()
myDA = New SqlCeDataAdapter(cmd)
myDataSet = New DataSet()
myDA.Fill(myDataSet, "MyTable")
MsgBox("Oke")
If con.State = ConnectionState.Open Then con.Close()



Everything oke , because i want to save an empty textbox when i want to .

This i how it looks in the database.



But i want to put it in the database like this , empty or a space ?



Is this possible , and so what do i at to this statement.

cmd = New SqlCeCommand("ALTER TABLE Datum ADD Specs NVARCHAR(50)", con)

Continue reading...