Click here to Skip to main content
15,924,367 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
Syntax error in FROM clause.
this error yellow `var reader = commandSourceData.ExecuteReader();

     const string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myphonebook.mdb";
            const string connectionStringDest = @"server=ahmad-pc\anfd;database = phonebook;Integrated Security = true";
            using (var sourceConnection =new OleDbConnection(connectionString))
            {
                sourceConnection.Open();

                var commandSourceData = new OleDbCommand("SELECT name,family FROM number;", sourceConnection);
                var reader = commandSourceData.ExecuteReader();

                using (var destinationConnection = new SqlConnection(connectionStringDest))
                {
                    destinationConnection.Open();

                    using (var bulkCopy = new SqlBulkCopy(destinationConnection))
                    {
                        bulkCopy.DestinationTableName ="dbo.profile";

                        try
                        {
                            bulkCopy.WriteToServer(reader);
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine(ex.Message);
                        }
                        finally
                        {
                            reader.Close();
                        }
                    }
                }
            }
Posted
Comments
joshrduncan2012 8-Apr-13 12:29pm    
What is your question?
zxo004 8-Apr-13 12:30pm    
Syntax error in FROM clause.
this error yellow `var reader = commandSourceData.ExecuteReader();
joshrduncan2012 8-Apr-13 12:32pm    
If it's this:
SELECT name,family FROM number;
Try taking out the semicolon.
Richard C Bishop 8-Apr-13 12:34pm    
I answered it and gave you credit in order to get it out of the unanswered list.
zxo004 8-Apr-13 12:38pm    
not work.

1 solution

As joshrduncan2012 noted, remove the semicolon from the end of your select statement.

Update:
using (var sourceConnection =new OleDbConnection(connectionStringDest))
 
Share this answer
 
v2
Comments
joshrduncan2012 8-Apr-13 12:35pm    
Thanks Rich!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900