Re: How to parse csv file into xml file - C# Discussion Boards

coolestCoder25-Apr-07 19:49

coolestCoder

25-Apr-07 19:49

DON345 wrote:
Iam facing a lot of problem to parse this file into XML file.

I am sure, everybody will have problems reading this file. BTW is this a single record or multiple records ? Also my understanding about CSV (Comma Seperated Values) is comma seperated fields and new line seperated records. Is the file in same format ? Or even this file can be called as CSV ?

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

DON34525-Apr-07 20:09

DON345

25-Apr-07 20:09

Hi Thank you for ur response,
actually that Data contains multi records.
I think this is one type of csv file,but seperated fields with pipe symbol.
field and value contains side by side.
please give me any solution.

Thanks&Regards
RENU

Rudolf Jan26-Apr-07 0:41

Rudolf Jan

26-Apr-07 0:41

I do not think anybody can help you with this. I suggest you to separate the file into individual records and fileds first. Yuo may use the String.Split() method for that purpose. Then you must find out what structure the file has. You should create the XML datatype and finally you can parse the data and convert it to XML. Don't expect us to do this for you.

DON34526-Apr-07 2:39

DON345

26-Apr-07 2:39

Thank you for your response,actually that data belongs to single record it contains 636 fields,then how can we parse the pipe symbols.can u send any sample code.

Thanks&Regards
RENU

save file as atext...using v.s 2003 !

Vikram A Punathambekar25-Apr-07 21:04

Vikram A Punathambekar

25-Apr-07 21:04

Cheers,
Vikram.

"But nowadays, it means nothing. Features are never frozen, development keeps happening, bugs never get fixed, and documentation is something you might find on wikipedia."
- Marc Clifton on betas.

Join the CP group at NationStates. Password: byalmightybob

Mouse over a control

Keshav V. Kamat25-Apr-07 18:37

Keshav V. Kamat

25-Apr-07 18:37

Hello All,

I need to find out if mouse is present over any control, say a button.
Please tell me how can I proceed on with this.

Keshav Kamat Smile | :)

India

Re: Mouse over a control

Nouman Bhatti25-Apr-07 19:04

Nouman Bhatti

25-Apr-07 19:04

one way to do it
u should write code in every control's MouseEnter event.

Re: Mouse over a control

Martin#25-Apr-07 20:16

Martin#

25-Apr-07 20:16

Hello,

Maybe this thread helps you out:
http://www.codeproject.com/script/comments/forums.asp?msg=1869977&forumid=1649&XtraIDs=1649&searchkw=Mouse+Position&sd=26+Jan+2006&ed=26+Apr+2007&stype=1#xx1869977xx[^]

All the best,

Martin

mr jets25-Apr-07 17:53

25-Apr-07 17:53

i wanna to make aprogram that can draw (ellips , line,..) but i have problems with the save & open ..thats apart of the code:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using System.Runtime.Serialization.Formatters.Binary;
using System.Runtime.Serialization;

namespace graphics_practis
{
///

/// Summary description for Form1.
///

public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.PictureBox pictureBox1;
private System.Windows.Forms.Button line;
private System.Windows.Forms.Button square;
private System.Windows.Forms.Button circle;
private System.Windows.Forms.Button ellipse;
private System.Windows.Forms.Button polygon;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Button ok;
private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem menuItem2;
private System.Windows.Forms.MenuItem menuItem3;
private System.Windows.Forms.MenuItem menuItem4;
private System.Windows.Forms.MenuItem menuItem5;

private BinaryFormatter formtter = new BinaryFormatter();
private FileStream str_reader;

private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;

private System.Windows.Forms.SaveFileDialog saveFileDialog1;
private System.Windows.Forms.OpenFileDialog openFileDialog1;
///

/// Required designer variable.
///

private System.ComponentModel.Container components = null;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
dr = new draw(this.pictureBox1);
}
static void Main()
{
Application.Run(new Form1());
}

private void menuItem4_Click(object sender, System.EventArgs e)
{
//saving
FileStream outStream=File.Create(saveFileDialog1.FileName);//To create text file
Stream streamWriter=new StreamWriter(outStream);
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
//opening
FileStream outStream=File.Create(saveFileDialog1.FileName);//To create text file
StreamWriter streamWriter=new StreamWriter(outStream);
}

