<connectionStrings>
<add name="MyconsString" connectionString="Data Source=ECELON-PC\SQL2008; Database=Registration; Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
Ο κώδικας είναι ο εξής:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Web.Configuration;
using System.Data.Sql;
namespace TEST
{
}
public partial class register : System.Web.UI.Page
{
protected void button1_click(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["MyconsString"].ConnectionString;
string insertSql="Insert into Register (FisrtName,LastName,UserName,Password,Email,Phone,Address) values (@FirstName,@LastName,@UserName,@Password,@Email,@Phone,@Address)";
SqlConnection Con=new SqlConnection("Data Source=ECELON-PC\\SQL2008; UID=sa; database=Registration; Integrated Security=True");
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandType=CommandType.Text;
cmd.CommandText=insertSql;
SqlParameter firstname=new SqlParameter ("@FirstName", SqlDbType.VarChar, 50);
firstname.Value =txtFirstName.Text.ToString();
cmd.Parameters.Add(firstname);
SqlParameter lastName=new SqlParameter ("@LastName", SqlDbType.VarChar, 50);
lastName.Value =txtLastName.Text.ToString();
cmd.Parameters.Add(lastName);
SqlParameter UserName=new SqlParameter ("@UserName", SqlDbType.VarChar, 50);
UserName.Value =txtUsername.Text.ToString();
cmd.Parameters.Add(UserName);
SqlParameter password=new SqlParameter ("@Password", SqlDbType.VarChar, 50);
password.Value =txtPwd.Text.ToString();
cmd.Parameters.Add(password);
SqlParameter Email=new SqlParameter ("@Email", SqlDbType.VarChar, 50);
Email.Value =txtEmailID.Text.ToString();
cmd.Parameters.Add(Email);
SqlParameter phone=new SqlParameter ("@Phone", SqlDbType.VarChar, 50);
phone.Value =txtPhone.Text.ToString();
cmd.Parameters.Add(phone);
SqlParameter address=new SqlParameter ("@Address", SqlDbType.VarChar, 50);
address.Value =txtAddress.Text.ToString();
cmd.Parameters.Add(address);
}
public void checkcheckbox(object o, ServerValidateEventArgs e)
{
if(checkbox1.Checked)
{
e.IsValid=true;
}
else
{
e.IsValid=false;
}
}
public System.Data.SqlClient.SqlConnection con { get; set; }
}