ASPxListEdit.DataSourceID Property

Specifies the ID of the data source control from which the editor gets data items.

Assembly : DevExpress.Web.v25.2.dll

Declaration

C#
VB.NET

csharp

public override string DataSourceID { get; set; }

Public Overrides Property DataSourceID As String

Property Value

Type	Description
String

The ID of the data source control.

Remarks

This property is a wrapper of the ListEditProperties.DataSourceID property.

Design Time

Add ASPxListBox to the form.
In design mode, invoke the control’s smart tag menu and select the <New data source…> command.
Choose a data source type and configure its options:
Specify the ASPxListBox.TextField and ASPxListBox.ValueField properties.

The resulting code:

ASPX

aspx

<form id="form1" runat="server">
  <dx:ASPxListBox ID="ASPxListBox1" runat="server" DataSourceID="SqlDataSource1" TextField="ShipCountry" ValueField="OrderID">
  </dx:ASPxListBox>
  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
    DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @OrderID"
    InsertCommand="INSERT INTO [Orders] ([ShipCountry]) VALUES (@ShipCountry)"
    SelectCommand="SELECT [OrderID], [ShipCountry] FROM [Orders]"
    UpdateCommand="UPDATE [Orders] SET [ShipCountry] = @ShipCountry WHERE [OrderID] = @OrderID" >
    <DeleteParameters>
      <asp:Parameter Name="OrderID" Type="Int32" />
    </DeleteParameters>
    <InsertParameters>
      <asp:Parameter Name="ShipCountry" Type="String" />
    </InsertParameters>
    <UpdateParameters>
      <asp:Parameter Name="ShipCountry" Type="String" />
      <asp:Parameter Name="OrderID" Type="Int32" />
    </UpdateParameters>
  </asp:SqlDataSource>
</form>

Runtime

Create an instance of the ASPxListBox object, specify its ID , and add this object to the form.
Create a connection to the data source file.
Specify the ASPxListBox.DataSource, ASPxListBox.TextField, and ASPxListBox.ValueField properties.
Call the DataBindItems method to bind the control to the specified data source.

The resulting code:

csharp

protected void Page_Load(object sender, EventArgs e){
    ASPxListBox lb = new ASPxListBox();
    lb.ID = "Cities";
    form1.Controls.Add(lb);

    SqlDataSource ds = new SqlDataSource(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\NWind.mdf;Integrated Security=True", "SELECT [City] FROM [Customers]");

    ds.ProviderName = "System.Data.SqlClient";
    ds.ID = "ds";
    form1.Controls.Add(ds);
    lb.DataSourceID = "ds";
    lb.TextField = "City";
    lb.ValueField = "City";
    lb.DataBindItems();
}