Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: ADO.NET

  • ASP.NET Example – Populating a DataSet Using SQLDataAdapter Fill DataSet

    In the example functions below I’m illustrating how to set up a basic query to a stored procedure in your database that takes a single string parameter. The examples involve using the SQLDataAdapter object to Fill a DataSet. The resulting DataTable can then be queried as desired. Specifically: The first example shows how to read the…

  • InvalidCastException – Failed to convert parameter value from a XmlDocument to a String

    If you are working with XML data types in your .NET and SQL Server code, then you will most likely encounter this error message at some point. Specifically, this error is related to improperly passing an XML value as a SQLParameter to your database. Since most of the work one does with XML in .NET…

  • ASP.NET Choosing Parameters.Add or Parameters.AddWithValue

    If you are adding parameters to a SqlCommand object then you can use either Parameters.Add or Parameters.AddWithValue. The Parameters.Add syntax requires you to explicitly specify the DataType of the parameter you are passing, while the Parameters.AddWithValue syntax implicitly attempts to convert the parameters you pass in. When choosing which method you want to use, you should be aware that…