sqlparameter
Sql paramters appear to not add in the single quote for strings(commit transaction issue)
I wasn\'t sure exactly how to phrase the question Title. I have this block of code that sets up my sql parameters for a stored proc that does an insert.[详细]
2023-04-10 21:29 分类:问答ASP.NET What reference am I missing for Parameter Direction and SQLDBType
Hey just wondering what references 开发者_开发百科I need to add to my VS2008 Project to get thefollowing working[详细]
2023-03-22 15:13 分类:问答SQLServer INSERT getdate() function using parameters
What is the preferred method of adding the current date/time into an SQL Server table with INSERT Command and executenonquery?I\'m expecting something like ...[详细]
2023-03-19 11:00 分类:问答How to mock SqlParameterCollection using Moq
I am trying to mock database operations. I have problem in mocking SqlParameterCollection. I tried to create virtual method that will return DbParameterCollection but then i am loosing all the functio[详细]
2023-03-13 23:00 分类:问答Is there a way to determine if a parameter in a stored proc has a default value (and thus not required) in code - .Net?
I am already pulling the parameters from the stored proc sent in like this: foreach (SqlParameter param in cmd.Parameters)[详细]
2023-03-02 05:35 分类:问答SqlParameter ParameterDirection
A developer asked me tod开发者_如何转开发ay if there are disadvantages or risks while setting all SqlParameters for a SqlCommand to ParameterDirection.InputOutput. I coudn\'t think of any expect maybe[详细]
2023-02-19 10:40 分类:问答How do I get around this common SQL problem
Haven\'t come across this in ages and when I searched for the solution I couldn\'t find one. I think its called overloading in SQL. Basically when I have \"\" (an empty string) for any parameter in th[详细]
2023-02-17 18:45 分类:问答Is it possible to create an XmlReader from output SqlParameter of type SqlDbType.Xml?
This is my parameter definition: var param = new SqlParameter { ParameterName = \"@param\", SqlDbType = SqlDbType.Xml,[详细]
2023-02-15 09:47 分类:问答How do I use ADO Parameters at run time in Delphi 2006?
I have been banging my head against the desk with this. I have a simple table with 2 columns, like so:[详细]
2023-02-07 22:45 分类:问答Save large binary data into sql DB with C#
I need a code to store (eventually large) files into DB using C#. The solution I\'m using is sth like:[详细]
2023-02-05 16:57 分类:问答