Column 'name' does not belong to table error !!

[Aruna Tennakoon]

Hi,
      I wrote following code,

DataSet dtSet = new DataSet();
SqlConnection sqlConn = new SqlConnection(strConn);
SqlDataAdapter sqldata = new SqlDataAdapter("SELECT * FROM test",strConn);
sqldata.Fill(dtSet,"test");

DataTable myTable = new DataTable();
DataRow myRow;
myRow = myTable.NewRow();
myRow["name"] = "John";
myRow["address"] = "Smith";
myTable.Rows.Add(myRow);

but in "myRow["name"] = "John";" line i am getting an error  ": Column 'name' does not belong to table ." plz help me on this

-Thanks
-Aruna

[Per Hultqvist]

Aruna,

This error means that there is no column named "name" in the table "test".

Maybe these two rows are the problem :

myRow["name"] = "John"; ' Should column name be "firstname"?
myRow["address"] = "Smith"; ' Put last name in address-column? Should
be "lastname"?

Verify that all the columns you access exists in the table.

Hope it helps

/Per Hultqvist