Alter Query on DBF table giving error

Dear Members,

I am a newbie in GIS field , Access & SQL databases canbe altered easily but when I am altering a DBF file its format gets corrupted .Plz help me in this regard.My code snippet is

public void Alter_table()

{

try

{

string strConnect;

strConnect="User ID=;DSN=;Collating Sequence=MACHINE;Data Source='d:\';Provider=VFPOLEDB.1;Cache Authentication=False;Mask Password=False;persist security info=False;Mode=Share Exclusive;Extended Properties=;Encrypt Password=False";

OleDbConnection dconn=new OleDbConnection();

dconn.ConnectionString = strConnect;

dconn.Open();

OleDbCommand mycmd=new OleDbCommand();

OleDbCommand myCmd = new OleDbCommand("ALTER TABLE 22.dbf ADD COLUMN TEST1 c(10) NULL", dconn);

myCmd.ExecuteNonQuery();

}

catch(OleDbException ex)

{

MessageBox.Show(ex.Message);

}

Thanks & Regards,

Anil Dhiman

Answer this question

Alter Query on DBF table giving error

Alter Query on DBF table giving error

Answer this question