C#

FirstPrevNext

Import Data from CSV into Datatable polishprogrammer2-Jun-09 4:16 polishprogrammer 2-Jun-09 4:16  "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=\"" + dir + "\\\";" + "Extended Properties=\"text;HDR=No;FMT=Delimited\""; I'm using the above connection, together with a SELECT * FROM file statement, to pull in data from a comma-delimited text file, where dir is the directory where the file is located and file is the name of the csv file. This works well for files that contain English characters only, but for any file that uses non-English (ASCII) characters, the expression fails. I have written the csv file using a StreamWriter with Encoding=UTF8 so the characters display fine when viewed in Notepad or Excel, but when pulled into the DataTable, the value in the table is blank. Is there some Extended Property that can be used to permit East Asian characters, say, to be displayed properly? Thanks. Re: Import Data from CSV into Datatable dan!sh 2-Jun-09 4:31 dan!sh 2-Jun-09 4:31  Does this[^] helps? जय हिंद Getting 530 error while downloading files from FTP avi_dadi20022-Jun-09 4:06 avi_dadi2002 2-Jun-09 4:06  Hi All, While downloading files from FTP server using WEBClient class, I'm able to download first file (while looping through all the files)to my local system after that i'm getting the error "The remote server returned an error: (530) Not logged in". The credentials are correct as the first file is getting downloaded successfully Following is the code FileInfo fi = new FileInfo(strFileName); if (!fi.Extension.ToLower().Equals(".csv")) return false; if (serverUri.Scheme != Uri.UriSchemeFtp) { return false; } // Get the object used to communicate with the server. using (WebClient request = new WebClient()) { //request.Proxy = null; //request.BaseAddress = serverUri.ToString(); // This example assumes the FTP site uses anonymous logon. string strUsername, strPassword; strUsername = this.FtpUserName; strPassword = this.FtpPassword; request.Credentials = new NetworkCredential(strUsername, strPassword); string strListeningDir = ""; strListeningDir = this.ListeningDirectory; strFileName = this.FileName; try { Logger.Write(serverUri.ToString()); newFileData = request.DownloadData(serverUri.ToString().Trim()); fileString = System.Text.Encoding.UTF8.GetString(newFileData); FileStream fs = new FileStream(strListeningDir + strFileName, FileMode.Create); fs.Write(newFileData, 0, newFileData.Length); Logger.Write("File copied to listening directory..."); fs.Close(); GC.Collect(); } catch (WebException e) { throw e; } } return true; Re: Getting 530 error while downloading files from FTP EliottA2-Jun-09 5:22 EliottA 2-Jun-09 5:22  1. Use the pre tags for your code. 2. What line do you get the exception on? Check out the CodeProject forum Guidelines[^] client/server application tek 20092-Jun-09 4:01 tek 2009 2-Jun-09 4:01  hi everyone I would like to know how to code a server to create an application in C # client / server. The database used is SQL server, it contains 7 tables. And more specifically how I can code a server in c # so that multiple users can simultaneously access and complete their treatment (addition, modification, deletion, printing, consulting, research) I hope to have an answer because it will determine my future work. Thank you in advance Re: client/server application dan!sh 2-Jun-09 4:20 dan!sh 2-Jun-09 4:20  tech.csharp wrote: multiple users can simultaneously access and complete their treatment Concurrency can be handled at the database level and google can provide a lot of help on it. tech.csharp wrote: addition, modification, deletion There is a huge namespace SQLClient dedicated for this purpose. Use the classes it has to offer. Here[^] is an article that can help you. जय हिंद Re: client/server application EliottA2-Jun-09 5:24 EliottA 2-Jun-09 5:24  I half expect a reply consisting of; "Thanks, but where r the codez." Check out the CodeProject forum Guidelines[^] Re: client/server application tek 20092-Jun-09 6:17 tek 2009 2-Jun-09 6:17  Thank you for your help, and I would like to know how I can insert my access code to database sql, for example customer identification (login and password in the fields of the table) Thank you once again Re: client/server application EliottA2-Jun-09 6:49 EliottA 2-Jun-09 6:49  Check out the SqlCommand class, and create a SQL connection using System.Data.SqlClient.SqlConnection class, don't forget to check out this link[^] for information on how to construct a connection string. Check out the CodeProject forum Guidelines[^] Re: client/server application tek 20092-Jun-09 22:06 tek 2009 2-Jun-09 22:06  Thank you for your help but I know how create a sql connection string but what I don't know is to manage the connection to a sql server database in a client/server application and any necessary treatment. Dependencies error while creating Setup file in C# Windows application Mads1152-Jun-09 3:07 Mads115 2-Jun-09 3:07  Hi I am getting this error while creating the setup file..... The following files may have dependencies that cannot be determined automatically. Please Confirm that all Dependencies have been added to the project. C:\windows\mscomm32.ocx how solve it... Please give me Solution THanks in advance Re: Dependencies error while creating Setup file in C# Windows application Ahmed Khallaf2-Jun-09 3:22 Ahmed Khallaf 2-Jun-09 3:22  your project depend on mscomm32.ocx and may be you have been taken this project copy and paste so you must add this tool(mscomm32.ocx) again Re: Dependencies error while creating Setup file in C# Windows application Mads1152-Jun-09 3:30 Mads115 2-Jun-09 3:30  Hi Sir I added it but the Result is Same... is there any other way to solve... Re: Dependencies error while creating Setup file in C# Windows application Searril2-Jun-09 4:55 Searril 2-Jun-09 4:55  Use the SerialPort control instead of mscomm32.ocx. how do I detect a mouse down in a DataGridView that is not over a cell? Dan Neely2-Jun-09 2:54 Dan Neely 2-Jun-09 2:54  basically I want to clear the selection and keep a context menu from coming up if the user right clicks in empty space beneath the last row. The MouseDown event fires before the CellMouseDown event so I can't have the latter set a flag to control the former. The former gives a mouse coordinate but I don't see a way to check if it's on a row or not. It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains. -- Pride and Prejudice and Zombies Re: how do I detect a mouse down in a DataGridView that is not over a cell? Jimmanuel2-Jun-09 3:00 Jimmanuel 2-Jun-09 3:00  As to this comment: dan neely wrote: I don't see a way to check if it's on a row or not there's the HitTest[^] method. You may find the example code in the docs useful. Re: how do I detect a mouse down in a DataGridView that is not over a cell? Dan Neely2-Jun-09 4:04 Dan Neely 2-Jun-09 4:04  Thanks. The only problem with kitchen sink classes is that intelligence isn't that helpful when it returns 10 zillion items. It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains. -- Pride and Prejudice and Zombies adding to a list maurimauri292-Jun-09 2:47 maurimauri29 2-Jun-09 2:47  Hi all, I am quite new to C# and I bumped into this issue and I cannot understand why it is happening. I have a list of objects of class1. class1 has, as a member variable a list of objects of class2, and class2 has as a member variable a list of objiects of class3. In my code I have to add some objects to the list of objects of class3 for the last element of the list of objects of class2 for one of the elements of the list of objects of class1. It seems it should be straight forward but i found a strange behaviour and maybe you clever people can help me make some sense out of it. I'll explain with an example: if the list of objects of class1 has 2 elements (ListClass1[0] and ListClass2[1]) and I do ListClass1[0].ListClass2[ListClass1[0].ListClass2.Length-1].ListClass3.Add(ObjClass3) at the end of this I find that the ObjClass3 has been added to ListClass1[1].ListClass2[ListClass1[1].ListClass2.Length-1].ListClass3 Why is that happening? Is there any way around this? Cheers Mauri Re: adding to a list Le centriste2-Jun-09 2:50 Le centriste 2-Jun-09 2:50  If I were you, I would rewrite that piece of code to make it more readable. Also, without the code for your classes, it is very difficult to figure out what is happening. Please format your code correctly using the <pre> and <code> tags. Re: adding to a list musefan2-Jun-09 2:53 musefan 2-Jun-09 2:53  Hmmmm, that is a strange one... my first though is that the objects stored in ListClass1 are refrences to the same object so changing one would alter them all. Can you confirm this is not the case? Life goes very fast. Tomorrow, today is already yesterday. Re: adding to a list 0x3c02-Jun-09 2:56 0x3c0 2-Jun-09 2:56  Perhaps ListClass[1] and ListClass[2] are pointing to the same object? If they're reference types, then assigning them to be equal to one another would have that effect, I think Between the idea And the reality Between the motion And the act Falls the Shadow Re: adding to a list maurimauri292-Jun-09 3:30 maurimauri29 2-Jun-09 3:30  now i feel daft. yes, that was the problem. Thanks guys, much appreciated. Mauri VERY URGENT!!!!!! musefan2-Jun-09 2:47 musefan 2-Jun-09 2:47  I URGENTLY NEED A POO, CAN SOMEBODY PLEASE DO IT FOR ME?!?! Life goes very fast. Tomorrow, today is already yesterday. Re: VERY URGENT!!!!!! EliottA2-Jun-09 2:49 EliottA 2-Jun-09 2:49  Does no one check the documentation[^] anymore?! Check out the CodeProject forum Guidelines[^] Re: VERY URGENT!!!!!! musefan2-Jun-09 2:55 musefan 2-Jun-09 2:55  Like I said, very urgent, no time to check the instructions. Life goes very fast. Tomorrow, today is already yesterday.

Last Visit: 31-Dec-99 18:00     Last Update: 13-Oct-24 13:24 Refresh ᐊ Prev1...4964496549664967496849694970497149724973 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.