动态填充选择框

最新推荐文章于 2019-03-07 13:51:06 发布

cgj4750014

最新推荐文章于 2019-03-07 13:51:06 发布

阅读量354

点赞数

分类专栏： ASP.NET 文章标签： dataset datagrid server import object string

本文链接：https://blog.csdn.net/cgj4750014/article/details/2880963

版权

ASP.NET 专栏收录该内容

26 篇文章 0 订阅

订阅专栏

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

SqlConnection myConnection;

    protected void Page_Load(Object Src, EventArgs E)
    {
        myConnection = new SqlConnection("server=(local)//NetSDK;database=pubs;Trusted_Connection=yes");

        if (!IsPostBack)
        {
            SqlDataAdapter myCommand = new SqlDataAdapter("select distinct State from Authors", myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds, "States");

            MySelect.DataSource= ds.Tables["States"].DefaultView;
            MySelect.DataBind();
        }
    }

    public void GetAuthors_Click(Object sender, EventArgs E)
    {
        String selectCmd = "select * from Authors where state = @State";

SqlConnection myConnection = new SqlConnection("server=(local)//NetSDK;database=pubs;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd, myConnection);

myCommand.SelectCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.NVarChar, 2));
myCommand.SelectCommand.Parameters["@State"].Value = MySelect.Value;

DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");

        MyDataGrid.DataSource= ds.Tables["Authors"].DefaultView;
        MyDataGrid.DataBind();
    }

</script>

<h3><font face="宋体">对 DataGrid 控件的动态参数化选择</font></h3>

选择州:

    <ASP:DataGrid id="MyDataGrid" runat="server"
      Width="700"
      BackColor="#ccccff"
      BorderColor="black"
      ShowFooter="false"
      CellPadding=3
      CellSpacing="0"
      Font-Name="宋体"
      Font-Size="8pt"
      HeaderStyle-BackColor="#aaaadd"
      EnableViewState="false"
    />

</form>

</body>
</html>

cgj4750014

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
动态填充选择框

SqlConnection myConnection; protected void Page_Load(Object Src, EventArgs E) { myConnection = new SqlConnection("server=(local)//NetSDK;database=pubs;Trusted_Connection=yes")
复制链接

扫一扫