Top "Sqlcommand" questions

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database which is used in Microsoft .NET.

What does SqlDbType.Structured mean?

From msdn website I get the following: A special data type for specifying structured data contained in table-valued parameters. It …

c# sqlcommand sqlparameter sqldbtype
ExecuteNonQuery inside loop

I'm trying to insert a database record inside a loop in C#. It works when I hard code the values …

c# sqlcommand parameterized-query
C# - Output SqlParameter uses different values then the ones given?

I have a SqlCommand which runs a stored procedure that contains two integer output parameters. Right before the SqlCommand runs …

c# sqlcommand output-parameter sqlparameter
When would SqlCommand.ExecuteReader() return null?

When using calling the SqlCommand.ExecuteReader() method, ReSharper tells me I have a possible NullReference exception when I use the …

.net resharper nullreferenceexception sqlcommand
Convert SqlCommand Output to List<MyType>?

I am using an ADO.NET SqlCommand with a single SqlDbType.Structured parameter to send a table-valued parameter to a …

linq-to-sql list sqlcommand sqldbtype
How to chain multiple T-SQL statements (separated by GO's) into a single call to SQL using SqlCommand

I have a C# desktop app that calls various SQL Server stored procedures to perform various work of exporting and …

c# .net sql sqlcommand
There was an error parsing the query. [ Token line number = 1,Token line offset = 20,Token in error = - ] C#

I am using a SQL Server Compact 3.5 database file (.sdf) in C#; with the code I can read from albums_…

c# database sqlcommand sdf
Parsing a SQL string in c#

I have the need to Parse a Command.CommandText. I don't want to run the query. I only want to …

c# .net tsql parsing sqlcommand
sql select average from distinct column of table

In my table I have some colms like this, (beside another cols) col1 | col2 s1 | 5 s1 | 5 s2 | 3 s2 | 3 s2 | 3 s3 | 5 …

mysql sql sqlcommand
ExecuteNonQuery() not saving any record

I'm working a WinForms based C# tool which has an attached MDF file based database. I'm trying to use the …

c# database sqlcommand mdf executenonquery