|
Hello,
I am trying to import a csv file. I know my code works because I have imported may files. but my problem is if the file name has a ' or a second . in the name I get a Syntax error in FROM clause.
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source={0};Extended Properties={1}Text;Excel 8.0;HDR=No;{2}",
System.IO.Path.GetDirectoryName(FileName), (char)34, (char)34);
conn.open();
string SchemeFile = System.IO.Path.Combine(System.IO.Path.GetDirectoryName(FileName),
"schema.ini");
if (File.Exists(SchemeFile))
File.Delete(SchemeFile);
using (FileStream SchemaStream = new FileStream(SchemeFile, FileMode.CreateNew))
{
using (StreamWriter writer = new StreamWriter(SchemaStream))
{
writer.AutoFlush = true;
writer.WriteLine("[" + System.IO.Path.GetFileName(FileName) + "]");
writer.WriteLine("ColNameHeader=False");
writer.WriteLine("Format=Delimited(,)");
writer.WriteLine("CharacterSet=ANSI");
writer.WriteLine("Col1=Code text width 255");
writer.WriteLine("Col2=Description text width 255");
writer.WriteLine("Col3=UnitOfMeasure text width 255");
writer.WriteLine("Col4=Price text width 255");
}
SchemaStream.Close();
}
CommandText = String.Format("SELECT * FROM {0}", System.IO.Path.GetFullPath(FileName));
OleDbDataAdapter da = new OleDbDataAdapter(CommandText, conn);
DataTable MyTable = new DataTable();
da.Fill(MyTable);
it crashes on the last line the da.fill
Any help would be wonderful
Thanks
|
|
|
|
|
Replace ' with '' in your string, otherwise SQL sees it as a constant string value, just like using double quotes when defining a string in code.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: Replace ' with '' in your string, otherwise SQL sees it as a constant string value, just like using double quotes when defining a string in code.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
I am sorry...
I forgot to mention.
I had already tried doing the FileName.replace("'", "''");
I have also tried making the entire FileName wrapped in " " and I have also tried making it so the entire path was wrapped in double quotes.
Any other thoughts?
|
|
|
|
|
I'd break it up so the path is built as a string first, then step through and look at what that string is to try to work out what's going wrong.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Just wanted to give everyone an update. I have figured out how to get a file to import if the file name has a single quote in the name. The way to do this is to put [] around the file name
string test = String.Format("Select * from [{0}]", System.IO.Path.GetFileName(FileName));
However having a period in the name is still breaking the code. I am still working at figuring out that and having the muliple quotes on the csv.
here is an example of the file
1234, "Bar, Energy", 2
1457, """Bar, Candy""", 1.50
the first line in the table would look like column a 1234, column b Bar, Energy, column c 2.00
but the second line should be column a 1457, column b "Bar, Candy", 1.50
But it is crashing the import saying Syntax error in from clause
|
|
|
|
|
Hi there!
I'm coding a windows application with VS 2005 Express edition.
The application has only a DataGrisView to show the Customers table of Northwind database. (Very simple)
When I try to add the database source for the DataGridView, and add a new connection in the wizard, I select the Northwind database, then I select "Use SQL Server Authentication" and set the "User Name" and "Password".
When I try to "Test Connection", the connection fail with the following message:
Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance.
If I use "Use Windows Authentication" (Integrated connection and authentication) there is no problem.
In the other hand, If I use the "SQL Server Management Studio", I can login with those user name and password in order to see Northwind database.
How can I use SQL Server Authentication in the application?
Thank you in advance.
--
Adrián Córdoba
|
|
|
|
|
Can you create a new ConnectionString and then use the same in your app. instead of using it at design time.
If this still does not work, then post your ConnectionString here. However, please make sure of these three points:
1) You are missing the User Instance=true clause, which tells SQL Express to spin up a separate process for the ASP.NET account, eliminating the need to explicitly grant permission to ASP.NET. Note that you should never grant sysadmin priviledge to the ASP.NET worker process, since that is a very priviledged permission level.
2) You should be using the |DataDirectory| variable in place of the fully-qualified path to the database, for example: |DataDirectory|\<mdf_filename>.MDF
3) MACHINENAME must be local when using SQL Express. Consider using .\SQLExpress for the machine name.
Best Regards,
Sam Xavier
www.componentone.com
|
|
|
|
|
OK, Thank you for your answer.
I tried by modifying the connection string in this way:
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Archivos de programa\Microsoft SQL Server\MSSQL.1\MSSQL\Data\northwnd.mdf";Persist Security Info=True;User ID=northwind;Password=PASSWORD;Connect Timeout=30;User Instance=True"
but I get the same connection error, when I run the application from "Start Debugging" button from Microsoft Visual C# 2005 Express Edition.
May be, Express Edition doesn't allow SQL Server Authentications.
Anyway, I don't know about SQL Server security, but I think when I deploy the application, I should use an "Application Role".
Do you know, where can I read about Application Roles, and how I have to use it?
Thank you, again.
--
Adrián Córdoba
|
|
|
|
|
Have you already modified machine.config file appropriately. If no, then please modify it like this:
All the providers' default configurations point them to use the connection string named "LocalSqlServer" which is defined in the "machine.config" file which lives in the framework config directory. In this file, you shoud modify your connectionstring like the following in the connection strings section:
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" .../>
Best Regards,
Sam Xavier
www.componentone.com
|
|
|
|
|
Hi,
I have a XML file, I want to apply a style sheet to it, and create a new XML file as per style sheet.
Does anyone have any ideas how to do it?
Is it possible?
Thanks!
|
|
|
|
|
zaboboa wrote: Does anyone have any ideas how to do it?
Yes
zaboboa wrote: Is it possible?
Yes
It makes no difference if you are generating HTML or XML or Java code or whatever, it all works the same way, the only thing that is different is the XSLT.
led mike
|
|
|
|
|
Thank you!
I know that the XSL file is different, that is what applies the transformation.
What I was looking for is the actual way of how to do it.
But I found the answer to my own question with XslTransform class.
Regards,
|
|
|
|
|
If anyone else has the same question with regards to XML and XSL, the XslTransform class will do the job.
Regards
|
|
|
|
|
Hi,
Anybody can help me to develop Integrated Voice Responce System using C#.
|
|
|
|
|
|
|
For example, if i VirtualProtectEx portion of memory of another program, with page guard or no access, how can i handle the exception when it will be raised, and get exception informations like registers value ect...?
I think to handle the exception my program would require enabled debug privileges which i know how to code but then i don't know how to set a top level exception filter.
I am still learning so any help would be great. 
|
|
|
|
|
Cptkli wrote: For example, if i VirtualProtectEx portion of memory of another program, with page guard or no access, how can i handle the exception when it will be raised, and get exception informations like registers value ect...?
You can't. Your code will never see the exception. This would require a technique called ".DLL Injection", which is something that C# alone cannot do because of the .DLL library requirements of the technique. This is a very advanced technique. Not something for beginners to try and pull off.
|
|
|
|
|
But i did read it's possible to replace the exception handler of a program without injecting any code with the SetUnhandledExceptionFilter api. It replaces the existing top-level exception filter of the targeted program. Is it wrong?
|
|
|
|
|
How can I determine if a text file was written using ANSI, Unicode or any other encoding?
|
|
|
|
|
|
I have a simple C# apllication that is transfering files from one machine to another. PC's are connected via VPN. Copy(path1,path2) function works very slow - about 1% of bandwidth. What can be the reason ?
I'd be very greatful for any help
|
|
|
|
|
Hi,
are you pushing or pulling, i.e. which of the paths is the local one?
I expect performance could be quite different, with pull much faster than push,
although I never tried it.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
What happens when you normally copy files? It is any faster?
|
|
|
|
|
Hello all.
I am trying to decide if it's better to have all my classes in one .cs file within my project(for instance 'MyClasses') and then just put all my classes inside that file. This would result in code like this.
MyClasses.MyClass x = new MyClasses.MyClass():
The alternative is obviously putting each individual class in it's own .cs file under the project. This would enable me to simply do
MyClass x = new MyClass();
What is the advantage/disadvantage of doing this both ways?
I do not want to build the classes in a separate project and import the dll. So I'm really just wondering about these 2 different ways of building the classes in my project.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
