Updating SQL Server 2000 with varying column names

[ColdWaterBlue]

I am trying to update a table in SQL Server 2000 that will be able to have varying column names (based on the user's specifications). I can read the data fine, but I can't add anything to the table. There are spaces in the column name (i.e. "Received By") and when reading I put brackets [] around it and it works. When I am trying to write to the table, I can update the dataset fine, but not the table in SQL Server. I believe it is a problem with my parameter declaration. When I try to save the data, I get the following error: Line 1: Incorrect syntax near 'varchar'. My code is as follows (not everything because it is quite lengthy): Dim custom01 As String 'Contains the name of the column/field Dim sampleTable As String 'Contains the name of the table within SQL Server sampleUpdate = New SqlClient.SqlCommand("UPDATE " & sampleTable & " SET " & custom01 & " = @" & custom01, dataConnect) With sampleUpdate With .Parameters .Add("@" & custom01, SqlDbType.Varchar, 50, custom01) End With End With As I said, I can update the dataset fine, but when I try to up the dataset back into SQL Server, it crashes. Any thoughts would be greatly appreciated.

[Lost User]

ColdWaterBlue wrote: Dim sampleTable As String 'Contains the name of the table within SQL Server sampleUpdate = New SqlClient.SqlCommand("UPDATE " & sampleTable & " SET " & custom01 & " = @" & custom01, dataConnect) Where is the name of your table? You declare a string to hold the table but you did not give any table name to that string variable (according to the code). So your sampleTable variable would contain "". Try to give your table name and to the sampleTable variable before process the query.

---

A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office

[ColdWaterBlue]

For simplicity's sake, I did not include most of the code. The "sampleTable" variable is actually a global variable that houses the table name, but I included the Dim statement to show that it was a variable.