ASP.NET

vasanth2vasu wrote:

My main aim is to reduce the CPU work usage.

Quote:

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string strddl;
SqlCommand cmdddl;

Quote:

try
{
conn.Open();
strddl = "INSERT INTO Users (Username,Name,UserID,Password,UserRoles,SecurityAns) VALUES(@user,@name,@id,@pass,@roles,@Sec)";
cmdddl = new SqlCommand(strddl, conn);

cmdddl.Parameters.AddWithValue("@user", TextBox1.Text);
cmdddl.Parameters.AddWithValue("@name", TextBox2.Text);
cmdddl.Parameters.AddWithValue("@id", CID);
cmdddl.Parameters.AddWithValue("@pass", Password.Text);
cmdddl.Parameters.AddWithValue("@roles", Role);
cmdddl.Parameters.AddWithValue("@Sec", TextBox6.Text);
cmdddl.ExecuteNonQuery();


conn.Close();

}
catch (Exception ex)
{
Response.Redirect("~/ErrorPage.aspx");
}

page1.aspx
<asp:Button ID="Save" runat="server" class="styled-button-10"
           PostBackUrl="~/test2.aspx" Text="Save" />

page2.aspx
<script runat="server">

     void Page_Load(object sender, System.EventArgs e)
     {
         Label1.Text = ((TextBox)PreviousPage.FindControl("txtID")).Text;
        Response.Write("" + Label1.Text );
    }
</script>

Abid Hussain-(Abid) wrote:

plzzzzzzzzzzzzzzzzzzzzzzzzzzzzplease