Code Snippet posted by:
Sabarimahesh | Posted on: 6/14/2012 | Category:
C# Codes | Views: 3199 | Status:
[Member] |
Points: 40
|
Alert Moderator
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
try
{
using (SqlConnection connect = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connect;
command.CommandText = "insert into customer(name, address) values(@name, @address)";
command.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar));
command.Parameters.Add(new SqlParameter("@address", SqlDbType.VarChar));
command.Parameters["@name"].Value = name.Text.ToLower();
command.Parameters["@address"].Value = address.Text.ToLower();
connect.Open();
}
}
Life is a Race
Thanks & Regards
By
Sabari Mahesh P M