- Joined
- Jun 7, 2007
- Messages
- 1
- Reaction score
- 0
Hi,
I am generate a dataset from the asp.net add->add new item-> template pane and my dataset name is "sample.xsd". I use this for the reporting purpose. I am using microsoft reportviewer control and i want to store the report results into databse. For thet purpose I want to access this dataset's table adapter in my .aspx page and load the value into the dataset(dim ds as new dataset). How can I access the sample.xsd dataset in my .aspx page and get the values . please give me a solution. Its very urgent. I tried. I get the column count. But the row count shows "0".
My sample code is given below
Dim obj As SampleTableAdapters.ProductTableAdapter = New SampleTableAdapters.ProductTableAdapter
Dim dt As New SampleReports.Sample.ProductDataTable
obj.FillFilters(dt, TextBox1.Text) ( TextBox1.Text is the parameter value. I pass one parameter into the dataset)
Dim dt1 As New DataTable
dt1 = obj.GetFilters(TextBox1.Text)
Dim dataset As New DataSet
dataset.Tables.Add(dt)
I am generate a dataset from the asp.net add->add new item-> template pane and my dataset name is "sample.xsd". I use this for the reporting purpose. I am using microsoft reportviewer control and i want to store the report results into databse. For thet purpose I want to access this dataset's table adapter in my .aspx page and load the value into the dataset(dim ds as new dataset). How can I access the sample.xsd dataset in my .aspx page and get the values . please give me a solution. Its very urgent. I tried. I get the column count. But the row count shows "0".
My sample code is given below
Dim obj As SampleTableAdapters.ProductTableAdapter = New SampleTableAdapters.ProductTableAdapter
Dim dt As New SampleReports.Sample.ProductDataTable
obj.FillFilters(dt, TextBox1.Text) ( TextBox1.Text is the parameter value. I pass one parameter into the dataset)
Dim dt1 As New DataTable
dt1 = obj.GetFilters(TextBox1.Text)
Dim dataset As New DataSet
dataset.Tables.Add(dt)