Friday, September 5, 2008

Send SPName and Parameters

public DataTable GeneralWithConnection(string argStrQuery, string[] arguments, string[] argumentNames)
{
DataTable detailDataTable = new DataTable();
using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
{
if (arguments.Length == argumentNames.Length)
{
SqlConnection myConnection = GetConnection();
myConnection.Open();
SqlCommand objComm = new SqlCommand(argStrQuery, myConnection);
objComm.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < arguments.Length; i++)
{
objComm.Parameters.Add(new SqlParameter(argumentNames[i], arguments[i]));
}
SqlDataAdapter da = new SqlDataAdapter(objComm);
DataSet ds = new DataSet();
da.Fill(ds);

objComm.Dispose();
myConnection.Close();
if (ds.Tables.Count > 0)
{
detailDataTable = ds.Tables[0];
}
}
scope.Complete();
}
return detailDataTable;
}

No comments: