When I add the SQL parameter p to the collection I get an InvalidCastException with the message from the post title. parentId is a nullable integer and a nullable integer in the database. Why do ...

I'm currently trying to write a simple C# wrapper class for all the stored procedures in a database. While building some parameters in C#, I noticed the property SqlParameter.IsNullable and wonde...

sqlQuery = "SELECT [ID] from [users] WHERE CallerName=@CallerName"; OleDbConnection conn = new OleDbConnection(connectionString); conn.Open(); cmd = new OleDbCommand(sqlQuery, conn); cmd.CommandTe...

I have the following line of code: sqlcommand.Parameters.Add("@LinkID", SqlDbType.Int, 4).Value = linkID; But, I'm slightly confused about the use of size. Is this saying that its 4 bytes in siz...

I have a web service, so the handler is called multiple times concurrently all the time. Inside I create SqlConnection and SqlCommand. I have to execute about 7 different commands. Different comma...

I observed a strange problem in a piece of code where an adhoc SQL query was not producing the expected output, even though its parameters matched records in the data source. I decided to enter the...

I'm sending a decimal value to a sproc in the following way: SqlParameter meh = new SqlParameter("Foo", SqlDbType.Decimal); meh.Value = "0.00001"; meh.Precision = ((System.Byte)...

I was doing something like this: SqlParameter param = new SqlParameter("@Param", 0) { SqlDbType = SqlDbType.Int }; private void TestParam(SqlParameter param) { string test = param.Value.ToString...

This is kind of a weird one. I'm looking for ideas on how to ask the right question as much as I am an actual solution. I've got a website and we just had a huge jump in traffic. Now all of the su...

Using SqlParameters is a recommended method to prevent SQL Injection in your database queries. Where can I find the code/function that internally sanitizes these parameters? I'd like to re-use this...