Question

如何把查询出来的sql结果填充到Spread

Answer 1

sql查询结果集在spread中显示：

举例如下：
System.Data.DataSet ds = new System.Data.DataSet();
DataTable name;
DataTable city;
name = ds.Tables.Add("Customers");
name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)), new DataColumn("ID", typeof(Int32))});
name.Rows.Add(new object[] {"Fielding", "William", 0});
name.Rows.Add(new object[] {"Williams", "Arthur", 1});
name.Rows.Add(new object[] {"Zuchini", "Theodore", 2});
city = ds.Tables.Add("City/State");
city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new DataColumn("State", typeof(string))});
city.Rows.Add(new object[] {"Atlanta", 0, "Georgia"});
city.Rows.Add(new object[] {"Boston", 1, "Mass."});
city.Rows.Add(new object[] {"Tampa", 2, "Fla."});

FarPoint.Web.Spread.ComboBoxCellType c = new FarPoint.Web.Spread.ComboBoxCellType();
DataTable dt;
ArrayList al = new ArrayList(ds.Tables[0].Rows.Count);
dt = ds.Tables[0];
Int32 i;
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
al.Add(dt.Rows[i][0]);
}
string [] s = (string[])al.ToArray(typeof(string));
c.Items = s;
FpSpread1.ActiveSheetView.Cells[0,0].CellType = c;

Answer 2

--这是临时变量表
declare @table table(a varchar(20),b varchar(20))
insert into @table(a) values('a')
--实际查询语句
select a,b from @table
--测试查询语句，当无数据时用0代替
select a=isnull(a,0),b=isnull(b,0) from @table