sqlcommand Questions
30
Solved
The title is my question. I googled and try something like
mysql> !\ clear
mysql> !\ cls
mysql> system cls
mysql> system clear
blah blah ...
but none of them works.
Anyone show me ho...
Soulsearching asked 10/1, 2012 at 17:42
8
Solved
What is the command to list all triggers in a MySQL database?
Rackety asked 6/9, 2008 at 10:2
26
Solved
I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access to my server (windows server 2008-R2). I've received "Server is unavaila...
Acierate asked 22/12, 2011 at 10:15
5
I'm trying to update an MSSQL table using SqlCommand, I think it's a syntax error with my T-SQL, but here is what I have so far:
SqlCommand sqlCmd = new SqlCommand("UPDATE yak_tickets SET email = ...
Pyrexia asked 19/12, 2009 at 22:48
6
I have a SQL Server 2005 database. In a few procedures I have table parameters that I pass to a stored proc as an nvarchar (separated by commas) and internally divide into single values. I add it t...
Elasmobranch asked 8/4, 2011 at 12:56
5
Solved
What I am trying to do is create some arbitrary sql command with parameters, set the values and types of the parameters, and then return the parsed sql command - with parameters included. I will no...
Alveta asked 7/5, 2010 at 14:53
6
Solved
I'm making an C# windows Form Application in visual studio 2010.
That application is connecting to an mysql database, and I want to insert data in it.
Now do I have this part of code:
MySqlConne...
Bulbil asked 27/11, 2012 at 9:24
5
Solved
When using calling the SqlCommand.ExecuteReader() method, ReSharper tells me I have a possible NullReference exception when I use the SqlDataReader object afterwards.
So with the following code:
...
Pelagianism asked 2/7, 2009 at 2:8
9
I am creating a project in which I need to run 2-3 SQL commands in a single SQL connection.
Here is the code I have written:
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;At...
Idiocy asked 3/12, 2012 at 4:51
8
Solved
I am executing a command in this way :
var Command = new SqlCommand(cmdText, Connection, tr);
Command.ExecuteNonQuery();
In the command there is an error, however .NET does not throw any error ...
Itchy asked 11/8, 2011 at 10:10
6
Solved
Is there any difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout in .NET?
Crabber asked 11/5, 2009 at 8:55
6
Solved
I am sending ID as outparameter but its giving error
System.Data.SqlClient.SqlException: Procedure or function
'usp_ClientHistoryItem' expects parameter '@ID', which was not
supplied.
Code ...
Morello asked 21/3, 2012 at 6:18
13
Solved
I am using these lines of code to check if the record exists or not.
SqlCommand check_User_Name = new SqlCommand("SELECT * FROM Table WHERE ([user] = '" + txtBox_UserName.Text + "') ...
Sierra asked 23/1, 2014 at 7:46
4
Solved
Can I use this approach efficiently?
using(SqlCommand cmd = new SqlCommand("GetSomething", new SqlConnection(Config.ConnectionString))
{
cmd.Connection.Open();
// set up parameters and CommandTy...
Statius asked 13/9, 2008 at 22:10
3
Solved
I feel silly for even having to ask this, but I must be missing something.
I am simply trying to open a new SqlConnection to my LocalDB instance on my development machine. Visual Studio 2013.
I...
Seidule asked 8/12, 2014 at 20:24
6
Solved
I usually use code like this:
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString))
{
var command = connection.CreateCommand();
command.Co...
Goshen asked 27/11, 2009 at 10:47
4
Solved
I've got a short piece of code that originally created an SqlDataAdapter object over and over.
Trying to streamline my calls a little bit, I replaced the SqlDataAdapter with an SqlCommand and move...
Dennard asked 25/3, 2011 at 15:49
5
Solved
From the .NET environment can I get access to the full SQL string that is generated by a SqlCommand object?
Note: The full SQL string shows up in Intellisense hover, in VisualStudio, while in deb...
Latonya asked 18/3, 2011 at 18:45
5
Solved
The following method is supposed to peroform a dirty read on an open connection. There are no transactions. Where do I set IsolationLevel?
public string DoDirtyRead(string storedProcName, SqlConne...
Conversable asked 3/12, 2010 at 1:4
8
Not Duplicate! looking for some feature have phpmyadmin during export in command line
I want to export and import a .sql file to and from a MySQL database from command line.
Is there any co...
Everard asked 10/7, 2012 at 5:51
4
Solved
I'm trying to make a back up of my MySQL db and zip the file.
Every time I try to run this command...
C:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump.exe -u usernam -ppassword db_name | gzip > sit...
Cuneo asked 4/7, 2013 at 13:12
3
Solved
What does it mean for an SqlConnection to be "enlisted" in a transaction? Does it simply mean that commands I execute on the connection will participate in the transaction?
If so, under what circu...
Bilbao asked 21/5, 2010 at 19:13
4
Solved
What is the difference between the DENY and REVOKE commands in SQL Server?
Bestir asked 25/4, 2011 at 12:41
3
How to combine output of two or more SELECT statements, I have multiple tables which are having some data that I need to fetch them so I write multiple SELECT query. Now I want to combine result of...
Trossachs asked 13/8, 2013 at 7:59
5
Solved
in my program i need to check if a record in the database already exists in the table using the if statement.
using c# i am trying to do this through an sql connection.
as i supposed that the Execu...
Rebellion asked 27/7, 2013 at 22:29
1 Next >
© 2022 - 2024 — McMap. All rights reserved.