CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

31 July, 2023

Compare rows from the Sqlserver table with the indexes generated in the Array

 Programing Coderfunda     July 31, 2023     No comments   

I have a single TBResult table in Sql Server 2014, with 2,500 saved Results per Contest Number, following format: private Label[] LabelResult = new Label[15]; // dynamically created I need to compare each new draw generated in the [LabelResult] array with the database records and know the number of hits I would have with 11 numbers, how many hits with 12 numbers, how many hits with 13 numbers, how many hits with 14 numbers and how many hits there would be with 15 numbers. like a lottery where you choose 15 numbers from 01 to 25 and win the prize according to the number of numbers you hit. OBSERVATION: the Numbers entered in the array will not be saved in the Database, I only need the comparison with the Results Table. I need it to appear like this in the EX Labels: Summary: You would have scored 11 hits in 250 contests. You would have scored 12 hits in 55 contests. You would have scored 13 hits in 6 contests. You would have made 14 hits in 1 contest. You wouldn't have done 15 hits. try this way but got no results private int NewCount() { ContestResult c = new ContestResult(); int response= 0; DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao); cx.Open(); StringBuilder query = new StringBuilder(); query.AppendLine("SELECT _01, _02, _03, _04, _05, _06, _07, _08, _09, _10, _11, _12, _13, _14, _15 form TBResult," ); query.AppendLine("SELECT value FROM " + LabelResult [0].Text + LabelResult [3].Text + LabelResult [2].Text + LabelResult [4].Text + LabelResult [4].Text + LabelResult [5].Text + LabelResult [6].Text + LabelResult [7].Text + LabelResult [8].Text + LabelResult [9].Text + LabelResult [10].Text + LabelResult [11].Text + LabelResult [12].Text + LabelResult [13].Text + LabelResult [14].Text ); query.AppendLine(" WITH T AS( SELECT *, MatchCount = (SELECT COUNT(*) FROM(SELECT * FROM(VALUES[_01],[_02], [_03], [_04], [_05],[_06], [_07], [_08], [_09], [_10],[_11], [_12], [_13], [_14], [_15]"); query.AppendLine(")V(V)) T) FROM TBResult) SELECT *, RunningTotalForMatchCount = ROW_NUMBER() OVER(PARTITION BY MatchCount ORDER BY Contest) FROM T ORDER BY Contest"); SqlCommand cmd = new SqlCommand(query.ToString(), cx.ObjetConexao); cmd.CommandType = System.Data.CommandType.Text; response= = cmd.ExecuteNonQuery(); cmd.Connection = cx.ObjetConexao; return response; } my Class Generate randoms in order and not repeated. private void ShowArray() { int[] OrganizedNumbers = new int[15]; Array.Sort(OrganizedNumbers); for (int i = 0; y < 15; i++) { LabelResult[i].Text = OrganizedNumbers[i].ToString("D2"); } } private void Generator() { RandomClass rnd = new RandomClass(); int[] luckyNumbers = rnd.non-repeatingGenerator(15, 1, 25); Array.Sort(luckyNumbers ); Control[] controls = LabelResult for (int i = 0; i < controls.Length; i++) { int value = (luckyNumbers [i]; controls[i].Text = value.ToString("D2"); } }` my button would be like this private void btnGenerateArray_Click(object sender, EventArgs e) { ShowArray(); //int operationsPerformed = NewCount(); //if operationsPerformed == 11) //{ // lblResult11.Text = operationsPerformed.ToString(); //} //else if operationsPerformed == 12) //{ // lblResult12.Text = operationsPerformed.ToString(); //} //else if operationsPerformed == 13) //{ // lblResult13.Text = operationsPerformed.ToString(); //} //else if operationsPerformed == 14) //{ // lblResult14.Text = operationsPerformed.ToString(); //} //else if operationsPerformed == 15) //{ // lblResult15.Text = operationsPerformed.ToString(); //} } My model is like this: public class ContestResult { public ContestResult() { this.Contest = 0; this._01 = 0; this._02 = 0; this._03 = 0; ... this._14 = 0; this._15 = 0; } public ContestResult(int Contest, int _01, int _02, int _03, int _04, int _05, int _06, int _07, int _08, int _09, int _10, int _11, int _12, int _13, int _14, int _15) { this.Contest = contest; this._01 = _01; this._02 = _02; this._03 = _03; ... this._14 = _14; this._15 = _15; } private int contest; public int Contest { get { return this.contest; } set { this.contest = value; } } private int _01; public int n_01 { get { return this._01; } set { this._01 = value; } } private int _02; public int n_02 { get { return this._02; } set { this._02 = value; } } private int _03; public int n_03 { get { return this._03; } set { this._03 = value; } } ... private int _14; public int n_14 { get { return this._14; } set { this._14 = value; } } private int _15; public int n_15 { get { return this._15; } set { this._15 = value; } } } I'm new to this topic and I want to learn; I researched a lot and I didn't find something that answers my question.
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Credit card validation in laravel
      Validation rules for credit card using laravel-validation-rules/credit-card package in laravel Install package laravel-validation-rules/cr...
  • Write API Integrations in Laravel and PHP Projects with Saloon
    Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
  • iOS 17 Force Screen Rotation not working on iPAD only
    I have followed all the links on Google and StackOverFlow, unfortunately, I could not find any reliable solution Specifically for iPad devic...
  • C++ in Hindi Introduction
    C ++ का परिचय C ++ एक ऑब्जेक्ट ओरिएंटेड प्रोग्रामिंग लैंग्वेज है। C ++ को Bjarne Stroustrup द्वारा विकसित किया गया था। C ++ में आने से पह...
  • Python AttributeError: 'str' has no attribute glob
    I am trying to look for a folder in a directory but I am getting the error.AttributeError: 'str' has no attribute glob Here's ...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (68)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • July (2)
  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

Loading...

Laravel News

Loading...

Copyright © CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda