Sql Error - In The SqlCommand.ExecuteNonQuery

Hi





I have an asp.net [c#] page that queries a database which worked fine until I entered a new field called VSReferenceNumber.





The error message suggest there is something wrong with the sql string, but for the life of me I can't see why it is wrong.





I believe the problem is somewhere here:





SqlString += "VSReferenceNumber = '" + VSReferenceNumber.Replace("'", "''") + "', ";








Any help would be most appreciated.





Many thanks in advance





Regards





Miles








The Error is::





System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'VSReferenceNumber'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.workingdatagrid2_aspx.myDataGrid_Update(Object Sender, DataGridCommandEventArgs e) in C:Inetpubwwwrootuapworkingdatagrid2.aspx:line 64





Here's the code::





<script runat="server">





//public string ConnString = "server=atw_data01;database=UAP;uid=atw_cheryl.theobald;pwd=nudibranch;";


public string ConnString = "Server=(local); user id=sa;password=;initial catalog = UAP;";


void BindData()


{


//-- Using the Try statement, we attempt to connect to our


//-- database, execute a SqlDataAdapter to store our data,


//-- populate a dataset and then bind that dataset


//-- to our DataGrid.


try


{


SqlConnection SqlConn = new SqlConnection(ConnString);


string SqlString = "SELECT [uapID], [DealershipName], [AutoExchangeClientID], [VSReferenceNumber] FROM uapForm";


SqlDataAdapter SqlComm = new SqlDataAdapter(SqlString, SqlConn);


DataSet customerData = new DataSet();


SqlComm.Fill(customerData, "uapForm");





myDataGrid.DataSource = customerData;


myDataGrid.DataBind();





SqlConn.Close();


SqlComm.Dispose();


SqlConn.Dispose();


}





//-- If we are not able to connect, display a friendly error


catch (Exception e)


{


ErrorLabel.Text = "Not able to connect to database. See description below: <P>";


ErrorLabel.Text += e.ToString();


}





}





void myDataGrid_Update (object Sender, DataGridCommandEventArgs e)


{


//-- Take the data from each textbox in our editable item


//-- and assign that text to a string variable


string uapID = Convert.ToString(e.Item.Cells[0].Text);


string DealershipName = ((TextBox) e.Item.Cells[1].Controls[0]).Text;


string AutoExchangeClientID = ((TextBox) e.Item.Cells[2].Controls[0]).Text;


string VSReferenceNumber = ((TextBox) e.Item.Cells[3].Controls[0]).Text;








//-- Again, using the Try statement, attempt to connect to our database


//-- and make an update with the data from our datagrid


SqlConnection SqlConn = new SqlConnection(ConnString);


try


{


SqlConn.Open();


string SqlString = "UPDATE uapForm ";


SqlString += "SET DealershipName = '" + DealershipName.Replace("'", "''") + "', ";


SqlString += "AutoExchangeClientID = '" + AutoExchangeClientID.Replace("'", "''") + "' ";


SqlString += "VSReferenceNumber = '" + VSReferenceNumber.Replace("'", "''") + "', ";


SqlString += " WHERE uapID = '" + uapID + "'";


SqlCommand SqlComm = new SqlCommand(SqlString, SqlConn);


SqlComm.ExecuteNonQuery();


SqlConn.Close();


SqlComm.Dispose();


SqlConn.Dispose();


}





//-- If for some reason we cannot connect, display a friendly error.


catch (Exception exc)


{


ErrorLabel.Text = "Not able to connect to database. <br>Please See description below:<P> <P>";


ErrorLabel.Text += exc.ToString();


}





//-- Remove the edit focus


myDataGrid.EditItemIndex = -1;


//-- Rebind our datagrid


BindData();


}





void myDataGrid_Cancel(object Sender, DataGridCommandEventArgs e)


{


//-- Remove the edit focus


myDataGrid.EditItemIndex = -1;


//-- Rebind our datagrid


BindData();


}





void myDataGrid_Edit(object Sender, DataGridCommandEventArgs e)


{


//-- Set the edit focus to the item that was selected


myDataGrid.EditItemIndex = (int) e.Item.ItemIndex;


//-- Rebind our datagrid


BindData();


}





void Page_Load (object Sender, EventArgs e)


{


//-- If the page is not posting back, bind our datagrid


if (!Page.IsPostBack)


{


BindData();


}


}





</script>