в 15:31, 26 мая 2010

2010-05-26T15:31:19Z

Admin: 1 версия

2010-05-26T11:42:26Z

1 версия

Новая страница

==Read comma separated value into DataSet==

<source lang="csharp">
using System;
using System.Data;
using System.IO;
class Class1{
static void Main(string[] args){
DataSet myDataSet = GetData();
foreach (DataColumn c in myDataSet.Tables["TheData"].Columns){
Console.Write("{0,-20}",c.ColumnName);
}
Console.WriteLine();
foreach (DataRow r in myDataSet.Tables["TheData"].Rows)
{
foreach (DataColumn c in myDataSet.Tables["TheData"].Columns)
{
Console.Write("{0,-20}",r[c]);
}
Console.WriteLine();
}
}
private static DataSet GetData(){
string strLine;
string[] strArray;
char[] charArray = new char[] {","};
DataSet ds = new DataSet();
DataTable dt = ds.Tables.Add("TheData");
FileStream aFile = new FileStream("csv.txt",FileMode.Open);
StreamReader sr = new StreamReader(aFile);
strLine = sr.ReadLine();
strArray = strLine.Split(charArray);

for(int x=0;x<=strArray.GetUpperBound(0);x++) {
dt.Columns.Add(strArray[x].Trim());
}

strLine = sr.ReadLine();
while(strLine != null) {
strArray = strLine.Split(charArray);
DataRow dr = dt.NewRow();
for(int i=0;i<=strArray.GetUpperBound(0);i++) {
dr[i] = strArray[i].Trim();
}
dt.Rows.Add(dr);
strLine = sr.ReadLine();
}
sr.Close();
return ds;
}
}
// File: csv.txt
/*
1,2,3,4
5,6,7,8
*/

</source>

==This example will read a csv file into a dataset and save it back when you press button 1 ==

<source lang="csharp">

//This example code is from eran.rivlis at gmail.ru

DataTable dt = new DataTable();
private void Form1_Load(object sender, EventArgs e)
{
string conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\csv" +
@";Extended Properties=""Text;HDR=No;FMT=Delimited\""";
OleDbConnection conn = new OleDbConnection(conString);
OleDbDataAdapter da = new OleDbDataAdapter(@"Select * from table1.csv", conn);
da.Fill(dt);
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
StringBuilder sbCSV = new StringBuilder();
int intColCount = dt.Columns.Count;
foreach (DataRowView dr in dt.DefaultView)
{
for (int x = 0; x < intColCount; x++)
{
sbCSV.Append(dr[x].ToString());
if ((x + 1) != intColCount)
{
sbCSV.Append(",");
}
}
sbCSV.Append("\n");
}
using (StreamWriter sw = new StreamWriter(@"c:\csv\table1.csv"))
{
sw.Write(sbCSV.ToString());
}
}

</source>

← Предыдущая	Версия 15:31, 26 мая 2010
(нет различий)

Csharp/C Sharp/Database ADO.net/CSV - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия