Insert / Fech Data into database using conncection object.

strConnection = objBase.getConnectionString();
using (sqlCon = new SqlConnection(strConnection))
{
sqlCommand = new SqlCommand();
sqlAdapter = new SqlDataAdapter();
sqlCommand.CommandText = “SP_NAME”;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = sqlCon;

sqlCommand.Parameters.Add(“@USerID”, SqlDbType.VarChar).Value = USERID
sqlCommand.Parameters.Add(“@QueryType”, SqlDbType.VarChar).Value = QueryType;

#region– For Select DATA
sqlAdapter.SelectCommand = sqlCommand;
if (!sqlCon.State.Equals(ConnectionState.Open))
sqlCon.Open();
sqlAdapter.Fill(myDS);
#endregion

#region —– For Insert
// Add output Parameter

SqlParameter param = new SqlParameter(“Output”, SqlDbType.VarChar, 20);
param.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(param);

if (!sqlCon.State.Equals(ConnectionState.Open))
sqlCon.Open();

iTripId = sqlCommand.ExecuteNonQuery();
sMsg = param.Value.ToString();
#endregion
}