Will the following works?
protected ArrayList checkExistingRec(ArrayList aylExistRec)
{
//retrieving the connection string from the web.config file
string strConn = ConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString;
StringBuilder strCommdText = new StringBuilder();
int intCompID = Convert.ToInt32(Request.QueryString["compID"]);
SqlConnection sqlConn = new SqlConnection(strConn);
SqlCommand sqlComm = new SqlCommand();
sqlComm.Connection = sqlConn;
SqlTransaction sqlTran;
try
{
sqlConn.Open();
sqlTran = sqlConn.BeginTransaction();
sqlComm.Transaction = sqlTran;
for (int i = 0; i < aylExistRec.Count; i++)
{
strCommdText.Append("SELECT * FROM [advSoftwareTrack],[advSoftware] WHERE ([idComp] = " + ...
Go to the complete details ...