if (ParamsName != null)
{
SqlParameter OraParams;
for (int i = 0; i < ParamsName.Length; i++)
{
OraParams = new SqlParameter(ParamsName[i], ParamsValue[i]);
cmd.Parameters.Add(OraParams);
}
}
DataSet ds = new DataSet();
using (SqlDataAdapter ad = new SqlDataAdapter())
{
ad.SelectCommand = cmd;
ad.Fill(ds);
}
return ds;
}
}