Hi,

attempting to do smth here. got a datagrid, no sql data source attached. Have two hyperlinks above, click each of them makes a relevant dropdown box visible. Content in dropdown lists are data bound to the db.

on selection of the record in dropdown list and the click of the button attempting to attach the sqldata source to the grid. i.e

on click
{
  attach data source to grid
}

it seems as it takes the code in, but sends the error that the grid may not be without an sql data source. As one may see, tricky issue.

suggestions, wise ones?

appreciate that

mdm

what is your code and the name of your datasource?

Attempt to attach two different data sources depending on the click of the button. Error message - cannot have data grid left un attached (by default)
--------------------------------------------------------------------------------------------------------------------------------------------------

Protected Sub LinkButton1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        DropDownList1.Visible = True
        DropDownList1.DataValueField = "Language"
        DropDownList1.DataTextField = "Language"
        DropDownList1.DataSourceID = "SqlDataSource2"
        Button1.Visible = True
        GridView1.DataSourceID = "SqlDataSource1"
        DetailsView1.Visible = True


    End Sub

    'Protected Sub LinkButton2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
    ' DropDownList1.Visible = True
    ' DropDownList1.DataValueField = "UserID"
    ' DropDownList1.DataTextField = "UserID"
    'DropDownList1.DataSourceID = "SqlDataSource4"

    'Button1.Visible = True
    'GridView1.DataSourceID = "SqlDataSource5"

    ' DetailsView1.Visible = True
    ' End Sub

you need gridview1.datbind after you set the datasource