请问..如何将从access2007 数据库中查询得到的多行符合条件的数据存入一个array??e.g."Select * from nameTable where 性别=M"有多行符合条件的记录..如何将这些记录中的数据都存入一个array中???..请尽量说明详细一些...C#新手求教..不胜感激~~~~
ArrayList al = new ArrayList(); System.Data.DataTable dtt = onlyDt("Select * from nameTable where 性别=M") for (int i = 0; i <= dtt.Rows.Count - 1; i++) { al.Add(dtt.Rows[i]["Name"].ToString()); }自己参照的改把
在下也知道应该用循环语句插入..但苦于对Access不熟悉..可否详细说明一下??..
和Sql的操作不是一样的么?取出来循环插入 /// <summary>
///
/// </summary>
/// <param name="condition">完整的sql</param>
/// <returns></returns>
public DataTable onlyDt(string condition)
{
conn = CoOp.GetSqlConnection();
coda = new OleDbDataAdapter(condition, conn);
try
{
DataSet fillds = new DataSet();
coda.Fill(fillds, "list");
GC.Collect();
return fillds.Tables["list"];
}
catch (Exception e)
{
DataTable dt = new DataTable();
GC.Collect();
return dt;
}
} public OleDbConnection GetSqlConnection()
{
string Connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + dbPath + ";Persist Security Info=True;Jet OLEDB:Database Password=smartcard";
OleDbConnection conn = new OleDbConnection(Connect);
return conn;
} dbPath 为你自己的数据库的路径
System.Data.DataTable dtt = onlyDt("Select * from nameTable where 性别=M")
for (int i = 0; i <= dtt.Rows.Count - 1; i++)
{
al.Add(dtt.Rows[i]["Name"].ToString());
}自己参照的改把