the error...>>(cannot implicity convert type 'System.IO.StreamWritet'to 'System.IO.Stream'.

Christian Graus25-Apr-07 19:22

25-Apr-07 19:22

Oh, you're using VS2003. Then WriteAllText is not an option.

mr jets wrote:
cannot implicity convert type 'System.IO.StreamWritet'to 'System.IO.Stream'.

You keep posting this, there's no such thing as StreamWritet, is this really not a typo ?

System.IO.FileStream fs = new System.IO.FileStream("c:\\testing.txt", System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.Write, System.IO.FileShare.ReadWrite);

// create a stream writer
System.IO.StreamWriter sw = new System.IO.StreamWriter(fs, System.Text.Encoding.ASCII);

// write to file (buffer), where textbox1 is your text box
sw.Write("text");

// flush buffer (so the text really goes into the file)
sw.Flush();

// close stream writer and file
sw.Close();
fs.Close();

Perhaps the defaults for the params you're not passing in, are not the ones you need ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

mr jets26-Apr-07 5:22

26-Apr-07 5:22

i reaally appreciat ur time bro..okie ur code creating atext in c drive but it doesnt save the values of (x,y,..) remember bro my program like Paint ..so when i open the text it doesnt display my drawings (line,polygon,..)
thats my open code :
{
OpenFileDialog fileChooser=new OpenFileDialog();
DialogResult result = fileChooser.ShowDialog();
String fileName ; // name of file to containing data
// exit event handler if user clicked "cancel"
if (result == DialogResult.Cancel)
return;
// get specified file name
fileName= fileChooser.FileName;
//show error if user specified invalid file
if (fileName=="" || fileName==null)
MessageBox.Show("Invalid File Name ","Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
else
//creat Filestream to obtain read access to file
input = new FileStream(fileName,FileMode.Open,FileAccess.Read);

}

Regards ; Sigh | :sigh:

Christian Graus26-Apr-07 11:16

26-Apr-07 11:16

I'm not sure that I understand. I see you opening a file stream, but I don't see you reading anything, nor does the fact that you read the text have anything to do with seeing polygons ( there's a step in the middle where the text is intepreted to give you the data to show that )

mr jets26-Apr-07 13:00

26-Apr-07 13:00

thank god u back ..iam soo close to break my pc...u said
(there's a step in the middle where the text is intepreted to give you the data to show that )
can u just tell me what that step..iam baggginngg Christian D'Oh! | :doh:

Regards ;

Christian Graus26-Apr-07 22:08

Re: postback or DoPostback

26-Apr-07 22:08

I have no idea. Reading a text file is NOT going to do anything more than put some text into a piece of memory. For that to turn into ellipses, or whatever, you need to write some code that does that.

So, it depends. what is in this text file ? How did it get there ? How did you expect this text to become something on your screen ?

postback or DoPostback

karl170125-Apr-07 14:46

karl1701

25-Apr-07 14:46

I am attempting to programmatically call a hyperlink in a webbrowser control. The links are simply numbers 123456789… each corresponding to a new page to navigate to. The reference to each page is of the form “” where each page corresponds to a parameter as follows:

Page 1 is ---- javascript:__doPostBack('grdjo$_ctl1$_ctl1','')
Page 2 is ---- javascript:__doPostBack('grdjo$_ctl1$_ctl2','')
Page 3 is ---- javascript:__doPostBack('grdjo$_ctl1$_ctl3','')
…

The page uses the Javascript postback function below:

I am able to load the page using HttpWebRequest & HttpWebREsponse and have passed in the parameter to load the page as follows.

byte[] buffer = Encoding.ASCII.GetBytes("grdjo$_ctl1$_ctl6");

yet the page will not load the correct content, it keeps loading the first page of links. I know I am doing something wrong. Any ideas?

Thanks

Karl

karl170125-Apr-07 16:17

karl1701

25-Apr-07 16:17

Here is the code that does the postback...

string strParm1Val = "grdjo$_ctl1$_ctl6";
string strParm2Val = "";
string strPage = "http://somepage.com/frmjosearchp.aspx?GUID=www&keyword=&FOFID=400194";

string strData = "";

frd.Controls["resultsRichTextBox"].Text = "LOADING PAGE....";

byte[] buffer = Encoding.ASCII.GetBytes(strParm1Val + "&" + strParm2Val);
//Init
HttpWebRequest WebReq = (HttpWebRequest)WebRequest.Create(strPage);

//Our method is post, otherwise the buffer (postvars) would be useless
WebReq.Method = "POST";

//We use form contentType, for the postvars.
WebReq.ContentType = "application/x-www-form-urlencoded";

//The length of the buffer (postvars) is used as contentlength.
WebReq.ContentLength = buffer.Length;

//We open a stream for writing the postvars
Stream PostData = WebReq.GetRequestStream();

//Now we write, and afterwards, we close. Closing is always important!
PostData.Write(buffer, 0, buffer.Length);
PostData.Close();

//Get the response handle, we have no true response yet!
HttpWebResponse WebResp = (HttpWebResponse)WebReq.GetResponse();

//Let's show some information about the response
Console.WriteLine(WebResp.StatusCode);
Console.WriteLine(WebResp.Server);

//Now, we read the response (the string), and output it.
Stream Answer = WebResp.GetResponseStream();
StreamReader _Answer = new StreamReader(Answer);
strData = _Answer.ReadToEnd();
_Answer.Dispose();

//Console.WriteLine(_Answer.ReadToEnd());

//update controls on other forms
frd.Controls["ResultstextBox"].Text = strData;
frd.Controls["resultsRichTextBox"].Text = strData;
Uri siteUri = new Uri((string)strPage);
webBrowser1.Url = siteUri;

save & open file...

mr jets25-Apr-07 14:32

25-Apr-07 14:32

good morning ..every one !
ok..i wanna to make aprograme that can draw(ellipse,lines,..) but i have aproblems with saving & opening file ..my save code is:
FileStream outStream=File.Create(saveFileDialog1.FileName);//To create text file
StreamWriter streamWriter=new StreamWriter(outStream);
the error...>>(cannot implicity convert type 'System.IO.StreamWritet'to 'System.IO.Stream'.

plzz send me back...as fast as u can
Regards; Smile | :)

Re: save & open file...

Christian Graus25-Apr-07 14:43

25-Apr-07 14:43

mr jets wrote:
as fast as u can

I recommend not saying things like this when asking for free advice.

System.IO.File.WriteAllLines or System.IO.File.WriteAllText are the easiest way to create a text file.

Having said that, your code compiles just fine here. What line gives the error ?

Re: save & open file...

mr jets25-Apr-07 15:10

25-Apr-07 15:10

ok frist of all ..iam sorry bout my behavior but save & open its apart of very very huge program ..the dead line after 5 hours..so thank god i didnt kill my some one ..
ok the error at ...:
StreamWriter streamWriter=new StreamWriter(outStream);
plzz if u know more simple code..i will invite u to cinema..kidding!! OMG | :OMG:

Re: save & open file...

Christian Graus25-Apr-07 15:14