嗨，如何显示选定的下拉菜单项记录从SQL表到gridview? [英] hi how to show selected dropdown items record from sql table to gridview?

问题描述

hi，当我选择下拉项目时，如何显示并单击搜索按钮，然后从该项目中如何显示从sql表到gridview控件的记录..

例如:

dropdownlist conatains .. [shan]
如果我选择shan，我想将其记录显示到网格视图..如何显示?

hi how to show when i slect dropdowns perticular items and click search button and from that items how to show record from sql table to gridview control..

for example:

dropdownlist conatains..[shan]
if i select shan i want to show his records to grid view..how to show?

推荐答案

http://forums.asp.net/t/1431726.aspx [ http://www.asp. net/web-forms/tutorials/data-access/masterdetail/master-detail-filtering-with-a-dropdownlist-cs [

Hi,

http://forums.asp.net/t/1431726.aspx[^]

http://www.asp.net/web-forms/tutorials/data-access/masterdetail/master-detail-filtering-with-a-dropdownlist-cs[^]

hope this helps.

当您单击搜索按钮，然后将该项目作为
传递时

when you click on search button then pass this item as

protected DataTable GetAnnexRecord(string sPointId,DataTable dt)
    {
        DataView dv = dt.DefaultView;
        dv.RowFilter = "sPoint='" + sPointId + "'";
        DataTable dt1 = dv.ToTable();
        return dt1;
    }

现在该数据表绑定到gridview

now this datatable bind to gridview

这篇关于嗨，如何显示选定的下拉菜单项记录从SQL表到gridview?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！