DataGrid Bind to DataSet, then Bind to DaTaview, GOT ERROR...PLS HELP

[A_PK]

I have problem databinding the DataGrid with DataView/DataSet after the
filter...
I create the following proceudre in order for user to filter as many as they
want, but the following code is only allow user to filter the first time,
when they tried the second time, the speficied cast error message will
prompt one....

I create a mydataset1 first, and the mydataset1 data source was getting from
DataGrid.DataSo urce.

then I create a DataView in order for me to filter....
after I enter the criteria, then will filter successfully the first time,
but not second time.

the I bind the DataGrid to DataView together......

The first filter is always successfully, I just can not filter the same data
second time...
I suspect it the DataView and DataSet problem, because at first I bind
datagrid1 and get the data source of datagrid1 form Dataset, but at the end
I bing the Datagird to the Dataview also.....so there are some error....i
think....

I just have no idea how to bind the Datagrid with Dataview, and allow user
to filter as many time as they want.....
could someone pls guide me.... here are the CODE
Try
Dim mydataset1 As New DataSet
mydataset1 = DataGrid1.DataS ource

Dim mydataview As New
DataView(mydata set1.Tables(Glo bal.strTblName) )
Dim strInput

strInput = InputBox("test" )
mydataview.RowF ilter = "Custno = " & strInput & ""

DataGrid1.Datas ource= mydataview
' DataGrid1.DataS ource = mydataset1
' DataGrid1.DataM ember = GlobalDBExplore r.strTblName

Catch err As InvalidCastExce ption
MsgBox(err.Mess age)
Catch err As Exception

MsgBox(err.Mess age)
End Try

[Cor Ligthert]

APK,

You only have to bind the dataview one time to your datagrid.
There cannot be more datasources.

I have the idea that you are creating everytime a new dataview and try to
bind that new one against your datagrid.

I hope this helps,

Cor

[A_PK]

Hi Cor,

my first problem is that....I dun have a fix dataset for me to bind to
datagrid1....
It is dynamically bind to datasetA or datasetB...depe nd on user's choice...

so I have to create anotehr local dataset1 and set to
mydataset1 = datagrid.dataso urce

after i get the mydataset1, then I create Dataview....
and user allow to do filter on dataview, then after the filtering, then
datagrid1 bind to dataview.....

please note that...I am using DataGrid = myDataView....
so for other feacture, i can not get the myDataSet1 = DataGrid.DataSo urce,
because i can not simply quote Dateset1 = DataView..

so I wish to know how the DataView can update the Dataset1.....

if I were to allow to create only one time dataview, may I know where should
I create the DataView ?


"Cor Ligthert" <no************ @planet.nl> wrote in message
news:e5******** ******@tk2msftn gp13.phx.gbl...

APK,

You only have to bind the dataview one time to your datagrid.
There cannot be more datasources.

I have the idea that you are creating everytime a new dataview and try to
bind that new one against your datagrid.

I hope this helps,

Cor

[Arun]

Hi,
Do it like this,

dim myDataView = myDataTable.Def aultView;

If you take DefaultView from a table and filter it with your criteria,
when you change a values in the dataview the change will pass through
to the underlying datatable as well.
So no need to bind it once again you may comment this

DataGrid1.Datas ource= mydataview

Hope this helps,
Cheers,
Arun.
www.innasite.com

[Cor Ligthert]

APK,

You can use as much dataviews as you want, however a datagrid can only one
use one datasource.

Probably the best choise for you ia uainf the defaultview what is in every
datatable which is a dataview.

Someting as setting it every time when the user have changed.

\\\
dataset.table(x ).defaultview.r owfilter = "xx = " & y & "'"
///

Than you can use one time

\\\
Datagrid1.datas ource = dataset.table(x ).defaultview
///

I hope this helps,

Cor

[A_PK]

hi cor, arun...

another problem.....

how could I bind the data to myDataview or myDataset ?...

Cor, you mentioned
dataset.table(x ).defaultview.r owfilter = "xx = " & y & "'"

my problem is......my dataset is nothing at the very first beginning...
I have to based on datagrid data then only can decide my dataset1...

