Comments by Hawkeye101 (Top 32 by date)

Can you show me a example for this relevant code! i would really appreciate it!

Is it possible to do it using a variable???

Thanks but i dont need to read an external xml file i need to hard code the values and display them in a string list! thats it!

I mean for to handle with the XML file
i need to only use XElement when handling with the XML file!

@SAKryukov Any Help??

There wasnt any other way to interpret this question! Anyway ill try this! Thanks!

I updated the question just check a bit! :)
Is this format ok???

FileSystemWatcher watcher = new FileSystemWatcher();
watcher.Path = "yourpathhere";
watcher.NotifyFilter = NotifyFilters.LastAccess | NotifyFilters.LastWrite
| NotifyFilters.FileName | NotifyFilters.DirectoryName | CreationTime;
watcher.Filter = "*.csv"

Thanks!

Need a Help!

How do i write this data into a SQL database....
this is SQL query...

SELECT TOP 1000 [id]
,[code]
,[buying]
,[selling]
FROM [test].[dbo].[Currency]

This is the Code! i need to submit the [0] element to code column,[1] Element to buying column and [2] Element to Selling column.

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;


namespace ConsoleApplication10
{
class Program
{
static void Main(string[] args)
{
var reader = new StreamReader(File.OpenRead(@"c:\users\afshandc\documents\visual studio 2012\Projects\ConsoleApplication10\ConsoleApplication10\ex.csv"));
List<string> headers = new List<string>();

while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(',');

Console.WriteLine(values[0].ToString() + "," + values[1].ToString() + "," + values[2].ToString());
}

Console.ReadLine();

}

}

}

Thanks!!

Diddnt work mate!
This is my csv format!

USD,125.49,132
CAD,124.47,135.98
BHD,325.84,686.98
DKK,21.72,23.84
SEK,15.7,16.75
CHF,134.24,147.11
JPY,1.5493,1.6625
KWD,417.01,934.14
ZAR,11.14,28.18
NOK,21.24,23.35
HKD,15.97,17.06
OMR,316.59,670.88
QAR,33.76,71.14
SAR,27.78,58.62
AED,33.02,70.52
NZD,100.63,109.81
SGD,85.37,89.5
INR,0,3.0896
MYR,39.33,85.3
GBP,203.03,215.54
AUD,129.59,138.96
THB,3.3,7.16
BND,99.22,209.26
EUR,164.59,175.44
JOD,158.81,344.08
CNY,17.38,21.43

It didnt work! This is my csv format!

USD,125.49,132
CAD,124.47,135.98
BHD,325.84,686.98
DKK,21.72,23.84
SEK,15.7,16.75
CHF,134.24,147.11
JPY,1.5493,1.6625
KWD,417.01,934.14
ZAR,11.14,28.18
NOK,21.24,23.35
HKD,15.97,17.06
OMR,316.59,670.88
QAR,33.76,71.14
SAR,27.78,58.62
AED,33.02,70.52
NZD,100.63,109.81
SGD,85.37,89.5
INR,0,3.0896
MYR,39.33,85.3
GBP,203.03,215.54
AUD,129.59,138.96
THB,3.3,7.16
BND,99.22,209.26
EUR,164.59,175.44
JOD,158.81,344.08
CNY,17.38,21.43

I updates the question! Ok now i can Read the Excel file in the console window! Ill try writing it to the SQL database! Ill let u know if help is needed Thanks!

Thanks!

Any help??

Alright Sorry! Ill edit the question

Thanks ill check it out!

I didnt Except anyone to do my work! I did it using OLEDB but cannot get it done with this!

@manikandan Your example is for web application, i prefer Console or windows form application example! And i dont prefer to use other libraries only the ExcelDataReader v2.1 Library. Any help?

Thanks but i already got a solution! Appreciate your help! :)

It is not doing Homework! I tried something over and over again, but cldnt thats why i posted my code and asked for help! and yes there is lot more work to do!

Alright! :)

Thanks a lot!!!! :) :)

Yup Needed to get it perfectly as i wanted :( Thats the reason! Any help??

@midnight_ Thanks got it done! :)

Still ddnt work!Throws an XML exception unhanded error!!

This is My code but it isnt writing the info to the text document!
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Xml;



namespace ReadXMLfromFile
{
///

/// Summary description for Class1.
///

class Class1
{
static void Main(string[] args)
{
XmlTextReader reader = new XmlTextReader ("Visitors.xml");
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Element: // The node is an element.
Console.WriteLine (reader.Value);

break;
case XmlNodeType.Text: //Display the text in each element.
Console.WriteLine (reader.Value);
break;

}
}
Console.ReadLine();
var xmlContent = File.ReadAllText(@"C:\Users\Geeth\Desktop\First Project\ConsoleApplication1\ConsoleApplication1\Visitors.xml");
File.WriteAllText(@"C:\Users\Geeth\Desktop\First Project\ConsoleApplication1\ConsoleApplication1\Written XML.txt", xmlContent); }
}
}