Browse by Tags

All Tags » c#   (RSS)
02 May 2009
Solution to the “You tried to assign the Null value to a variable that is not a Variant data type.” Exception
By default the DataSource wizard passes parameters for AutoNumber primary keys. If you are getting this error: You tried to assign the Null value to a variable that is not a Variant data type. Then you need to remove that default parameter. This is what Read More...
1 Comments
Filed under: , , , ,
 
02 May 2009
Solution to the “Format of the initialization string does not conform to specification starting at index 0.” Exception
You are probably using the wrong DbConnection class. If you are using Access then make sure you use OleDbConnection, not SqlConnection…and vice versa. Alternatively you could be referencing your MDB file wrong. Here’s the proper way: <connectionStrings> Read More...
2 Comments
Filed under: , , , ,
 
06 April 2009
Solution to “Operation must use an updateable query” Exception when writing to an Access Database from ASP.NET
Could be a couple of things: The file is marked as read-only. Right click on file, uncheck “read only”. The application pool identity doesn’t have write permissions to the folder that contains the MDB. Find the identity of the application pool (using Read More...
1 Comments  
03 April 2009
Mobile Browser Detection in ASP.NET
Before last week the only two viable Mobile Browser Detection options were: WURFL – Great for non-.NET solutions.  .NET APIs lack support DeviceAtlas – Great for .NET solutions, but it’s starts at $99/server/year.  DeviceAtlas claims to have Read More...
4 Comments
Filed under: , , ,
 
13 March 2009
Access Database Membership, Profile, Role and Personalization Providers for ASP.NET
ASP.NET doesn’t ship with Membership, Profile, Role or Personalization providers out of the box.  Imar Spaanjaars has a great article on how to setup a site using the “Sample Access Providers” provided by Microsoft. http://imar.spaanjaars.com/ http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=404 Read More...
1 Comments
Filed under: , ,
 
03 March 2009
The simplest DataSet to Excel solution
Tim Mackey has a very simple method for converting DataSets to Excel spreadsheets. http://tim.mackey.ie/HowtoExportADatasetToExcelCAspnet.aspx Thanks Tim! Read More...
1 Comments
Filed under: , , ,
 
25 February 2009
Solution to Method has no implementation (no RVA) Error
If you get this exception System.TypeLoadException: Could not load type ‘x’ from assembly 'xx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' because the method 'SendMessage' has no implementation (no RVA). Make sure you have a DllImport attribute Read More...
1 Comments
Filed under: ,
 
23 February 2009
Binding Hierarchical DataSets to TreeView Controls
OOB the ASP.NET TreeView control doesn’t support binding to Hierarchical DataSets. Ralph Varjabedian created a HierarchicalDataSet class to help with this.  Read more about it here .   Here’s a snippet…it’s simple to implement: TreeView1.DataSource Read More...
1 Comments
Filed under: , ,
 
19 February 2009
How to reuse TreeNodeCollection in Windows Forums apps
I’m creating an app and need the same data set for two tree views. Nodes.AddRange only works with a TreeNode[] and the TreeNodeCollection is read-only and doesn’t have a ctor.   I first tried something like this: TreeNode[] nodes = new TreeNode[treeView1.Nodes.Count]; Read More...
0 Comments
Filed under: , ,
 
17 February 2009
Delete all Outlook RSS Feeds
My Outlook RSS Feeds were in a really funky state this morning.  I had to create a new profile and I had RSS Sync enabled.  When that is the case Outlook re-adds all Feeds that you have ever added to the machine back into your profile even if Read More...
0 Comments
Filed under: , , , ,
 
05 November 2008
PDC Wrapup - My fav sessions
PDC was great this year! Here's a quick list of my favorite sessions of technologies and products that Social Bookmarking will use soon... Stuff we'll use this year: Velocity ADO.NET Data Services Visual Studio 2010 C# 4.0 j Query MVC ASP.NET 4.0 ....Next Read More...
1 Comments
Filed under: , , , ,
 
17 April 2008
Short and Sweet "Silverlight 2.0, LINQ and WCF in 5 Minutes" Video
Download Source This is the first video in my new "Short and Sweet" video series. I'm going to continue with Silverlight, LINQ and WCF path for the series. Please ping me if you have an idea for a future video. This video takes you through the minimum Read More...
6 Comments
Filed under: , , , , , ,
 
02 December 2007
LINQ: Sequence contains no elements. InvalidOperationException when calling Single
If you call Single to get an object from your DB and the object doesn't exist you will get an InvalidOperationException. return this .DataContext.MemberDaos.Single(m => m.MemberID == id); Instead of Single, use SingleOrDefault, which will return null Read More...
7 Comments
Filed under: , ,
 
01 December 2007
LINQ: "Add" renamed to "InsertOnSubmit"
If you are using LINQ to insert data with RTM bits you won't find the Add method on the DataContext post Beta2. Use the InsertOnSubmit method instead. Read More...
6 Comments
Filed under: , ,
 
25 November 2007
LINQ and Web Application Connection Strings
It's usually a good idea to seperate Biz Layer Objects and Data Access Objects into seperate assemblies, but when you do that and use LINQ to SQL (.dbml) files the DataContext object default ctor uses the Settings file that is automattically generated Read More...
9 Comments  
More Posts Next page »
Page view tracker