that is the reason that I set mydataset1 = datagrid.dataso urce.....
after i set the mydataset1 = datagrid.dataso urce, then i type the one u
mentioned, and bind it accordinly what u had mentioned....bu t i still
getting the error "sepcialize d cast error"......

because i bind the dataset based on datagrid.datasr ouce.....

I just wonder if I bind it wrongly ? or anyway way to solve that problem ?
my dataset is nothing at the beginning, I get the dataset data based on
datagird data.
mydataset = Datagrid.dataso urce......

after getting mydataset, then I using defauly view to bind to datagrid......

but I am still getting error when i did it repeatly....

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:Oa******** ******@tk2msftn gp13.phx.gbl...

APK,

You can use as much dataviews as you want, however a datagrid can only one
use one datasource.

Probably the best choise for you ia uainf the defaultview what is in every
datatable which is a dataview.

Someting as setting it every time when the user have changed.

\\\
dataset.table(x ).defaultview.r owfilter = "xx = " & y & "'"
///

Than you can use one time

\\\
Datagrid1.datas ource = dataset.table(x ).defaultview
///

I hope this helps,

Cor

[A_PK]

To simply what I want to do....

I create a Dataset with a lot of infomration, then i create Dataview to
filter out all unwanted info....so that all the info in the Dataview is all
the information that I want ......

now I want to update the dataview to a dataset...cos I might perform other
update or delete command to update dataset........

pls guide me how to update DataView to Dataset ?

1- Dataset with All Info
2- create Dataview and filter out all unwanted info
3- update back Dataview to previous Dataset...

how to do that ?
so perhaps, my dataset have 1000 records, but after I did the filter, only
50 records i want...
so i update 50 back to dataset, and delete other 950 records....

hope someone to guide me...thank you....

" A_PK" <pk***@hotmail. com> wrote in message
news:%2******** ********@TK2MSF TNGP15.phx.gbl. ..

hi cor, arun...

another problem.....

how could I bind the data to myDataview or myDataset ?...

Cor, you mentioned
dataset.table(x ).defaultview.r owfilter = "xx = " & y & "'"

my problem is......my dataset is nothing at the very first beginning...
I have to based on datagrid data then only can decide my dataset1...

that is the reason that I set mydataset1 = datagrid.dataso urce.....
after i set the mydataset1 = datagrid.dataso urce, then i type the one u
mentioned, and bind it accordinly what u had mentioned....bu t i still
getting the error "sepcialize d cast error"......

because i bind the dataset based on datagrid.datasr ouce.....

I just wonder if I bind it wrongly ? or anyway way to solve that problem ?
my dataset is nothing at the beginning, I get the dataset data based on
datagird data.
mydataset = Datagrid.dataso urce......

after getting mydataset, then I using defauly view to bind to
datagrid......

but I am still getting error when i did it repeatly....

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:Oa******** ******@tk2msftn gp13.phx.gbl...

APK,

You can use as much dataviews as you want, however a datagrid can only
one use one datasource.

Probably the best choise for you ia uainf the defaultview what is in
every datatable which is a dataview.

Someting as setting it every time when the user have changed.

\\\
dataset.table(x ).defaultview.r owfilter = "xx = " & y & "'"
///

Than you can use one time

\\\
Datagrid1.datas ource = dataset.table(x ).defaultview
///

I hope this helps,

Cor

[Cor Ligthert]

APK,

I made a little sample for you.

\\\Needs a datagrid and a button on a form
Private ds As New DataSet
Private Sub Form1_Load(ByVa l sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim dt As New DataTable("APK" )
dt.Columns.Add( "A")
dt.LoadDataRow( New Object() {"1"}, True)
dt.LoadDataRow( New Object() {"2"}, True)
dt.LoadDataRow( New Object() {"3"}, True)
ds.Tables.Add(d t)
DataGrid1.DataS ource = ds.Tables("APK" ).DefaultView
End Sub
Private Sub Button1_Click(B yVal sender As System.Object, _
ByVal e As System.EventArg s) Handles Button1.Click
If ds.Tables("APK" ).DefaultView.R owFilter = "A = '2'" Then
ds.Tables("APK" ).DefaultView.R owFilter = ""
Else
ds.Tables("APK" ).DefaultView.R owFilter = "A = '2'"
End If
End Sub
///

I hope this helps,

Cor

[A_PK]

Hi Cor, i understand what u mean....

but after I have done the filter, and set the DataGrid1.DataS ource =
ds.Tables("APK" ).DefaultView
....I can perform filter feature actually. just that when I do know how to
retierve the filtered datasource and bind them to a new dataset to perform
other feature....

When I click other buttton, not the button u mentioned.....I need to know
what dataset is binding that datagrid. so in other button, i type myDataset
= Datagrid1.datas ource. then i will get the specialied cast error...cos my
Datagrid.dataso urce is binding to a dataview, not dataset.... after I filter
all infomration liao, i have problem binding those information to other
dataset1...

u tried the following sure got problem

Declare a global dataset as dsFilter....

Try
Dim strInput
strInput = InputBox("test" )

dsFilter.Tables (GlobalDBExplor er.strTblName). DefaultView.Row Filter
= "ColumnName = ' & strInput & '"

DataGrid1.DataS ource =
dsFilter.Tables (GlobalDBExplor er.strTblName). DefaultView
Catch err As InvalidCastExce ption
MsgBox(err.Mess age)
Catch err As Exception

MsgBox(err.Mess age)

End Try

I have no problem up to here.....but I want to
get the Datasource from DataGrid, then I will have problem

can i do anything like
mydataset = Datagird.dataso urce ?

mydataset.Table s(TableName) = DataGrid.Dataso urce ?

I need to get the Datasource from DataGrid from my other features....
I just no idea how to do that .....

but I have no problem if it is dataset.....
I can simply type mydataset = DataGrid.Dataso urce
Since I am binding to a View, i can no longer get the datasource from
datagrid1 by just typing mydataset = datagrid.dataso urce....

pls guide
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

APK,

I made a little sample for you.

\\\Needs a datagrid and a button on a form
Private ds As New DataSet
Private Sub Form1_Load(ByVa l sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim dt As New DataTable("APK" )
dt.Columns.Add( "A")
dt.LoadDataRow( New Object() {"1"}, True)
dt.LoadDataRow( New Object() {"2"}, True)
dt.LoadDataRow( New Object() {"3"}, True)
ds.Tables.Add(d t)
DataGrid1.DataS ource = ds.Tables("APK" ).DefaultView
End Sub
Private Sub Button1_Click(B yVal sender As System.Object, _
ByVal e As System.EventArg s) Handles Button1.Click
If ds.Tables("APK" ).DefaultView.R owFilter = "A = '2'" Then
ds.Tables("APK" ).DefaultView.R owFilter = ""
Else
ds.Tables("APK" ).DefaultView.R owFilter = "A = '2'"
End If
End Sub
///

I hope this helps,

Cor

[A_PK]

i still have a sub Call WriteXML...usin g the filtered data to write to XML

Private Sub WriteXML()
Dim mydataset As New DataSet
mydataset = DataGrid1.DataS ource
mydataset.Write Xml(Application .StartupPath & "\Demo.xml" )

End Sub

I can simply use mydataset = DataGrid.Dataso urce, and get the reference, and
export as XML file.
but after I set to defauly view or use dataview, i can no longer the the
datasource references.

I just wonder how should I get the above mydataset bind to the filtered
datagrid datasource.

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:Og******** ******@TK2MSFTN GP12.phx.gbl...

APK,

I made a little sample for you.

\\\Needs a datagrid and a button on a form
Private ds As New DataSet
Private Sub Form1_Load(ByVa l sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim dt As New DataTable("APK" )
dt.Columns.Add( "A")
dt.LoadDataRow( New Object() {"1"}, True)
dt.LoadDataRow( New Object() {"2"}, True)
dt.LoadDataRow( New Object() {"3"}, True)
ds.Tables.Add(d t)
DataGrid1.DataS ource = ds.Tables("APK" ).DefaultView
End Sub
Private Sub Button1_Click(B yVal sender As System.Object, _
ByVal e As System.EventArg s) Handles Button1.Click
If ds.Tables("APK" ).DefaultView.R owFilter = "A = '2'" Then
ds.Tables("APK" ).DefaultView.R owFilter = ""
Else
ds.Tables("APK" ).DefaultView.R owFilter = "A = '2'"
End If
End Sub
///

I hope this helps,

Cor