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

Apple iPhone sending SMS automatically 00447786205094

SharePoint online hub navigation not updating for other users

Service Bus Gateway service stuck at Starting

RangeError: Maximum call stack size exceeded | Node JS | SPFX React