SqlDataSource NameColor = new SqlDataSource();
        NameColor.ConnectionString = ConfigurationManager.ConnectionStrings["AppleConnectionString"].ToString();
        NameColor.InsertCommandType = SqlDataSourceCommandType.Text;
        NameColor.InsertCommand = "INSERT INTO Name (Name, Color) VALUES (@Name, @Color)";
        NameColor.InsertParameters.Add("Name", TextBox1Name.Text);
        NameColor.InsertParameters.Add("Color", TextBox2Color.Text);

        int RowsAffected = 0;
        try
        {
            RowsAffected =NameColor.Insert();
        }
        catch (Exception ex)
        {
            Server.Transfer("Error.aspx");
        }
        finally
        {
            NameColor  = null;
        }
        if (RowsAffected != 1)
        {
            Server.Transfer("Error.aspx");
        }
        else
        {
            Server.Transfer("Successfull.aspx");
        }

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


public partial class _Default : System.Web.UI.Page
{

    static SqlConnection con = new SqlConnection(@"Data Source=divya;Initial Catalog=divproject;Integrated Security=True");

    protected void Page_Load(object sender, EventArgs e)
    {
        TextBox1.Focus();
    
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

        try
        {
            SqlDataAdapter da = new SqlDataAdapter("select * from login where userid like '" + TextBox1.Text + "' and password like '" + TextBox2.Text + "' ", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "login");
            if (ds.Tables["login"].Rows[0][0] != null)
            {
                Session.Add("id", TextBox1.Text);

                Response.Redirect("welcome.aspx");

            }
        }
        catch
        {
            Response.Write("Login failed.........");
            //Response.Write("Enter correct username and password");
        }
  
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        //Application.
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {
    
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox1.Focus();
    }
}