Import Data from CSV into Datatable - C# Discussion Boards

budala1232-Jun-09 4:19

2-Jun-09 4:19

I want to encrypt/decrypt some data with RSA. I have the private key (D and Modulus) and the public key (Exponent and Modulus) saved in text files.
When I tried to decrypt (encrypt data with private key) I tried to import RsaParameters with D and Modulus set to the values in the file and the other parameters set to null. On the Import method it throws a "Bad Data" Exception. It seems that I can only import RsaParameters when all of the parameters are set? Can I do it any other way?

Re: C# RSA

Ennis Ray Lynch, Jr.2-Jun-09 4:41

Ennis Ray Lynch, Jr.

2-Jun-09 4:41

Bad Data exception can occurs when your key is wrong. Your private key and modulus are binary data, perhaps they have been ASCII armoured in the text file?

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Re: C# RSA

Henry Minute2-Jun-09 4:43

Henry Minute

2-Jun-09 4:43

I think that the error you are getting might be related to the length of the data you are trying to encrypt.

RSA was designed for encrypting/decrypting cryptographic keys, not data. I cannot remember off the top of my head the max length, but if you plough through the MSDN Documentation, it is in there somewhere.

As I said at the start this is only a MIGHT BE, but given that RSA has this length problem you would be better off switching to another encryption provider now, rather than wait till it breaks before doing so.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: C# RSA

budala1232-Jun-09 5:18

budala123

2-Jun-09 5:18

No, the exception is thrown on the Import()-method, while importing the keys. I checked the keys also, they're all correct...
In fact this gives the error:

<br />
            RSACryptoServiceProvider provider1 = new RSACryptoServiceProvider();<br />
            RSAParameters p1 = provider1.ExportParameters(true);<br />
<br />
            RSAParameters p2 = new RSAParameters();<br />
            p2.D = p1.D;<br />
            p2.Modulus = p1.Modulus;<br />
<br />
            RSACryptoServiceProvider provider2 = new RSACryptoServiceProvider();<br />
            provider2.ImportParameters(p2);<br />

Re: C# RSA

Henry Minute2-Jun-09 5:32

Henry Minute

2-Jun-09 5:32

The only thing that strikes me as, possibly, odd about your code is the creation of p2. Why not simply re-use p1?

RSACryptoServiceProvider provider1 = new RSACryptoServiceProvider();
RSAParameters p1 = provider1.ExportParameters(true);

RSACryptoServiceProvider provider2 = new RSACryptoServiceProvider();
provider2.ImportParameters(p1);

Re: C# RSA

budala1232-Jun-09 6:02

budala123

2-Jun-09 6:02

Because all the parameters of p1 are set, and i want to simulate a situation where there are only the D and Modulus parameters set...

Re: C# RSA

Henry Minute2-Jun-09 6:08

Henry Minute

2-Jun-09 6:08

Ok.

I am afraid that I have now officially run out of talent on this topic. Sorry, but good luck! Smile | :)

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. Smile | :)

Badger | [badger,badger,badger,badger...]

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

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