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

  • Sitaare Zameen Par Full Movie Review
     Here’s a  complete Vue.js tutorial for beginners to master level , structured in a progressive and simple way. It covers all essential topi...
  • AI foot tracking model
    I am a student doing a graduation project. I urgently need to deal with this model (I am attaching a link). I've never worked with pytho...
  • Laravel Search String
      Laravel Search String is a package by   Loris Leiva   that generates database queries based on one unique string using a simple and custom...
  • Writing and debugging Eloquent queries with Tinkerwell
    In this article, let's look into the options that you can use with Tinkerwell to write and debug Eloquent queries easier. The post Wr...
  • Laravel - Installation
    For managing dependencies, Laravel uses   composer . Make sure you have a Composer installed on your system before you install Laravel. In t...

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 (69)
  • 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 (4)
  • 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