110,530
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = ...;
List<double> u = new List<double>();
List<double> i = new List<double>();
dt.Rows.ToList()
.ForEach(x =>
{
u.Add(Convert.ToDouble(x["u"]));
i.Add(Convert.ToDouble(x["i"]));
});
double[] su = u.ToArray();
double[] si = i.ToArray();
...
public void ReadTable()
{
List<double> u = new List<double>();
List<double> i = new List<double>();
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection())
{
try
{
conn.ConnectionString = "Data Source=(local);Initial Catalog=UI;User ID=sa;Password=";
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "select * from sui";
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
conn.Open();
System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
u.Add(double.Parse(dr["u"].ToString()));
i.Add(double.Parse(dr["i"].ToString()));
}
dr.Close();
conn.Close();
}
}
catch
{
}
}
}