SQLCommand Practice

These are just to understand how to use sqlcommand functions like ExecuteNonQuery(),ExecuteScaler(); etc etc

The C# Part 

string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

SqlConnection mySqlConnection = new SqlConnection(connStr);
        mySqlConnection.Open();
        SqlCommand mySqlCommand = new SqlCommand("update Person set City = 'LHR'", mySqlConnection);
     
        //Use this if you want to use a store procedure
        //mySqlCommand.CommandType = CommandType.StoredProcedure;

        int result = mySqlCommand.ExecuteNonQuery();


The Web.Config Part (windows authentication)



<connectionStrings>
<add name="myConnectionString" connectionString="server=CHILLAX-339\SQLEXPRESS;database=TestingDB;Integrated Security=SSPI;"/>
</connectionStrings>

Comments

Popular Posts

GREYCstoration Oil Paint plugin for Photoshop

Service Bus Gateway service stuck at Starting

PowerApps SubmitForm not clearing People Picker value

Apple iPhone sending SMS automatically 00447786205094

Download file failed signature verification and may have been tampered with - Workflow Manger 1.0 Refresh (CU2)