110,561
社区成员
发帖
与我相关
我的任务
分享
读取用这个方式得了
string connectionString = "Data Source=192.168.1.3;Initial Catalog=data;User ID=sa;password=sa;Integrated Security=False";
string queryString = "select top 1 aa,bb,cc from table";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
string s0 = reader[0].ToString().Trim(); //// "123,234,456,565,3423";
listBox1.DataSource = s0.Split(',');
}
}
finally
{
command.Dispose();
connection.Close();
}
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("name"));
string temp1 = "123,234,456,565,3423";
string[] data = temp1.Split(',');
foreach (string s in data) {
DataRow dr = dt.NewRow();
dr[0] = s;
dt.Rows.Add(dr);
}