在gridview上获取数据 [英] getting data on gridview
本文介绍了在gridview上获取数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
尝试从下拉列表中获取值并按下搜索按钮并在gridview上显示数据。下拉列表中的值为硬编码
// string searchTXt = GridView2.SelectedValue.ToString();
string query = SELECT * FROM ['ISB VAS Nodes $']其中id =' + DropDownList1 .SelectedValue + ';
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(query,connstring);
da.Fill(ds);
if (ds.Tables [ 0 ]。Rows.Count > 0 )
{
GridView2.DataSource = ds;
GridView2.DataBind();
}
解决方案
']其中id =' + DropDownList1.SelectedValue + ';
DataSet ds = new DataSet( );
SqlDataAdapter da = new SqlDataAdapter(query,connstring);
da.Fill(ds);
if (ds.Tables [ 0 ]。Rows.Count > 0 )
{
GridView2.DataSource = ds;
GridView2.DataBind();
}
trying to getting value from dropdownlist and press search button and show data on gridview.giving values on dropdownlist is hardcode
//string searchTXt = GridView2.SelectedValue.ToString();
string query = "SELECT * FROM ['ISB VAS Nodes$'] where id='"+DropDownList1.SelectedValue+"'";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(query, connstring);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
GridView2.DataSource = ds;
GridView2.DataBind();
}
解决方案
'] where id='"+DropDownList1.SelectedValue+"'"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(query, connstring); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { GridView2.DataSource = ds; GridView2.DataBind(); }
这篇关于在gridview上获取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文