C# Discussion Boards - CodeProject

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

Sunset Towers

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.

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

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

Sunset Towers

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)"

How to let the application work with plugins?

#realJSOP6-Dec-08 23:26

#realJSOP

6-Dec-08 23:26

You're going to have to paint the border yourself.

It might be better to use a Panel control instead of a GroupBox if you want the container functionality but without the border.

softwarejaeger6-Dec-08 4:06

softwarejaeger

6-Dec-08 4:06

Hi,

how can i let my application work with plugins (i mean self-written plugins only for that application). I know i can do this with "Reflection", but how can i work with plugins, which should work on mac, linux and so on? Something like the Widgets/Gadgets in Windows-Sidebar, where i have a file, which is a zip-file where the code and so on is inside? How does something like that works?

Has anybody a idea how to do this? Well, i don't want to create a "new programming language" for this plugins, the most plugins like this use javascript, but first, how do i run them? How can i use individual Functions and so on?

Thanks

Re: How to let the application work with plugins?

Marcelo Emmerich7-Dec-08 6:27

Marcelo Emmerich

7-Dec-08 6:27

the easy way to do this is to add an instance variable of the WebBrowser class and let it execute a page containing the JavaScript. See the sample code for WebBrowser.ObjectForScripting on MSDN:

WebBrowser.ObjectForScripting

This method works fine as long as you can host the WebBrowser control inside a form in your application. Regarding the packaging of your plugins, personally I like the widget concept (as I have to deal with it on a daily basis for a project I am working on). A widget is basically a ZIP file with a certain structure and a manifest file. The manifest file (called config.xml if you follow the w3c standards) points to the main HTML file to execute.

Let me know if you need more help or want more thoughts regarding this.

Cheers,

Marcelo

--
Marcelo Emmerich
Software Development - Computer Graphics - Mobile Computing
http://bytethings.blogspot.com

Re: How to let the application work with plugins?

softwarejaeger9-Dec-08 20:02

softwarejaeger

9-Dec-08 20:02

Hi,

ok many thanks, but is it possible not to work with the WebBrowser-Object? Maybe with HTMLDocument or an other System like WebKit or else? And is it maybe possible to start events from a object in the HTML from my code? I mean, if i click a button in my Application, i want that the HTML-Page is running a specified js-function.

Re: How to let the application work with plugins?

softwarejaeger10-Dec-08 1:04

softwarejaeger

10-Dec-08 1:04

Another idea!...

is it possible to embed the javascript-files, classes and so on into my own project? i mean, that they use my classes and functions and i can use their functions, classes, objects and so on?

error opening excel sheet in c#

emilio_ts6-Dec-08 3:32

emilio_ts

6-Dec-08 3:32

i'm trying to open an existing excel worksheet. my code is:

Microsoft.Office.Interop.Excel.Application excelApp;
Microsoft.Office.Interop.Excel.Workbook excelWorkbook;
Microsoft.Office.Interop.Excel.Worksheet ExlWrkSheet;
private object Opt = Type.Missing

excelApp = new ApplicationClass();

excelWorkbook = excelApp.Workbooks.Open("..//..//Data.xls", Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt, Opt);

on the last line i get an exception that he cannot find the file.
i placed the file in the project directory.
i tried also "Data.exl" path when the file is placed in the debug directory, it didn't helped.

what am i doing wrong ?

Re: error opening excel sheet in c#

Wendelius6-Dec-08 3:53