here is my codes..
namespace ServiceProviderBLL
{
    public class SQLDAL
    {
        private string connectionString;
        private SqlConnection connection;
        private SqlCommand command;
        private SqlDataAdapter adapter;

        public SQLDAL()
        {
            connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        }

        private int errorNumber;
        private string errorMessage;

        public int ErrorNumber
        {
            get { return errorNumber; }
        }

        public string ErrorMessage
        {
            get { return errorMessage; }
        }

               private void CloseSQLConnection()
        {
            connection.Close();
        }

        private void CreateSQLConnection()
        {
            connection = new SqlConnection(connectionString);

            try
            {
                connection.Open();
            }
            catch (SqlException sqlError)
            {
                errorMessage = sqlError.Message;
                errorNumber = sqlError.Number;
            }
            catch (Exception generalException)
            {
                errorMessage = generalException.Message;
                errorNumber = 9999;
            }
        }

        public DataSet GetServiceProviders()
        {
            
            if (connection == null || connection.State == ConnectionState.Closed)
                CreateSQLConnection();

            DataSet dsServiceProviders = new DataSet();
            adapter = new SqlDataAdapter("sp_GetServiceProviders", connection);

            adapter.SelectCommand.CommandType = CommandType.StoredProcedure;

            try
            {
                adapter.Fill(dsServiceProviders);
            }
            catch (SqlException sqlError)
            {
                errorMessage = sqlError.Message;
                errorNumber = sqlError.Number;
            }
            catch (Exception generalException)
            {
                errorMessage = generalException.Message;
                errorNumber = 9999;
            }
            finally
            {
                if (connection != null || connection.State == ConnectionState.Open)
                    CloseSQLConnection();
            }

            return dsServiceProviders;
        }

        public void GetSingleServiceProvider(ServiceProvider provider)
        {
            SqlDataReader reader;
            if (connection == null || connection.State == ConnectionState.Closed)
                CreateSQLConnection();

            command = new SqlCommand("sp_GetSingleServiceProvider", connection);

            command.CommandType = CommandType.StoredProcedure;

            command.Parameters.Add(new SqlParameter("@pint_ServiceProviderId", provider.ServiceProviderId));

            try
            {
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);

                while (reader.Read())
                {
                    provider.ServiceProviderName = reader["nv_Name"].ToString();
                    provider.CEOName = reader["nv_CEOName"].ToString();
                    provider.CEOEmail = reader["nv_CEOEmail"].ToString();
                }

                reader.Close();
                //provider.ServiceProviderName = command.ExecuteScalar().ToString();
            }
            catch (SqlException sqlError)
            {
                errorMessage = sqlError.Message;
                errorNumber = sqlError.Number;
            }
            catch (Exception generalException)
            {
                errorMessage = generalException.Message;
                errorNumber = 9999;
            }
            finally
            {
                if (connection != null || connection.State == ConnectionState.Open)
                    CloseSQLConnection();
            }
        }


and then on the dlgeditserviceprovider page

ublic partial class Controls_Public_Dialogs_dlgEditServiceProvider : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["id"] != null)
        {
            ServiceProvider provider = new ServiceProvider();
            SQLDAL sqlData = new SQLDAL();


            provider.ServiceProviderId = int.Parse(Request.QueryString["id"].ToString());


            sqlData.GetSingleServiceProvider(provider);

            //Response.Write(sqlData.ErrorMessage);

            sqlData = null;

            tbServiceProviderId.Text = provider.ServiceProviderId.ToString();
            tbServiceProviderName.Text = provider.ServiceProviderName;
            tbCEOName.Text = provider.CEOName;
            tbCEOEmail.Text = provider.CEOEmail;

            provider = null;
        }
    }

protected void btnSave_Click(object sender, EventArgs e)
    {
        SqlConnection myCon = new SqlConnection(& #34;server=SECDWEB03;database=ServiceProviderAudits;uid=saprogs;pwd=sasol;connec
tion timeout=120;pooling=false");
        SqlDataAdapter da = new SqlDataAdapter("SELECT int_ServiceProvider, nv_Name, nv_CEOName, nv_CEOEmail FROM tblServiceProviders", myCon);
        SqlCommandBuilder cmd = new SqlCommandBuilder(da);
        DataSet ds = new DataSet();

        da.Fill(ds, "tblServiceProviders");
      

    }