Bind a column to another SQL DataSource

[Adigard]

Hello,

I have my Radgrid binded to a first SQLDataSource.
But, I need to have a column (i have created manually) from my RADGrid binded to another SQLDataSource(informations from another table)

Is this possible ?
Thank you in advance for your help!

[Adigard]

To be more precise all i need is to use a special SQLdatasource for a column while the other ones use another SQLDataSource

[Adigard]

I'm still looking for a solution ... does anyone have an idea about this ?

[Shinu]

Hello Adigard,

One suggestion is to create a dataTable from the two DataSource and merge them into a new one.
C#:

Dim dt As New DataTable("dt")
dt.Columns.Add("1")
dt.Columns.Add("2")
dt.Columns.Add("3")

Dim dr As DataRow
dr = dt.NewRow
dr("1") = "11"
dr("2") = "21"
dr("3") = "31"
dt.Rows.Add(dr)

Dim dt2 As New DataTable("dt")
dt2.Columns.Add("1")
dt2.Columns.Add("2")
dt2.Columns.Add("3")

dr = dt2.NewRow
dr("1") = "12"
dr("2") = "22"
dr("3") = "32"
dt2.Rows.Add(dr)

Dim ds As New DataSet
ds.Tables.Add(dt)
ds.Merge(dt2)

Thanks,
Shinu.