Filling typed datasets using Data Access Application Block v.2.0

5 Comments

• where in the world is the definition for "ApartmentDataset" ?
  

• Joeler: ApartmentDataset is a typed dataset that inherits from DataSet. It's not defined anywhere. It's just an example of how I'd use such a technique with a typed dataset.
  

• Another method of specifing Table Names, assuming the default name is already specified in the xsd.
  
  
  
  ApartmentDataset ds = new ApartmentDataset();
  
  string[] tableNames = new string[ds.Tables.Count];
  
  
  
  for (int i = 0; i < ds.Tables.Count; i++)
  
  tableNames[i] = ds.Tables[i].TableName;
  

• FWIW, newbie reading "Filling typed datasets...", just had gotten this to work as a global method for pages to use in a querystring, same idea as your helper. I'm migrating a portal from classic asp to c#.net, original asp code was organized this way, makes mapping functions to c# way easier than I expected since most were methods.
  
  
  
  using System;
  
  
  
  namespace yourNamespace {
  
  /// <summary>
  
  ///
  
  /// </summary>
  
  public class uurl {
  
  public uurl() { }
  
  public string main(){
  
  return getUURL();
  
  }
  
  public string getUURL() {
  
  Random oRandom = new Random();
  
  double dblRandom = oRandom.NextDouble();
  
  double invRandom = 1/(dblRandom + 3.9);
  
  DateTime oDateTime = DateTime.Now;
  
  string strDateTime = oDateTime.ToString();
  
  bool bGetToss = Convert.ToBoolean(System.Web.HttpContext.Current.Application["getToss"]);
  
  int ms = oDateTime.Millisecond;
  
  int invMS = 1/ms;
  
  string strUURL = System.Web.HttpUtility.UrlEncode(strDateTime + "|" + bGetToss.ToString() + "|" + invRandom.ToString() + "|" + dblRandom.ToString() + "|" + ms + 1/ms + "|");
  
  if(strUURL != "" || strUURL != null){
  
  return strUURL.ToString();
  
  }else{
  
  return "default.IeekIEosLMdmwPOkowqUIFDUIuds9938ck83736ckd";
  
  }
  
  }
  
  }
  
  }
  
  
  
  Then on a page:
  
  
  
  yourNamespace.uurl oUURL = new yourNamespace.uurl();
  
  this.strUURL = oUURL.getUURL().ToString();
  
  
  
  good stuff, yum, yum,
  
  
  
  kutgw,
  
  
  
  newbie tom
  

• How do u use the DAAB to execute an action query that updates a row in a master table (User) and multiple rows in child tables (Addresses) in one call.
  
  
  
  I was looking at using SQL XML. Wanted to validate if thats a suggested paradigm.
  
  
  
  Thanks
  
  Rahul