using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

/// <summary>
/// Summary description for SqlProccess
/// </summary>
public class SqlProccess
{
    string connectionString;

    public SqlProccess(string connectionString)
    {
        this.connectionString = connectionString;
    }

    public SqlProccess()
    {
        connectionString = ConfigurationManager.ConnectionStrings["BI"].ConnectionString;
    }

    public int ExecuteNonQuery(string sqlString, CommandType type, SqlParameter[] paramArray)
    {
        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand(sqlString, con);

        cmd.CommandType = type;

        if (paramArray != null)
        {
            cmd.Parameters.AddRange(paramArray);
        }

        try
        {
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            return cmd.ExecuteNonQuery();
        }

        catch (SqlException ex)
        {
            throw ex;
        }

        finally
        {
            if (con.State != ConnectionState.Closed)
            {
                con.Close();
            }
        }
    }

    public object ExecuteScalar(string sqlString, CommandType type, SqlParameter[] paramArray)
    {

        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand(sqlString, con);

        cmd.CommandType = type;

        if (paramArray != null)
        {
            cmd.Parameters.AddRange(paramArray);
        }

        try
        {
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            return cmd.ExecuteScalar();
        }

        catch (SqlException ex)
        {
            throw ex;
        }

        finally
        {
            if (con.State != ConnectionState.Closed)
            {
                con.Close();
            }
        }
    }

    public SqlDataReader ExecuteReader(string sqlString, CommandType type, SqlParameter[] paramArray)
    {
        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand(sqlString, con);

        cmd.CommandType = type;

        if (paramArray != null)
        {
            cmd.Parameters.AddRange(paramArray);
        }

        try
        {
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }

            return cmd.ExecuteReader((CommandBehavior.CloseConnection));
        }
        catch (SqlException exp)
        {
            throw exp;
        }


    }
}

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <appSettings>
    <add key="ValidationSettings:UnobtrusiveValidationMode" value="none"/>
  </appSettings>
  <connectionStrings>
    <add name="BI" connectionString="Data Source=yourip;Initial Catalog=AdventureWorks;User Id=mzkir;Password=sifreniz;" providerName="System.Data.SqlClient"/>
  </connectionStrings>
  <system.web>
    <compilation debug="true" targetFramework="4.5"/>
    <httpRuntime targetFramework="4.5"/>
  </system.web>
</configuration>

protected void ButtonGiris_Click(object sender, EventArgs e)
    {
        SqlProccess cmd = new SqlProccess();
        SqlParameter[] paramArray = new SqlParameter[] { 
            new SqlParameter("@Email",SqlDbType.VarChar),
            new SqlParameter("@Sifre",SqlDbType.VarChar)
        };

        paramArray[0].Value = TextBoxEmail.Text;
        paramArray[1].Value = TextBoxSifre.Text;

        string login = "SELECT id,AdSoyad FROM P_Kullanici WHERE Aktif = 1 AND Email = @Email AND Sifre = @Sifre";

        SqlDataReader dr = cmd.ExecuteReader(login, CommandType.Text, paramArray);

        if (dr.Read())
        {
            Session["id"] = dr.GetInt32(0);
            Session["AdSoyad"] = dr.GetString(1);
        }

        Response.Redirect("UserDefault.aspx");
    }