.net reportviewer

[esra]

i am using reportviewer control. i want to change table name at runtime. i am using a stored prcedure with a parameter @tablename.

when i set the parameter as another thing code works. because i am designing the report, adding a table and assigning data columns. but when the tablename is variable i couldn't set the data columns. what should i do ?

this code works when parameter isn't tablename but when parameter is tablename setting object data source is problem

here is the code (show report button)

ReportViewer1.Visible = True

Dim MyConnection As New System.Data.SqlClient.SqlConnection()
MyConnection.ConnectionString = "Data Source=ssd-pc;Initial Catalog=kullanicilar;User ID=sa;Password=sapass"
MyConnection.Open()

Dim MyCommand11 As New SqlCommand()
MyCommand11.Connection = MyConnection
MyCommand11.CommandType = Data.CommandType.StoredProcedure
MyCommand11.CommandText = "deneme2"
Dim searchvalue As New SqlParameter("@raporadi", Data.SqlDbType.NVarChar, 1000)
searchvalue.Value = TextBox1.Text
MyCommand11.Parameters.Add(searchvalue)

Dim deneme As SqlDataAdapter = New SqlDataAdapter
deneme.TableMappings.Add("Table", TextBox1.Text)
deneme.SelectCommand = MyCommand11
Dim dataset1 As Data.DataSet = New Data.DataSet("dataset1")

deneme.Fill(dataset1)

Me.ReportViewer1.LocalReport.ReportPath = "report.rdlc"
Me.ReportViewer1.LocalReport.DataSources.Clear()

Me.ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("dataset2_deneme2", dataset1.Tables(0)))

Me.ReportViewer1.LocalReport.Refresh()