fill some tables is dataset with cached data ?

  • Thread starter Thread starter Roman Pokrovskij
  • Start date Start date
R

Roman Pokrovskij

Hello ALL



Is it possible to fill some tables in dataset with cached (some way) data ?



Explanations



I have an edit form in MDI interface. This form is based on one recordset.
Some controls on this form are lists and comboboxes.

And it is naturally that I don't want to have several datables copies with
data for this "lists" in local memory



But I still want to use one typed recordset and it relations support.
 
hi
i think you can fill datasets with data from all sources you can fill it
from you source value by value , this is an example of untyped datatset (
you can do the same with adding data to typed ones
myset = new DataSet();
mytable = new DataTable("trial");
mycolumn = new DataColumn("col1" , Type.GetType("System.Decimal"));
mycolumn.AllowDBNull = true;
mytable.Columns.Add(mycolumn);
DataRow myrow = mytable.NewRow();
myrow["col1"]= 11.1;
mytable.Rows.Add(myrow);
mytable.Rows.Add(new object[]{12.2});
mytable.Rows.Add(new object[]{14.7});
myset.Tables.Add(mytable);
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC
 
Back
Top