code_junkie

Null Reference Exception

Nov 13th, 2011
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. DAL dal = new DAL();
  2.  
  3. string SQL = @"INSERT INTO Assets ([AssetName],[AssetType],[Model],[Description],
  4. [PurchaseValue],[SalvageValue],[Currency],[DateAcquired,[DateRetire],[ImagePath],
  5. [InUse])
  6. VALUES (?,?,?,?,?,?,?,?,?,?,?)";
  7.  
  8. OleDbParameter[] par = new OleDbParameter[]{
  9. new OleDbParameter("@assetname",name.Text),
  10. new OleDbParameter("@assettype",assettypes.SelectedValue.ToString()),
  11. new OleDbParameter("@model",model.Text),
  12. new OleDbParameter("@description",description.Text),
  13. new OleDbParameter("@purchasevalue",purchaseval.Value),
  14. new OleDbParameter("@salvagevalue",salvageval.Value),
  15. new OleDbParameter("@currency",currencies.SelectedIndex),
  16. new OleDbParameter("@dateacquired",purchasedate.Value),
  17. new OleDbParameter("@dateretire",purchasedate.Value.AddYears((int)lifetime.Value)),
  18. new OleDbParameter("@imagepath","N/A"),
  19. new OleDbParameter("@addedby",MDIParent1.User.ID)
  20. };
  21.  
  22. new OleDbParameter("@assetname",name.Text),
  23. new OleDbParameter("@assettype",assettypes.SelectedValue.ToString()),
  24. new OleDbParameter("@model",model.Text),
  25. new OleDbParameter("@description",description.Text),
  26. new OleDbParameter("@purchasevalue",purchaseval.Value),
  27. new OleDbParameter("@salvagevalue",salvageval.Value),
  28. new OleDbParameter("@currency",currencies.SelectedIndex),
  29. new OleDbParameter("@dateacquired",purchasedate.Value),
  30. new OleDbParameter("@dateretire",purchasedate.Value.AddYears((int)lifetime.Value)),
  31. new OleDbParameter("@imagepath","N/A"),
  32. new OleDbParameter("@addedby",MDIParent1.User.ID)
  33.  
  34. DAL dal = new DAL();
  35.  
  36. DAL _dal = new DAL();
  37. DAL dataAccessLayer = new DAL();
Add Comment
Please, Sign In to add comment