/// <summary> /// Execute Sql Query with Parameters /// </summary> /// <param name="sData">StoredProcedure Class</param> /// <returns></returns> public static DataSet SqlQueryDataSet(StoredProcedure sData) { DataSet sqlDataView = new DataSet(); try { SqlConnection conn = new SqlConnection(connect()); SqlCommand sqlcomm = new SqlCommand(sData.ProcName, conn); sqlcomm.CommandType = CommandType.StoredProcedure; int i = 0; IEnumerator myEnumerator = sData.GetParams().GetEnumerator(); while (myEnumerator.MoveNext()) { ParamData pData = (ParamData)myEnumerator.Current; sqlcomm.Parameters.Add(pData.pName, pData.pDataType); sqlcomm.Parameters[i].Value = pData.pValue; i = i + 1; } SqlDataAdapter sqlAdapterView = new SqlDataAdapter(sqlcomm); sqlAdapterView.Fill(sqlDataView); return sqlDataView; } catch (Exception ex) { HttpContext.Current.Response.Write(ex); HttpContext.Current.Response.End(); return sqlDataView; } }