C# Discussion Boards - CodeProject

ndeza1-Jun-09 1:18

1-Jun-09 1:18

Hi All,

I have an application that reads .csv data. My problem is that the is a value that is not read, it will read the number before the comma, but this is one number.

How do i make the app read the full number, e.g.: 1,093?

if (_lineItem == 12)
{
// the rows that will be added into the
// specified columns
dt.Rows.Add(new object[] { _dateParse, _casinoname, _line[3].Replace("\"", "").Replace("," , "")});
}
_lineItem++;

Thank you,

Re: Comma Delimted Windows Application

dan!sh 1-Jun-09 1:25

dan!sh

1-Jun-09 1:25

Can you post sample data from your csv file?
And do you have any idea how large the number would be ie minimum or maximum value?

जय हिंद

Re: Comma Delimted Windows Application

ndeza1-Jun-09 2:21

ndeza

1-Jun-09 2:21

By sample you mean the fileds that is going to the app?

If so here is the data.

Day Visitors
Sunday, May 3, 2009 1,245

The app reads the Visitors Colomn.

Re: Comma Delimted Windows Application

musefan1-Jun-09 2:25

musefan

1-Jun-09 2:25

ok that does not look like a CSV to me. Are you sure it's not tab delimited? If you want to parse that data i would suggest you split it using the index of the forth space value, which if that is all the data you have per line you can use LastIndexOf...

string visitors = line.Substring(line.LastIndexOf(' '));

...something like that anyway

Life goes very fast. Tomorrow, today is already yesterday.

Re: Comma Delimted Windows Application

Dave Kreskowiak1-Jun-09 5:22

Dave Kreskowiak

1-Jun-09 5:22

Do you know what CSV stands for?? Comma Seperated Values. So, if you put numbers formatted with commas in them into the CSV file, the reader will interpret it as two seperate values. You will have to jump through some custom written parsing logic that you have to write to detect this situation and reparse the line correctly. Or, go back to the export application as have it use a different delimiter, such as a Tab character, or not to format the numbers with commas.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Comma Delimted Windows Application

AhsanS1-Jun-09 1:27

AhsanS

1-Jun-09 1:27

Use Excel object in c# to read data from csv files. If there are fields that have comma in them, then they must be in double quotes.

Ahsan Ullah
Senior Software Engineer
MCTS 2.0

How can I read this xml?

Mogaambo1-Jun-09 0:32

Mogaambo

1-Jun-09 0:32

<fres:feinsearchresponse xmlns:fres="http://api.feinsearch.com/apiresponse">
- <fres:searchresults>
- <fres:searchresult>
<EIN>320095501</EIN>
</fres:searchresult>
</fres:searchresults>
</fres:feinsearchresponse>

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

Re: How can I read this xml?

dan!sh 1-Jun-09 0:34

dan!sh

1-Jun-09 0:34

Using eyes and brain.

I think you would like to rephrase your question.

जय हिंद

Rajdeep.Net[^] is NOT from India. Proof.[^]

Re: How can I read this xml?

Mogaambo1-Jun-09 0:43

Mogaambo

1-Jun-09 0:43

I mean how can i parse it.,

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

Re: How can I read this xml?

dan!sh 1-Jun-09 0:46

dan!sh

1-Jun-09 0:46

One simple Google search returned these[^] many results. Are none of them fitting your needs?

जय हिंद

Re: How can I read this xml?

Mogaambo1-Jun-09 0:49

Mogaambo

1-Jun-09 0:49

Actually it is output from a webservice but now i want to parse it. how do i ?

is this will work

XmlTextReader reader = new XmlTextReader("C:\\links.xml");
while (reader.Read())
{
XmlNodeType nodeType = reader.NodeType;
switch (nodeType)
{
case XmlNodeType.Element:
Console.WriteLine("Element name is {0}", reader.Name);
if (reader.HasAttributes)
{
for (int i = 0; i < reader.AttributeCount; i++)
{
reader.MoveToAttribute(i);
Console.WriteLine("Attribute is {0} with Value {1}: ", reader.Name, reader.Value);
}
}
break;
case XmlNodeType.Text:
Console.WriteLine("Value is: " + reader.Value);
break;
}
}

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

Re: How can I read this xml?

PandemoniumPasha1-Jun-09 1:17

PandemoniumPasha

1-Jun-09 1:17

Mogaambo wrote:
is this will work

you'll never know until you've tried it!

regards

Re: How can I read this xml?

PandemoniumPasha1-Jun-09 1:20

PandemoniumPasha

1-Jun-09 1:20

d@nish wrote:
Using eyes and brain.

mogaambo khush nahin huwa Poke tongue | ;-P

regards

Re: How can I read this xml?

0x3c01-Jun-09 0:42

0x3c0

1-Jun-09 0:42

System.Xml.Linq.XDocument
System.Xml.XmlDocument

Your question is immensely vague. It could cover any subject. Please, be precise

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Regarding the tool for finding functions and decalaration syntax in windows dll

AmmySA1-Jun-09 0:27

AmmySA

1-Jun-09 0:27

Hi to all

I was interested in listing the sql servers available.
I found some code " using System.Runtime.InteropServices; "

Code is used like that for using windows dll.
For that we need to define the method that we want to use
as follows :

[DllImport("odbc32.dll")]
private static extern short SQLAllocHandle(
short hType,
IntPtr inputHandle,
out IntPtr outputHandle);

So I want to know that is there any tool to find the declaration of the functions available in the DLL. Please lemme know how can I find the tool to do the same ?

If I use IDSAM then it gives the same for .NET libraries only not for windows library.

Thanks in Avdvance

Re: Regarding the tool for finding functions and decalaration syntax in windows dll

dan!sh 1-Jun-09 0:33

dan!sh

1-Jun-09 0:33

Not 100% sure.

1. You MUST know the programming language in which code was written for the DLL.
2. Dumpbin.exe[^] does that. Never used it though.

जय हिंद

Rajdeep.Net[^] is NOT from India. Proof.[^]

Re: Regarding the tool for finding functions and decalaration syntax in windows dll

Rajesh Anuhya1-Jun-09 0:41

Rajesh Anuhya

1-Jun-09 0:41

This may Help You

http://www.google.co.in/search?source=ig&hl=en&rlz=1G1GGLQ_ENIN304&=&q=dependency+walker&btnG=Google+Search&meta=lr%3D[^]

Rajesh B --> A Poor Workman Blames His Tools <--

Re: Regarding the tool for finding functions and decalaration syntax in windows dll

Schmuli1-Jun-09 2:58

Schmuli

1-Jun-09 2:58

Have you thought about using built-in functionality available in the .NET framework, without having to P/Invoke first?
In the System.Data.Sql namespace (in the System.Data dll), there is a SqlDataSourceEnumerator class, that, "Provides a mechanism for enumerating all available instances of SQL Server within the local network."

Schmuli.

Re: Regarding the tool for finding functions and decalaration syntax in windows dll

terradtc1-Jun-09 8:57

terradtc

1-Jun-09 8:57

To see what functions are available you might be able to use the built in function of Visual studio, but it does depend on how the dll has been built, I would try that first though because its the easiest way.

There's also depends, it allows you to see whats going on in the dll http://www.dependencywalker.com/[^]

passing textbox value one form to another form..

Mads1151-Jun-09 0:11

Mads115

1-Jun-09 0:11

Hi
I am creating a windows application, it has two Forms one is Login Form which has two textBox Control for user name and password.....
i want to display his username in the Second Form label Control.....
Please give Some idea

Thanks in advance

sorry

Hema Bairavan1-Jun-09 0:15

Hema Bairavan

1-Jun-09 0:15

hoh sorry..

i am working in WPF .net 3.5.
i was replied in that mood. it will work there..

extremly sorry mads115..

here better u may can use that in constructors, or by giving in the properties or in the public string and all

modified on Monday, June 1, 2009 7:04 AM

Re: passing textbox value one form to another form..

Mads1151-Jun-09 0:48

Mads115

1-Jun-09 0:48

Hi iam getting this error near label1
'WindowsApplication1.Form2.label1' is inaccessible due to its protection level'

Form2 newform = new Form2();
newform.label1.Text = this.textBox1.Text;

Re: passing textbox value one form to another form..

N a v a n e e t h1-Jun-09 1:02

N a v a n e e t h

1-Jun-09 1:02

Colin has an article on the subject - Passing Values between Forms in .NET 1.x with C# and VB.NET examples[^]

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: passing textbox value one form to another form..

DaveyM691-Jun-09 1:04

DaveyM69

1-Jun-09 1:04

You will as the controls are private - which is as they should be.
Better to create your own public properties and in the setters, validate the value if neeeded and uptdate the controls from there.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: passing textbox value one form to another form..

N a v a n e e t h1-Jun-09 1:01

N a v a n e e t h

1-Jun-09 1:01

Hema Bairavan wrote:
form2 newform = new form2();
newform.label1.text = this.textbox1;
newform.label2.text = this.textbox2;

WOW! That's really bad.

Navaneeth

How to use google | Ask smart questions

Last Visit: 31-Dec-99 18:00 Last Update: 7-May-24 11:05

Refresh

ᐊ Prev 1...4967 4968 4969 497049714972 4973 4974 4975 4976 Next ᐅ

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