帮忙优化个函数!更ADO.NET有关得!
zmy2k 2004-04-24 05:06:17 private DataTable query_table(int id)
{
SqlDataAdapter adapter = new SqlDataAdapter("select * from relation_view where id="+id,
"server=devserver;database=treeview;uid=sa;pwd=elara");
DataSet ds =new DataSet();
adapter.Fill(ds);
DataTable table = ds.Tables[0];
foreach (DataRow row in table.Rows)
{
this.table_name = System.Convert.ToString(row["rel_map_name"]) ;
}
//Response.Write("<script>alert('"+this.table_name+"')</script>");
SqlDataAdapter adapter_parent = new SqlDataAdapter("select name from system_menu where parentid=0 and id <(select id from relation_view where id="+id+")",
"server=devserver;database=treeview;uid=sa;pwd=elara");
DataSet ds_parent =new DataSet();
adapter_parent.Fill(ds_parent);
DataTable table_parent = ds_parent.Tables[0];
foreach (DataRow row_parent in table_parent.Rows)
{
this.petro_name = System.Convert.ToString(row_parent["name"]) ;
}
//Response.Write("<script>alert('"+this.petro_name+"')</script>");
//System.Data.DataTable table_detail = new
if (this.table_name != null )
{
}
else
{
this.table_name ="yqc";
}
SqlDataAdapter adapter_detail = new SqlDataAdapter("select * from sde."+this.table_name+" where ssdwmc='"+this.petro_name+"'",
"server=devserver;database=petro;uid=sa;pwd=elara");
DataSet ds_detail =new DataSet();
adapter_detail.Fill(ds_detail);
DataTable table_detail = ds_detail.Tables[0];
//}
return table_detail;
}
上面得函数主要是实现得功能是:根据输入得参数从TREEVIEW库中查询出"this.petro_name","this.table_name"
再组合成SQL语句,从数据库PETRO中查询满足条件得数据入DATAGRID
问题一:帮忙优化下主要都ADO.NET方面;
问题二:
private void Page_Load(object sender, System.EventArgs e)
{
if (Request.QueryString["type"]!=null && !IsPostBack)
{
this.list_id = System.Convert.ToInt16(Request.QueryString["type"]);
this.DataGrid1.DataSource =query_table(this.list_id);
this.DataGrid1.DataBind();
}
}
数据绑定到DATAGRID后,分页也设置了,看到得分页得提示"1,2,3,..."
但点了没有翻页.怎么回事?