assign parameter to an sqldatadapter

See more:

VB

ADO.NET

Hello,
I have a master detail/table in which the detail has a blob field. Due to a large ammount of data I get an error out of memory when I navigate to the last records (I think it loads the data and can't clear the previous records cache?). So I tried to do it with a second dataadapter and a parameter, which parameter (for the detail table) takes the primary key of the master table through a textbox (the paramater points to the detail table foreign key), on the preview of the adapter I enter a valid number and I get the data, the problem is when I coded to insert the value I get no data

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Me.SqlDataAdapter1.Fill(DataSet11, "Table1")
    Me.SqlDataAdapter2.SelectCommand.Parameters(0).Value = convert.int32(TextBox1.Text)
    Me.SqlDataAdapter2.Fill(DataSet21, "scan")
  end Sub

Thank you
Kyriakos