Maybe OP is NOT happy because DataView is NOT "Typed" :) By the way
On Jan 22, 10:51 pm, Cerebrus <[email protected]> wrote: > Well, the DataTable property of the Typed dataset is (and should be, > by all means) ReadOnly. Why do you want to overwrite the table at > all ? Once you have converted it to a DataView, you can use the > DataView wherever you need. > > On Jan 22, 9:24 pm, Nacho108 <[email protected]> wrote: > > > > > Hi Everyone! I'm glad I'm joining the group. > > > I'm new in c# programming and I have some doubts about datasets , > > dataview, etc. I hope in some time I can answer and help others also. > > I'm reading a table within a database and then putting it within a > > datatable object and so far so good. > > The problem arises when I try to use typed datasets and using > > dataviews at the same time. > > > 1) BASE_ANDataSet dt = new BASE_ANDataSet(); > > 2) string sqlConnectString; > > 3) sqlConnectString = "Data Source=(local);User > > Id=sa;Password=;Initial Catalog=BASE_AN;"; > > 4) string sqlSelect = @"SELECT * from ALARMS "; > > 5) SqlDataAdapter da = new SqlDataAdapter(sqlSelect, > > sqlConnectString); > > 6) da.Fill(dt); > > 7) DataView v = dt.ALARMS.DefaultView; > > 8) v.Sort = "AID"; > > 9) dt.ALARMS = v.ToTable(); > > > Up to item 8 I have no problems, but then in item 9 the compiler tells > > me that dt.ALARMS is an read-only object. > > > I tried this same code with tables and it worked just perfect. > > Please can someone help me with that? > > > Thanks in advance !! > > > Nacho- Hide quoted text - > > - Show quoted text -
