private void BindGrid() { try { bool IsInt; int RequiredRecords; int requiredamount = 0; // string CSVData, query, qry; IsInt = Int32.TryParse(txtreceipt.Text, out RequiredRecords); if (txtamount.Text != "") { requiredamount = Convert.ToInt32(txtamount.Text); } if (IsInt) { if (TotalRecords >= RequiredRecords || TotalAmount >= requiredamount) { CSVData = GetRandomNumbersCSV(TotalRecords, RequiredRecords); query = "SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY name) AS receiptnoid * FROM accountinfo) TempTable WHERE receiptnoid IN(" + CSVData + ")"; qry = "select amount from accountinfo where receiptnoid in(" + CSVData + ")"; DataTable dt1 = GetRecords(qry); int amount = 0; foreach (DataRow dr in dt1.Rows) { amount += Convert.ToInt32(dr["amount"]); } query = "select * from accountinfo where receiptnoid in(" + CSVData + ")"; lbltotamount.Text = amount.ToString(); dt = GetRecords(query); Grid.DataSource = dt; Grid.DataBind(); lbltotrec.Text = dt.Rows.Count.ToString(); rowcount = dt.Rows.Count; } else { lblmsg.Text = "Sorry!Records or Amount greater than Input Data."; } } else { lblmsg.Text = "Sorry!Pls Check Your Input Data"; } } catch (Exception ex) { lblmsg.Text = "Error! " + ex.Message; } }
public ArrayList RandomNumbers(int max) { ArrayList lstNumbers = new ArrayList(); Random rndNumber = new Random(); int number = rndNumber.Next(1, max + 1); lstNumbers.Add(number); int count = 0; do { number = rndNumber.Next(1, max + 1); if (!lstNumbers.Contains(number)) { lstNumbers.Add(number); } count++; } //while (count <= 10 * max); while (count <= Convert.ToInt32(txtreceipt.Text)); return lstNumbers; } public string GetRandomNumbersCSV(int max, int req) { string CSV = ""; ArrayList lstNumbers = RandomNumbers(max); for (int i = 0; i < req; i++) CSV += lstNumbers[i].ToString() + ","; CSV = CSV.Remove(CSV.Length - 1); return CSV; }
max
req
GetRandomNumbersCSV
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)