Advertisement
Guest User

Untitled

a guest
Aug 18th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Data.SqlClient;
  6. using System.Linq;
  7. using System.Web;
  8. using System.Web.UI;
  9. using System.Web.UI.WebControls;
  10.  
  11. public partial class Test : System.Web.UI.Page
  12. {
  13. private static readonly string connString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
  14. protected void Page_Load(object sender, EventArgs e)
  15. {
  16.  
  17. }
  18.  
  19. protected void Button1_Click(object sender, EventArgs e)
  20. {
  21. SqlConnection con = new SqlConnection();
  22. con.ConnectionString = connString;// ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  23. SqlCommand cmd = new SqlCommand("dbo.STP_Status_Insert");
  24. cmd.CommandType = System.Data.CommandType.StoredProcedure;
  25. string cTitle = "Admin";
  26. cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = cTitle;
  27. cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = cTitle;
  28. con.Open();
  29. cmd.ExecuteNonQuery();
  30. con.Close();
  31.  
  32.  
  33.  
  34. }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement