How to delete a Row in a Text &amp;quot;CSV&amp;quot; file? [modified] - C# Discussion Boards

originSH3-Apr-07 0:38

originSH

3-Apr-07 0:38

If it's sql server then use the ADO.Net classes .Net provides.

Google: ado.net xml sql server [^]

srivatsan243-Apr-07 1:04

srivatsan24

3-Apr-07 1:04

I want to create a XML document in the filesystem out of the XML that is coming from the table column. The column is of type Xml. So how will i do it. I understand that we can use the ADO classes when oing an updation into the column. How to get it into the code from the database table column?

Srivatsan

kubben3-Apr-07 2:31

kubben

3-Apr-07 2:31

If your sql server is sql 2005 then there is an xml type in sql 2005 that you can use. If you are using sql 2000 then you have to convert your xml type in .net to a string and save it in a text column.

Hope that helps.
Ben

Reading from a network stream problem

originSH3-Apr-07 2:33

originSH

3-Apr-07 2:33

You start off by learning the C# syntax, then you get used to using the BCL (Base Class Libarys) and then you read up on the specifics of using ADO.Net.

You'll see that I gave a link to google with the appropriate keywords to help you find what you want.

If that's no good there are plenty of books out there on how to do this.

ctoma20052-Apr-07 21:44

ctoma2005

2-Apr-07 21:44

Hello. I have a big problem with network streams.
I have a network stream and, from time-to-time i have to check from messages received from the server.
My problem is that if i receive, for example, 2 messages from the server if I run in debug mode and stop just before the read, it reads both messages received. But if i run in release mode, i get only the first command(because there is a a small period of time between the two messages where stream.DataAvailable is set to false and it exits my loop).
How can I fix this problem? Because I don't know in advance how many messages the server will send.
This is my code:

<br />
if (stream.CanRead)<br />
{<br />
  while (stream.DataAvailable)<br />
  {<br />
   numberOfBytesRead = stream.Read(myReadBuffer, 0, myReadBuffer.Length);<br />
   myCompleteMessage =  String.Concat(myCompleteMessage, Encoding.ASCII.GetString(myReadBuffer, 0, numberOfBytesRead)); <br />
  }<br />
} <br />

CAN SOMEONE PLEASE HELP ME???
IT'S A B IG PROBLEM FOR ME, I'M NEW IN C#
THANKS IN ADVANCE!!

Re: Reading from a network stream problem

WillemM3-Apr-07 1:18

WillemM

3-Apr-07 1:18

I think you're better of building an Asynchronous Client Socket[^]

It involves a little more code, but it results in a more responsive application and it's easier to extend in the end.

WM.

What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson

How I can find out the assembly is COM server or not?

Vlad~2-Apr-07 21:30

Vlad~

2-Apr-07 21:30

I have an assembly file..
How I can find out(in run time) the assembly is COM server or not
(It's not registered by regasm.)?

Thanks.

How to delete a Row in a Text &amp;quot;CSV&amp;quot; file? [modified]

Khoramdin2-Apr-07 21:22

Khoramdin

2-Apr-07 21:22

Hello everyone,

I am developing a windows application in which it contains a ListView. I am showing the contents(rows) of the ListView from a csv file where each row represents a different data. I wish to have the ability of deleting any selected row. It appears the only options that I am getting from Streaming is "streamWriter.WriteLine" and "streamReader.ReadLine".

My finding so far is that the only way to delete a row from a text-based file is to rewrite that file without the particular row you want removed. So, I should delete the file, loop through the remaining rows in the ListView, and write them back out one by one. This is not something which I wish to do and I was wondering if there is any better way to get this done?

Can anyone be kind enough to tell how I can get this done?

Thank you very much and have a great day.

Khoramdin

-- modified at 3:31 Tuesday 3rd April, 2007

Re: How to delete a Row in a Text &amp;quot;CSV&amp;quot; file?

WillemM3-Apr-07 1:23

WillemM

3-Apr-07 1:23

Unfortunatly what you wan't isn't possible in a normal textfile or a CSV file for that matter.
The best option is to rewrite the whole file, depending on how large the file is.

It's generally not a good idea to use CSV files as the main data source for large quantities of data. Instead you can import the data in a database and keep it there. Then when you need a subset for export, you can always write something to export the data from the database to a CSV file.

WM.

What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson

Re: How to delete a Row in a Text &amp;amp;amp;quot;CSV&amp;amp;amp;quot; file? [modified]

Khoramdin3-Apr-07 5:35

Khoramdin

3-Apr-07 5:35

Helo Willem,

Thanx for the reply. My online search also led me to come to the same conclusion. The problem is that I am trying to make a Windows Application which requiers the least from the User system. In addition to that this data is going to be available locally even the user is not connected to internet. Therefore, the assumption is that the user has got no database facilities avaiable locally on thier computer and there is no remote database access.

fortunatly, the CSV file is not going to be very large (My estimation is 10Kbit maximum) which If I am not mistaken is not going to effect the respond of the Windows Application.

The only question that comes to my mind is that which way of the followinf I should use for this purpose?

1- Line by line (reading from one file and writing to another, modifying the data on the way).

2- In "bulk" (load everything into memory, modify the data structure, and write it out again).

Thank you very much for your help and have a great day.

Khoramdin

-- modified at 11:40 Tuesday 3rd April, 2007

Error on DataAdapter.Fill()

JacquesDP2-Apr-07 20:56

JacquesDP

2-Apr-07 20:56

Hi all, I am having problems with the following...

When I run the command dataAdapter.Fill(dataSet) i get the following error...

"Fill:SelectCommand.Connection property has not been initialized"

Any ideas why?

Thanks in advance

He who laughs last is a bit on the slow side

CPallini2-Apr-07 21:20

CPallini

2-Apr-07 21:20

A DataAdapter as to be associated with a Connection, this can be done in several ways, for instance (excerpt from David Sceppa’s ADO.NET book)

string strConn = "Provider=SQLOLEDB;Data Source=(local)\\NetSDK;" +
                 "Initial Catalog=Northwind;Trusted_Connection=Yes;";
OleDbConnection cn = new OleDbConnection(strConn);
string strSQL = "SELECT CustomerID, CompanyName FROM Customers";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

JacquesDP2-Apr-07 21:31

JacquesDP

2-Apr-07 21:31

I have all that in, but after taking a good look again I realized that I never opened the connection. Laugh | :laugh:

Thanks for the quick reply

He who laughs last is a bit on the slow side

sooreeagt2-Apr-07 22:41

sooreeagt

2-Apr-07 22:41

hi
just check the connection once.. i think connection string is not proper

thank u

Suresh.R

how to implement xmlDOm in c#

JacquesDP2-Apr-07 22:44

JacquesDP

2-Apr-07 22:44

That was the problem, I never opened the connection

He who laughs last is a bit on the slow side

sweetnallu2-Apr-07 20:26

sweetnallu

2-Apr-07 20:26

i don't know how to implement the xmlDOM concept in c# application.please tel me the concept and codings.

nalini

Christian Graus2-Apr-07 20:49

Christian Graus

2-Apr-07 20:49

using System.Xml

That's about it really. The DOM is implimented by the XmlDocument class.

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 )

Sathesh Sakthivel2-Apr-07 20:50

Sathesh Sakthivel

2-Apr-07 20:50

Hi Nalini try with this code. I hope this will help you.

<br />
using System;<br />
using System.Xml;<br />
<br />
namespace DomNodeList<br />
{<br />
  class Program<br />
  {<br />
    static void Main(string[] args)<br />
    {<br />
      XmlDocument doc = new XmlDocument();<br />
      doc.Load(@"D:\workjjf\scripts\xml\MajorKeys.xml"); //<path to XML here><br />
      XmlNodeList majorKeyList = doc.SelectNodes(@"/Root/MajorKey");<br />
      foreach (XmlNode majorKeyNode in majorKeyList)<br />
      {<br />
        XmlElement majorElement = majorKeyNode as XmlElement;<br />
        string majorAttValue = "<null>";<br />
        if (majorElement != null)<br />
        {<br />
          string attValue = majorElement.GetAttribute("att");<br />
          if (attValue != null)<br />
          {<br />
            majorAttValue = attValue;<br />
          }<br />
        }<br />
        Console.WriteLine(majorAttValue);<br />
        XmlNodeList minorKeyList = majorKeyNode.SelectNodes(@"MinorKey");<br />
        foreach (XmlNode minorKeyNode in minorKeyList)<br />
        {<br />
          XmlElement minorElement = minorKeyNode as XmlElement;<br />
          string minorAttValue = "<null>";<br />
          if (minorElement != null)<br />
          {<br />
            string attValue2 = minorElement.GetAttribute("att");<br />
            if (attValue2 != null)<br />
            {<br />
              minorAttValue = attValue2;<br />
            }<br />
          }<br />
          Console.WriteLine("\t" + minorAttValue);<br />
          XmlNodeList valueList = minorElement.SelectNodes("Value");<br />
          foreach (XmlNode valueNode in valueList)<br />
          {<br />
            Console.WriteLine("\t\t" + valueNode.InnerText);<br />
          }<br />
        }<br />
      }<br />
      Console.ReadLine();<br />
    }<br />
  }<br />
}<br />

Regards,

Satips.

Christian Graus2-Apr-07 21:21

Christian Graus

2-Apr-07 21:21

It's obviously not going to run, you haven't given him the Xml that it's trying to load.