in this we have to show table of 50 to 150 like 50 table from 1 to 10 then 51 table ......150 table i just want to know is there any way i can get this using loop not using nested loop i made the nested loop code to show you what i want on ouput
How to approach this? Not very clear on how hashing works..
Insert the following numbers into a hash table of size 10 (ie an array with 0…9 index position) using a hash function h(k)=(k*71+94)%10 and using Linear Probing.
75, 98, 43,1,-56,93,101,34,23
Insert the following numbers into a hash table of size 10 (ie an array with 0…9 index position) using a hash function h(k)=(k*71+94)%10 and using Chaining.
I am having an issue with my sort function. This is one part of the Hash table program. The main issue is that I am trying to sort the pointer table after all of the values have been entered. The ptr_sort function is not a class function and so I am therefore unable to use the class variables psize and pTable. Is there another way I should be trying this? it is a Vector should I use the sort() function from the vector class in STL?
If a user enters a string of boolean algebra it will ouput the table.
I have input parsing, cycling through the combinations, and outputing working. However once i parse the input I am not sure what to do with it. I have thought of having it write the parsed input to a new file as a function and then use that function, but that seems bad.
How to dynamically create the function, how to implement it.
BTW This is a console function, if that changes anything.
1) Count the number of rows in the table booking that are open and where the booking.postcode is "MK",
2) Take a note of the plot (in booking.plot_id), and then update the table plot.jobs with the value count.
For example running the SQL query when booking table has the following rows:
Would see the following highlighted values in plot.jobs being updated to 1:
I managed to resolve it with this code so far (note I am using Connector/Net):
public void RefreshPlot(){ string query = "SELECT Count(*) AS count, plot_id FROM booking WHERE postcode='MK' AND status='open' GROUP BY plot_id"; var cmd = new MySqlCommand(query, _connection); var da = new MySqlDataAdapter(cmd); var dtCounts = new DataTable(); da.Fill(dtCounts);
[code]....
Currently, my code only checks for existing rows in the booking table and updates the plot table. However if the row gets deleted in the booking, then the changes are not reflected in the plot table.
Example: If we delete the row with plot.id=1 and plot.plot_id=4, then booking.plot_id should go back to being 0, if it was initially 1. At the moment, it doesn't. How would I update my SQL statement to better reflect this? In a sense, it should check for "non-existent" rows, i.e. the impact that the row plot.plot_id=4 & plot.id=1 has on booking.plot_id when deleted?
I have a C# .NET Application which get data from QuickBooks via the ODBC Driver and save the result to C# data table. So, I want to transfer this data table to a mysql table on my own server. That's the code I use:
using System.IO; using MySql.Data.MySqlClient; //Add mysql dll on the .NET Tab in Project's references string connStr = "DSN=QBTest;"; string myServerAddress = "192.168.0.243"; string myDataBase = "CostTest";
I have a problem with this function that adds a new value to the hash table or updates its data if the value already exists:
Code:
int tab_add(tab_disp *td, const object *value) the function should return: TABDISP_OK if the value is correctly added, or TABDISP_ERROR if memory error, or TABDISP_INVALID if pointer td = NULL
The type of structure I am using is the following:
I'd like to get a a field name "eventDateTime" from a DB table and its storage is datetime year to fraction (3) . I have created a function return results like this but i put its type as a int:
int Status::GetEventFromSQL(){ int j = 0; int eventTime = 0; MYSQL_ROW myROW; MYSQL_RES *myRES = NULL;
[code]....
"eventTime " is also declared in another sheet .h as an int. In execution i have a big and negative number ; I know that's because of the int type but i'm bigenner in C++...
I want to declare a 2D 4*4 array, and fills the array with the multiplication table of an integer x from the user, for example: x*1,x*2,x*3, ....., x*16 and how to pass that array to a function to print the array and to another function that swaps a column with another column chosen by the user.
ID Group 0 2 1 2 2 3 3 4 4 4 5 4 6 4 7 4 Code: I want to store ID values on the bases of same Group, like we do in Hash table (key, value) .
Group ID 2 0,1 3 2 4 3,4,5,6,7
so when i said key 2 it will give me 0,1. how can i do it. As first i thought that i can use array of array but then how i can store the value of key. Now I am thinking of hash but i don't know how I will store and retrieve these values.
I have recently run into a problem at work in regards to organizing information for some variables in a table and sorting them based on priority values...
For example:
Case ID: 0 1 2 3 4 1 (2 3) (1 2) (5 1) **the first number in the () is the priority* 2 **the second number is the variable id** 3
So from up above (I made it shorter than mine), I have a table with 8 columns for the different cases and 30 rows for the different conditions possible. I am trying to figure out a way to create some type of function that will be able to run through the row and pick the case with the highest priority first (from 1-8), and output the case ID, the priority, and the second number within the brackets.
I thought about creating a decoder that will sort the values and give an array with the outputs, but I know there must be a smarter way to sort the data.
program in which i have to write a code in c++ to print a periodic table and when any of its element is clicked, it will show the basic details of that particular element. also, use of graphics is required.
I've finally been able to get my coding corrected after doing this for 5 hours and watching numerous tutorials on it... But I now need to create a table. how to create a table with dashed lines like -----------------, both vertical and horizontal.
Another issue I have is that I'm having trouble trying to get a prompt to ask the user how many programs, tests, and quizzes he/she completed with their total points. I got the basic programming done, but need a prompt asking "How many (quizzes, tests, or programs) have you completed?"
Finally, the do-while loop is driving me insane, where I have to set certain values. If it is greater than 2, then I insert formula 1, but if it is less than 2, then I insert formula 2. Whichever way it goes, the total points earned minus the two lowest scores are then calculated into an average.
Code:
#include <iostream> #include <iomanip> #include <string> using namespace std; int main()
[code]....
The whole basis of the program is to calculate the averages of programs, tests, and quizzes done during a semester at a school. The user is asked how many of each category he/she has completed (total points earned and total points possible). All of this is then calculated into a cumulative class average in a table along with points earned and points possible for each category (along with tests and quizzes combined into one average along with individual averages).
bool HashTable::insert(char const * const key, const Player& aPlayer) { //calculate the insertion position (the index of the array) size_t index = calculateIndex(key); for(int i=0; i < capacity; i++) {
[Code] ....
The inserting part works just fine, but the checking for duplicates where I compare the two values is crashing my program.
I want the function to display all accounts deposit list to work properly, what i mean is that the table coming has its contents here and there . I want to align them properly. program in comment.
I'm unable to get the grades to print in the table format, it only takes the homework grades and not the tests and quizes.
// week 8.cpp : Defines the entry point for the console application. // Gradebook 1.cpp :
/*Rewrite the program "Gradebook 1" to contain 1-dimensional arrays. All information entered or calculated within the program is located in an array. The final output(Class Summary) should contain a summary sheet that contains all of the information in table form. */
#include "stdafx.h" #include <stdio.h> #define Size 30//Maximum class size #define max 100//maximum grade #define min 0//minimum grade
[Code] .....
This is my result :
Welcome to the Gradebook Program.
Please enter the number of students: 2 Enter the number of Tests to be averaged: 2 Enter the number of Quizzes to be averaged: 2 Enter the number of Homework assignments to be averaged: 2
I am trying to format a Gregorian Calendar that accepts only the year as a user input, but I want the display to show 3 months on one row. I can get January to display correctly, but the February and March months do not.
I think my loop inside of my calendar1 function specifically is the issue:
//Is day before Sat? Else start next line Sun. if ( ( day + daycode ) % 7 > 0 ) cout << right << setw(3);
I am writing a code in which i need to grab a column from a variety of tables. So basically there are 10 tables in which they hey have the same columns inside of them (Submitted and Amount). I need to grab the amount column from all the tables. What would be the c# sql command for that.