Posted By

fengelz on 04/04/11

Tagged

Versions (?)

Last Edited at 04/04/11 11:20pm

Statistics

Viewed 1277 times

Favorited by 0 user(s)

Related snippets

Inserting Data With C# and parameterized values

/ Published in: C#

Not that theres anything new to this. In fact its very old fashioned, but If you like me forget how its done; snip it.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

using System.Data;
using System.Data.SqlClient;
using System.Configuration;
var connectionStr = ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(CONNECTIONSTR);
cmd.Parameters.Add(new SqlParameter("@name", name));
cmd.Parameters.Add(new SqlParameter("@lastName", lastName));
cmd.Parameters.Add(new SqlParameter("@date",DateTime.Now));
cmd.Connection.Open();
cmd.CommandText =
            "INSERT INTO myTable (email, bannerType, score, name, lastName, date) " +
            "VALUES (@email, @bannerType, @score, @name, @lastName, @date)";
 
var rowsAffected = cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Connection.Dispose();
return rowsAffected;