¡@
c# Programming Glossary: conn.openHow to force a SqlConnection to physically close, while using connection pooling? http://stackoverflow.com/questions/1145892/how-to-force-a-sqlconnection-to-physically-close-while-using-connection-pooling using SqlConnection conn new SqlConnection DBConnString conn.Open SqlCommand cmd conn.CreateCommand ... cmd.ExecuteReader CommandBehavior.CloseConnection..
How to execute a stored procedure within C# program http://stackoverflow.com/questions/1260952/how-to-execute-a-stored-procedure-within-c-sharp-program Server local DataBase master Integrated Security SSPI conn.Open SqlCommand cmd new SqlCommand dbo.test conn cmd.CommandType.. conn CommandType CommandType.StoredProcedure conn.Open command.ExecuteNonQuery conn.Close share improve this answer..
Authentication with old password no longer supported, use 4.1 style passwords http://stackoverflow.com/questions/15772479/authentication-with-old-password-no-longer-supported-use-4-1-style-passwords txtDatabase.Text conn new MySqlConnection connStr try conn.Open MessageBox.Show Test Connection Succeded catch MySqlException..
Get output parameter value in ADO.NET http://stackoverflow.com/questions/290652/get-output-parameter-value-in-ado-net cmd.CommandType CommandType.StoredProcedure add parameters conn.Open read output parameter here how conn.Close c# .net ado.net.. cmd.Parameters.Add outputIdParam conn.Open cmd.ExecuteNonQuery Some various ways to grab the output depending..
Can't get sql server compact 3.5 / 4 to work with ASP .NET MVC 2 http://stackoverflow.com/questions/3223359/cant-get-sql-server-compact-3-5-4-to-work-with-asp-net-mvc-2 Northwind .ConnectionString conn.Open using SqlCeCommand cmd new SqlCeCommand SELECT TOP 1 Category..
How to check if connection string is valid? http://stackoverflow.com/questions/434864/how-to-check-if-connection-string-is-valid of course using SqlConnection conn new SqlConnection cs conn.Open throws if invalid If you only know the provider as a string..
C#/SQL - What's wrong with SqlDbType.Xml in procedures? http://stackoverflow.com/questions/574928/c-sql-whats-wrong-with-sqldbtype-xml-in-procedures XmlNodeType.Document null cmd.Parameters.Add param conn.Open cmd.ExecuteNonQuery conn.Dispose Bingo This was done in Visual..
Parsing SQL code in C# [duplicate] http://stackoverflow.com/questions/589096/parsing-sql-code-in-c-sharp new EntityConnection myContext.Connection.ConnectionString conn.Open EntityCommand cmd conn.CreateCommand cmd.CommandText @ Select..
using parameters inserting data into access database http://stackoverflow.com/questions/5893837/using-parameters-inserting-data-into-access-database Data Source Server.MapPath App_Data BookRateInitial.mdb conn.Open OleDbCommand cmd conn.CreateCommand cmd.CommandText @ INSERT.. Data Source Server.MapPath App_Data BookRateInitial.mdb conn.Open DbCommand also implements IDisposable using OleDbCommand cmd..
Read SQL Table into C# DataTable http://stackoverflow.com/questions/6073382/read-sql-table-into-c-sharp-datatable connString SqlCommand cmd new SqlCommand query conn conn.Open create data adapter SqlDataAdapter da new SqlDataAdapter cmd..
Create SQLCE database programatically [duplicate] http://stackoverflow.com/questions/6196274/create-sqlce-database-programatically TABLE FooTable Foo_ID int FooData NVARCHAR 200 conn try conn.Open cmd.ExecuteNonQuery catch Exception ex MessageBox.Show ex.ToString.. conn null try conn new SqlCeConnection connStr conn.Open SqlCeCommand cmd conn.CreateCommand cmd.CommandText CREATE TABLE..
C# calling SQL Server stored procedure with return value http://stackoverflow.com/questions/6210027/c-sharp-calling-sql-server-stored-procedure-with-return-value SqlConnection conn new SqlConnection getConnectionString conn.Open SqlCommand cmd new SqlCommand parameterStatement.getQuery conn.. returnParameter.Direction ParameterDirection.ReturnValue conn.Open cmd.ExecuteNonQuery var result returnParameter.Value share..
Writing large number of records (bulk insert) to Access in .NET/C# http://stackoverflow.com/questions/7070011/writing-large-number-of-records-bulk-insert-to-access-in-net-c new OleDbConnection Properties.Settings.Default.AccessDB conn.Open OleDbCommand cmd new OleDbCommand cmd.Connection conn cmd.CommandText.. new OleDbConnection Properties.Settings.Default.AccessDB conn.Open OleDbCommand cmd new OleDbCommand cmd.Connection conn cmd.CommandText..
Query extremely slow in code but fast in SSMS http://stackoverflow.com/questions/7637907/query-extremely-slow-in-code-but-fast-in-ssms @dt dtpFilter.Value ada.SelectCommand.CommandTimeout 60 conn.Open Logs.Clear ada.Fill Logs Time out exception for 30 sec limit...
|