using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
namespace WebApplication2
{
public class Class1
{
private string _StrConnectionString;
public string ConnectionString { get { return _StrConnectionString; } set { _StrConnectionString = @"data source="servername"; initial catalog="dbname"; user id="username"; password="password""; } }
SqlConnection SqlConn = new SqlConnection();
private void OpenConnection(string connectionstring)
{
try
{
if (SqlConn.State == ConnectionState.Open)
{
SqlConn.ConnectionString = connectionstring;
SqlConn.Open();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void OpenConnection()
{
try
{
if (SqlConn.State == ConnectionState.Open)
{
SqlConn.ConnectionString = _StrConnectionString;
SqlConn.Open();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void CloseConnection()
{
try
{
if (!(SqlConn.State == ConnectionState.Closed))
{
SqlConn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet FillDataSet(string query, string strConnectionString)
{
DataSet ds = null;
try
{
ds = new DataSet();
OpenConnection(strConnectionString);
SqlDataAdapter da = new SqlDataAdapter(query, strConnectionString);
da.Fill(ds);
da.Dispose();
CloseConnection();
}
catch
{
CloseConnection();
}
return ds;
}
public string ExecuteScalar(string query)
{
try
{
OpenConnection();
SqlCommand SqlCmd = new SqlCommand(query, SqlConn);
string str = (string)SqlCmd.ExecuteScalar();
return str;
}
catch (Exception ex)
{
return ex.Message.ToString();
}
finally
{
CloseConnection();
}
}

Join the conversation! Your thoughts help the community grow.