Menu
  • HOME
  • TAGS

Efficient way of providing SqlDbType?

c#,sqlparameters

new SqlParameter("@name", SqlDbType.Whatever) { Value = value } There are constructor overloads that take all kinds of parameters, but they are perhaps not worth the hassle of specifying each and every argument. The above is probably as simple as it gets. (Note that in some cases you might want to...

How to pass correct object value in SqlParameter for datatype bit?

c#,sqlparameters

bit refers to Boolean so you would pass a boolean value in parameter's value Ex : CmdGetDetails.Parameters.AddWithValue("isExpired", chkExpired.Checked); There is no addtional need to use a if block....

Incorrect syntax near @para and must declare the table variable @para SQL c#

c#,sql,sqlparameters

Table names need to be static. You cannot pass a variable as the table name in SQL: Use this: SqlCommand comm = new SqlCommand(String.Format("INSERT INTO [dbo][{0}] ({1}) VALUES ('@val')", tableName, columnName),conn); comm.Parameters.AddWithValue("@val", someValue); In SQL, you can achieve this with sp_executesql: declare @query nvarchar(4000) = 'INSERT INTO [dbo][' + @tableName...

Multiple INSERT in one query using MySqlCommand

c#,mysql,sql,sqlparameters,sql-parametrized-query

Try it like this: string cmd = "INSERT INTO " + Tables.Lux() + " VALUES "; int counter = 0; foreach (Element e in list) { sql += "(NULL, @Position" + counter + ", @Mode" + counter + ", @Timer" + counter + "),"; command.Parameters.Add(new MySqlParameter("Position" + counter, e.Position)); command.Parameters.Add(new...

SqlParameter for VARBINARY(max) OUTPUT size?

ado.net,varbinary,sqlparameters

Here is the MSDN documentation. https://msdn.microsoft.com/en-us/library/bb399384.aspx - See "Using Large Value Type Parameters" section Passing a "-1" is the correct approach for "MAX" value size. Since it's a VarChar, it won't add add or return any extra chars, only the ones you set in that column. So it should be...

SQL Server : drop table with SQL parameters

sql,sqlparameters,drop-table

You cannot use a parameter for a table name. Although you'll normally get told off around here for building up a query using string concatenation, this is one occasion where you'll need to! SqlCommand com=new SqlCommand("drop table " + name, dbCon); ...