Top "Sqlparameter" questions

Assign null to a SqlParameter

The following code gives an error - "No implicit conversion from DBnull to int." SqlParameter[] parameters = new SqlParameter[1]; SqlParameter planIndexParameter = …

c# dbnull sqlparameter

WHERE IN (array of IDs)

I have webservice which is passed an array of ints. I'd like to do the select statement as follows but …

c# sql-server tsql ado.net sqlparameter

How to pass XML from C# to a stored procedure in SQL Server 2008?

I want to pass xml document to sql server stored procedure such as this: CREATE PROCEDURE BookDetails_Insert (@xml xml) …

c# sql-server xml stored-procedures sqlparameter

How to call Stored Procedures (with 2 parameters) in a Stored Procedure?

I have stored procedures with same parameters (server name and date). I want to write a stored procedure and Exec …

sql sql-server stored-procedures parameters sqlparameter

How to create NVarchar(max) Sqlparameter in C#?

I've got the following code to pull back a DataTable using a stored procedure and inputting a string parameter @JobNumbers, …

c# sql nvarchar sqlparameter

Size property has an invalid size of 0

I am working on a social network, one of my procedures returns a VARCHAR output. So this is what I …

c# asp.net sql-server stored-procedures sqlparameter

how to pass sql parameter as null value in integer datatype variable?

how to pass sql parameter as null value in to integer data type variable ? StockBO sBO = new StockBO(); sBO.Mode = 2; …

c# types integer sqlparameter

Best method of assigning NULL value to SqlParameter

I have a number of optional input parameters I am using in a C# class method. Since the optional syntax …

c# null sqlparameter

Passing null as SQLParameter DateTime value

I have the following query: INSERT INTO CWS_FORWARDING_PROFILE (TNR_COMPANY_PROFILE,BOL_FORWARD_MAIL,BOL_FORWARD_SMS,BOL_…

c# datetime sqlparameter

Creating a SQL table variable in a stored procedure

I want to create SQL variable table in stored procedure which include this; Select a,b,c,d from **@tablename** …

sql stored-procedures sqlparameter