i try but it keep saying (format of the intitialization string does not conform to specification starting at index 0)
below is my code:
Private Sub Create_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Create.Click
Dim ConnString As String = "C:\Users\Peck\Documents\Visual Studio 2010\Projects\LegendaSystem\LegendaSystem\bin\Sample01.mdb"
Dim SqlString As String = "ALTER TABLE School ADD COLUMN" + TextBox1.Text.Trim() + "Text(20)"
Using con As New OleDbConnection(ConnString)
Using cmd As New OleDbCommand(SqlString, con)
This post has been edited by peck: 17 January 2011 - 06:02 AM