如何在C#中为SQL Server表创建Deedle数据帧
本文关键字:创建 Deedle 数据帧 Server SQL 中为 | 更新日期: 2023-09-27 18:00:56
我正试图从云上的SQL Server实例中填充Deedle数据帧,但遇到了一些问题。我正试图轻松地将表加载到Deedle Dataframe中。现在我只能打印表格了。
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using Deedle;
using DeedleCustomNamespace;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
namespace ConsoleApplication3
{
class Program
{
static void Main(string[] args)
{
string cs = "Server=somedb.database.windows.net;Database=somedb;User Id=SomeUser;Password=SomePassword;";
SqlConnection myConnection = new SqlConnection(cs);
try
{ myConnection.Open(); }
catch (Exception e)
{ Console.WriteLine(e.ToString()); }
try
{
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("SELECT * FROM Table1", myConnection);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
Console.WriteLine(myReader["Column1"].ToString());
Console.WriteLine(myReader["Column2"].ToString());
}
}
catch (Exception e)
{ Console.WriteLine(e.ToString()); }
try
{ myConnection.Close(); }
catch (Exception e)
{ Console.WriteLine(e.ToString()); }
}
}
}
namespace ConsoleApplication3
{
class Program
{
static void Main(string[] args)
{
string cs = "Server=somedb.database.windows.net;Database=somedb;User Id=SomeUser;Password=SomePassword;";
SqlConnection myConnection = new SqlConnection(cs);
try
{ myConnection.Open(); }
catch (Exception e)
{ Console.WriteLine(e.ToString()); }
try
{
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("SELECT * FROM Table1", myConnection);
myReader = myCommand.ExecuteReader();
var SomeDataframe = Frame.ReadReader(myReader);
SomeDataframe.Print();
}
catch (Exception e)
{ Console.WriteLine(e.ToString()); }
try
{ myConnection.Close(); }
catch (Exception e)
{ Console.WriteLine(e.ToString()); }
}
}
}