SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder(UFContextManager.UFAccDataConnectionString);
MsSqlConnectionParameters connParameters = new MsSqlConnectionParameters()
{
ServerName = sqlConnectionStringBuilder.DataSource,
UserName = sqlConnectionStringBuilder.UserID,
Password = sqlConnectionStringBuilder.Password,
DatabaseName = sqlConnectionStringBuilder.InitialCatalog,
AuthorizationType = MsSqlAuthorizationType.SqlServer
};
SqlDataSource sds = new SqlDataSource(connParameters);
CustomSqlQuery query = new CustomSqlQuery()
{
Name = "SelectAll",
Sql = "select cDepCode,cDepName from department"
};
sds.Queries.Add(query);
sds.Fill();
gc_Data.DataSource = sds;
gc_Data.DataMember = "SelectAll";