WinForms Data Grid - Configure the SQL Data Source and bind it to the grid

This example demonstrates how to:

• Create and configure the SqlDataSource component

  private static SqlDataSource InitData() {
      MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters("localhost", "nwind.mdf", "username", "password", MsSqlAuthorizationType.SqlServer);
      SqlDataSource ds = new SqlDataSource(connectionParameters);
      CustomSqlQuery query = new CustomSqlQuery();
      query.Name = "customQuery1";
      query.Sql = "SELECT * FROM Products";
      ds.Queries.Add(query);
      ds.Fill();
      return ds;
  }

• Bind the GridControl to a Microsoft SQL Server database.

  private void Init() {
      SqlDataSource ds = InitData();
      Grid.DataSource = ds;
      Grid.DataMember = "customQuery1";
  }

Files to Review

• Form1.cs (VB: Form1.vb)

Documentation

• Binding to SQL Data
• Data Binding - WinForms Data Grid

See Also

• How to use the SqlDataSource component to provide data for the GridControl at design time
• Data Binding - DevExpress WinForms Troubleshooting

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)