Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Configuration;
- using System.Data;
- using System.Data.SqlClient;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- public partial class Test : System.Web.UI.Page
- {
- private static readonly string connString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- SqlConnection con = new SqlConnection();
- con.ConnectionString = connString;// ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
- SqlCommand cmd = new SqlCommand("dbo.STP_Status_Insert");
- cmd.CommandType = System.Data.CommandType.StoredProcedure;
- string cTitle = "Admin";
- cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = cTitle;
- cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = cTitle;
- con.Open();
- cmd.ExecuteNonQuery();
- con.Close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement