string machineName = "";
string UserName = "";
string Password = ""; 

machineName = TextBoxMachineName.Text;
UserName = TextBoxUserName.Text;
Password = TextBoxPassword.Text;


SqlConnection sqlConn =new SqlConnection();
sqlConn.ConnectionString = "server="+TextBoxMachineName.Text+";user="+TextBoxUserName.Text+";pwd="+TextBoxPassword.Text+";database=Master;";

sqlConn.Open();//baglantı kurulur

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["CreateSite"].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;
        }


    }
}

<connectionStrings>
    <add name="CreateSite" connectionString="Data Source=MEHMET;Initial Catalog=CreateSite;Integrated Security=True" providerName="System.Data.SqlClient" />
  </connectionStrings>

-- read işlemi 
SqlProccess cmdUserId = new SqlProccess();

        SqlParameter[] paramUserId = new SqlParameter[] { 
            new SqlParameter("@SiteName",SqlDbType.VarChar)
        };

        paramUserId[0].Value = SiteName;

        SqlDataReader drUserId = cmdUserId.ExecuteReader("ksel_URLGetUserId", CommandType.StoredProcedure, paramUserId);

        if (drUserId.Read())
        {
            UserId = drUserId.GetInt64(0);
        }

-- insert update 
        SqlProccess cmd = new SqlProccess();
        SqlParameter[] paramArray = new SqlParameter[] { 
            new SqlParameter("@UserId",SqlDbType.Int),
        };

        paramArray[0].Value =UserId;


        cmd.ExecuteNonQuery("ksel_UpdateBigData", CommandType.StoredProcedure, paramArray);