C#绑定数据

1.<asp:DropDownList

<asp:DropDownList ID="ddlclientType" runat="server" Width="140px" OnSelectedIndexChanged="ddlclientType_SelectedIndexChanged"
AutoPostBack="True">
</asp:DropDownList>

ListItem li = new ListItem();

li.Text = "-请选择-";
li.Value = "0";

dsAccount = new DataSet();
dsAccount = SqlHelper.GetDataSet(sql, "Table1", null); //string sql=select AccountTypeID,AccountType from ******

ddlclientType.DataSource = dsAccount;
ddlclientType.DataTextField = "AccountType";
ddlclientType.DataValueField = "AccountTypeID";
ddlclientType.DataBind();
ddlclientType.Items.Insert(0, li);

  

2.Winform :dataGridView

SQLiteDataAdapter Slda = new SQLiteDataAdapter("select  ***,str)//
                DataTable Dt = new DataTable();
                Slda.Fill(Dt);
                dataGridView1.DataSource = Dt;

  

posted @ 2019-01-03 16:02  敲代码带  阅读(1286)  评论(0编辑  收藏  举报