.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.V isible = True

Dim MyConnection As New System.Data.Sql Client.SqlConne ction()
MyConnection.Co nnectionString = "Data Source=ssd-pc;Initial Catalog=kullani cilar;User ID=sa;Password= sapass"
MyConnection.Op en()

Dim MyCommand11 As New SqlCommand()
MyCommand11.Con nection = MyConnection
MyCommand11.Com mandType = Data.CommandTyp e.StoredProcedu re
MyCommand11.Com mandText = "deneme2"
Dim searchvalue As New SqlParameter("@ raporadi", Data.SqlDbType. NVarChar, 1000)
searchvalue.Val ue = TextBox1.Text
MyCommand11.Par ameters.Add(sea rchvalue)

Dim deneme As SqlDataAdapter = New SqlDataAdapter
deneme.TableMap pings.Add("Tabl e", TextBox1.Text)
deneme.SelectCo mmand = MyCommand11
Dim dataset1 As Data.DataSet = New Data.DataSet("d ataset1")

deneme.Fill(dat aset1)

Me.ReportViewer 1.LocalReport.R eportPath = "report.rdl c"
Me.ReportViewer 1.LocalReport.D ataSources.Clea r()

Me.ReportViewer 1.LocalReport.D ataSources.Add( New ReportDataSourc e("dataset2_den eme2", dataset1.Tables (0)))

Me.ReportViewer 1.LocalReport.R efresh()