Wednesday, March 28, 2012

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);
        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)

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

No comments:

Post a Comment