List<string> result = new List<string>(); foreach (var row in ds.Tables[0].Rows) { result.Add(row["name"].ToString()); } return result;
var names = new List<string>(); foreach (DataRow row in ds.Tables[0].Rows) { names.Add(row[0].ToString()); } return names;
public List<string> getTitle(string tableName) { SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=.;Initial Catalog=Apriori;Integrated Security=True"; con.Open(); string sql = "select name from syscolumns where id=object_id('"+tableName+"')"; SqlCommand com = new SqlCommand(sql, con); SqlDataReader rd = com.ExecuteReader(); List<string> names = new List<string>(); while (rd.Read()) { names.Add(rd.GetString(0)); } return names; } 感谢楼上各位,完成了,帮助后面的人,这么多类实在不知道怎么用啊。
foreach (var row in ds.Tables[0].Rows)
{
result.Add(row["name"].ToString());
}
return result;
foreach (DataRow row in ds.Tables[0].Rows)
{
names.Add(row[0].ToString());
}
return names;
public List<string> getTitle(string tableName)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=.;Initial Catalog=Apriori;Integrated Security=True";
con.Open();
string sql = "select name from syscolumns where id=object_id('"+tableName+"')";
SqlCommand com = new SqlCommand(sql, con);
SqlDataReader rd = com.ExecuteReader();
List<string> names = new List<string>();
while (rd.Read())
{
names.Add(rd.GetString(0));
}
return names;
}
感谢楼上各位,完成了,帮助后面的人,这么多类实在不知道怎么用啊。