Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv) - C# Discussion Boards

Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv)

6-Dec-08 7:00

I'm importing data from a csv file and I need all the fields to be read in as text fields.

I have a zip code field that when I need to put in ZipCode+4(12345-6789) it throws an err because the field is interpreted as a int32 or some such.

I don't see any options anywhere to force the driver to make all the field text either. I thought this is possible, I'm pretty sure it would work with the Jet drivers if they were installed.

If they are installed, they are not showing up in the ODBC Data Source Administrator.

Connection.ConnectionString = 
                    string.Format(@"Dsn=CSV;dbq={0};defaultdir={0};driverid=27;fil=text;maxbuffersize=2048;pagetimeout=5", new FileInfo(openFileDialogGetCRDCSV.FileName).DirectoryName);

Wendelius6-Dec-08 7:40

Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv)

6-Dec-08 7:40

Perhaps this would help: Schema.ini File (Text File Driver)[^]

The need to optimize rises from a bad design.My articles[^]

Sunset Towers6-Dec-08 7:52

Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv)

6-Dec-08 7:52

That would almost work except the header names are subject to change. The file also comes in with column names with "." and it converts them to "#". I think I'm going to have to switch to a CSV parser of some kind.

Wendelius6-Dec-08 7:57

Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv)

6-Dec-08 7:57

Sunset Towers wrote:
header names are subject to change

That doesn't matter. You don't have to name the columns (set ColNameHeader to true) and if you do, it's the name you decide, not the name in the file.

Sunset Towers wrote:
The file also comes in with column names with "." and it converts them to "#".

Din't quite understand this.

The need to optimize rises from a bad design.My articles[^]

Sunset Towers6-Dec-08 8:19

Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv)

6-Dec-08 8:19

The column names are something like column.name which csv is coverting to column#name. Not a big deal.

I can set the column names as they move around also. It's weird and a pain but I'll have to find a different solution.

Wendelius6-Dec-08 8:27

Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv)

6-Dec-08 8:27

Okay, another option could be LINQ to TEXT and LINQ to CSV[^]

The need to optimize rises from a bad design.My articles[^]

Mycroft Holmes6-Dec-08 23:15

Mycroft Holmes

6-Dec-08 23:15

You may want to take a look at this CSV parser[^] and then use Bulkcopy to load the data into a table. I always use a staging table and a stored proc to do my ETL.

Never underestimate the power of human stupidity
RAH

Re: Making all columns text when using Microsoft Text Driver(*.txt, *.csv)

Sunset Towers6-Dec-08 23:30

6-Dec-08 23:30

Yeah that is a the route I had to take in the was just to get a csv parser.

Testing C# with xUnit

Jammer6-Dec-08 5:33

Jammer

6-Dec-08 5:33

Hi All,

I'm just trying to find some info on how to tell xUnit to output the results from a set of tests I've written for some C# code. Info seems really thin on the ground for this. Can anyone post some info/links on how to set this up?

Thanks,

Jammer
My Blog | Article(s)

C# serial Port

Karmendra Suthar6-Dec-08 5:05

Karmendra Suthar

6-Dec-08 5:05

Hi,

I have an MDI application, with five different child forms. (developing in Visual Studio 2008 C# windows Form Application)

I added Serial port to MDI Form.

How can I use that serial port instance (created on MDI Form) on a child Form?

Thanks
Karmu

Re: C# serial Port

Wendelius6-Dec-08 5:41

6-Dec-08 5:41

I think you should create methods for using serial port on MDI form and call them from the child form. You can find the MDI form from child form using child's MdiParent property.

The need to optimize rises from a bad design.My articles[^]

making alarm

Xmen Real 6-Dec-08 4:48

Re: making alarm [modified]

6-Dec-08 4:48

hi,
im trying to make an alarm that will just alert in a specified time lenght. Mean it will have 2 parts, First start Time and second End Time. Hope you got my question. I wrote code but it just work till end time is less than 00:00.

For example
If StartTime is 23:00:00 and EndTime is 23:59:00, it will work

but if StartTime is 23:00:00 and EndTime is 01:00:00, it wont

here is the code

        DateTime StartTime = new DateTime(1, 1, 1, 23, 52, 40);
        DateTime EndTime = new DateTime(1, 1, 1, 1, 01, 10);

//in TimerTick event

if (DateTime.Now.TimeOfDay.CompareTo(StartTime.TimeOfDay) > 0 && DateTime.Now.TimeOfDay.CompareTo(EndTime.TimeOfDay) < 0)
            {
//Code
MessageBox.Show("Came");
}

i know DateTime.Now.TimeOfDay.CompareTo(StartTime.TimeOfDay) returns 1 if the time is less than 00:00:00 and greater than the parameter TimeSpan else -1

but i'm not getting any idea since mind is very tired because of lots of proccess Frown | :(

i thought to place a bool variable when that time past but problem is that what if user open the pc when time is 1:00:00 then it wont work

any idea guys ?

thanks

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Alan N6-Dec-08 10:12

Alan N

6-Dec-08 10:12

Hi,
You are just being far too specific in your comparison. Just compare the DateTime values, i.e. the date and the time of day.

Something like this:

//Calculate time and date at the end of the desired period, 1 hour in this example
DateTime EndTime = DateTime.Now.AddHours(1);

//in TimerTick event
if (EndTime.CompareTo(DateTime.Now) < 0){
  //Code
  MessageBox.Show("Came");
}

[EDIT: My initial code fragment was rubbish. It make sense now! ]
Alan.

modified on Sunday, December 7, 2008 5:28 PM

Xmen Real 6-Dec-08 14:29

6-Dec-08 14:29

dude, you misunderstood my question. I want comparision in time not with date and time. I do not need date, just time.

for example :
if user open the computer between 23:00 - 01:00 then shows a message to him/her. but problem is 00:00 as i told in first post

Wendelius7-Dec-08 0:12

7-Dec-08 0:12

One way is to split the logic. Something like:

- if the end time > start time, simple check if current time is between start and end
- if the end time < start time it means that you're crossing midnight, then:

The need to optimize rises from a bad design.My articles[^]

Xmen Real 7-Dec-08 1:53

7-Dec-08 1:53

wo wo wo looks like it gonna work...

dude, i always get stucked when i reaches to 00:00 i dunno but brain got flush, something like this hehe well thanks dude

you deserve for a good rate Wink | ;)

Wendelius7-Dec-08 2:43

7-Dec-08 2:43

Xmen wrote:
thanks dude

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

Border Of Group Box

nagendra.vk6-Dec-08 4:10

nagendra.vk

6-Dec-08 4:10

Hi every one...can u help me in disabling the border of the group box

thnx in advance,
nagendra kumar Smile | :)

Xmen Real 6-Dec-08 4:53

6-Dec-08 4:53

well, i dont think its good idea to remove its border. You can try panel or just put controls above group box(not in groupbox) and just set its Visible prop. to False.

#realJSOP6-Dec-08 23:24

#realJSOP

6-Dec-08 23:24

If you set visible to false, everything it contains will also be invisible.

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Xmen Real 6-Dec-08 23:26

6-Dec-08 23:26

dude, read the post again

"just put controls above group box(not in groupbox)"