c# 如何把图片中的sql数据库的数据保存成如下的二维数组:
int[,] x = new int[,] {{22,33,11},{11,22,33}};
c# 如何把图片中的sql数据库的数据保存成如下的二维数组:
int[,] x = new int[,] {{22,33,11},{11,22,33}};
SqlConnection conn = new SqlConnection(你的连接字符串);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select vo1, vo2, vo3 from 表", conn);
DataSet ds = new DataSet();
da.Fill(ds);
int[,] arr = new int[ds.Tables[0].Rows.Count(), 3];
for (int i = 0; i < ds.Tables[0].Rows.Count(); i++)
{
arr[i, 0] = int.Parse(ds.Tables[0].Rows[i]["vo1"].ToString());
arr[i, 1] = int.Parse(ds.Tables[0].Rows[i]["vo2"].ToString());
arr[i, 2] = int.Parse(ds.Tables[0].Rows[i]["vo3"].ToString());
}