Placing RadGrid in a RadDock

HOW-TO
Place RadGrid in a RadDock

SOLUTION
Generally, this is a simple task - you merely need to place your grid instance inside RadDockZone -> RadDock and configure the controls to work in the same way as if they work separately. Thus the user can relocate the grid on the page, thus "modeling" the appearance of the webform, per his/her requirements.

In the sample code below we enabled the sorting/client selection built-in features of RadGrid:

ASPX:

C#:

protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)

{

OleDbConnection MyOleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/App_Data/Access/Nwind.mdb"));

OleDbDataAdapter MyOleDbDataAdapter = new OleDbDataAdapter();

MyOleDbDataAdapter.SelectCommand = new OleDbCommand("SELECT TOP 5 ContactName, ContactTitle, Address FROM Customers", MyOleDbConnection);

DataTable myDataTable = new DataTable();

MyOleDbConnection.Open();

try

{

MyOleDbDataAdapter.Fill(myDataTable);

}

finally

{

MyOleDbConnection.Close();

}

(source as RadGrid).DataSource = myDataTable.DefaultView;

}

VB:

Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As GridNeedDataSourceEventArgs)

Dim MyOleDbConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/App_Data/Access/Nwind.mdb"))

Dim MyOleDbDataAdapter As New OleDbDataAdapter()

MyOleDbDataAdapter.SelectCommand = New OleDbCommand("SELECT TOP 5 ContactName, ContactTitle, Address FROM Customers", MyOleDbConnection)

Dim myDataTable As New Data.DataTable()

MyOleDbConnection.Open()

Try

MyOleDbDataAdapter.Fill(myDataTable)

Finally

MyOleDbConnection.Close()

End Try

TryCast(source, RadGrid).DataSource = myDataTable.DefaultView

End Sub