C# :: How To Combine Two SQL Queries Into One
May 21, 2014
update Tag_Master set flag='Inactive' where Tag_no=10;
update Tag_Master set flag='Assigned' where Tag_no=12;
I had these two queries, I just want both of these will fire on same event. Is any other way to write both queries in single query instead of writing two different queries ....
View 4 Replies
ADVERTISEMENT
Oct 31, 2014
I am trying to get a list of queries to work right now. I have it so that the user will input 1 of 5 things to compare twin primes in a list. I am just trying to get the queries working fully before actually determining the twin primes that need to be output. The console input will be something like "<= 61" and will display all twin primes from 3 to 61, inclusive.
Well, I thought I had it 100%... Then I realized I have a problem, though. So, I'm reading the string in until a space so I can read in the number after that. So that works fine, but then I also want the "all" and "random" console inputs to work, but they won't unless I put a space after them, which is what I'm trying to avoid...
So, I tried just simply asking for another console input after all of my if statements for the string compare after the first console input. That obviously doesn't work either, though, because it still only wants the first "getline" where it reads until the whitespace.
How to be able to do both on the same console input... The relevant code is posted below:
cout << endl << "What do you want to know about your list of twin primes?" << endl;
string qprompt1;
string qprompt2;
getline(cin, qprompt1, ' ');
string comp1 = ">";
string comp2 = ">=";
[Code] .....
View 5 Replies
View Related
Sep 27, 2013
I have lot of C++ API exposed in our project and I want to build an application that queries the database and shows some stuff to the user in the UI.
So, essentially, my main code is in the c++ language. What choices do I have over the UI?. I am interested in showing this UI in the form of a html page lilstening to a port.
View 1 Replies
View Related
Feb 1, 2015
I am trying to run the following 2 separate queries but keep getting the following error message:
I've looked at the database and the first query is successful (hence the parameter is not null) but it fails at the cmd.ExecuteNonQuery(); in for (var i = 0; i < _waypointList.Count; i++) { ... }
Code below:
var query =
@"INSERT INTO booking (operator_id, plot_id, postcode, datetime, stops, " +
"mileage, price, passengers, name, note, phone, status, reference) " +
[Code]......
View 2 Replies
View Related
Feb 21, 2014
I have a CDHtmlDialog app in which am trying to add a CSS media query in the HTML file as shown below, but it doesn't work.
@media (max-width:20em) {
table, thead, tbody, tfoot, th, td, tr { display:block; }
tr + tr { margin-top:1em; }
}
The same CSS works fine if i open in a browser like IE, FireFox, Chrome. But inside the CDHtmlDialog app this doesn't work.
I am using Visual Studio 2012 for development and have IE 11 installed in my machine.
View 1 Replies
View Related
Nov 13, 2014
I am having trouble with a program that queries the user for a noun and forms its plural on the basis of these rules:
a. If the noun ends in "y" remove the "y" and add "ies".
b. If the noun ends in "s", "ch", or "sh" add "es".
c. In all other cases, add "s".
I am having trouble getting started.
View 4 Replies
View Related
Jan 14, 2013
I have a buffer which has a virtual width of 1024 pixels with virtual height 768 pixels (actual width stored in GPU.GPU_screenxsize, height in GPU.GPU_screenysize (both uint_32)).
I currently use the following function to plot the pixels to the screen:
inline void GPU_defaultRenderer() //Default renderer {
uint_32 pixel;
int bufferx; //Buffer's x!
int buffery; //Buffer's y!
int bufferxstart; //Buffer's x start!
int bufferystart; //Buffer's y start!
int pspx;
[Code] ...
How to combine the pixels together (blend them into one goal pixel) to get a better view? (Currently it takes the bottom right pixel of the area that represents the goal pixel).
So (x1,y1,x2,y2)->(pspx,pspy) = (bufferystart,bufferxstart,buffery,bufferx)->(pspx,pspy).
Atm this is (x2,y2)->(pspx,pspy)
Btw the pixel format is uint_32 RGBA (only RGB used atm). The psp_graphics_putpixel draws it onto the real VRAM. PSP_SCREEN_ROWS and PSP_SCREEN_COLUMNS represent the destination screen (the real screen)'s height and width in pixels.
View 7 Replies
View Related
Jan 13, 2015
i tried to combine two programs into one.. in my first program it has one class object and main() and my second program it has only one main()
i want to combine these two into one
View 5 Replies
View Related
Jul 19, 2013
How to combine the if statements?
cout<<"Enter a sale number"<<endl;
cin>>rec.sale;
if(cin.fail())
{
cout<<"Enter a number"<<endl;
cin>>rec.sale;
}
[Code]...
View 13 Replies
View Related
Mar 15, 2014
We're working on classes in my programming class, and I have a question about function calls.
Bascially, I have all my set and get functions set up and ready to go.
I was wondering if it was possible to have the user input a variable while calling a function.
for example
cin >> getname();
the user inputs a value that gets passed into getname.
Or does it have to be something like
cin >> name;
getname(name);
mind you all, this isn't code from my program i'm just spitballing here.
View 4 Replies
View Related
Sep 22, 2014
So I've been working on this for awhile and FINALLY got it to work. This is my code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
[Code] ....
As you can see I will have the Name and total right next to eachother.. Problem is I dont want to make a million MySQLCommands for each ID.. Is there a Way I can list all data in each label?
For instance the Select from Text will show all the text from each different ID
and the Select from STOCK-USED as total will show all the total for each ID
Instead of having to list them individually.
Even if I leave it to this
"Select text FROM `parts`";
It selects the 2nd ID in my database and displays its text.. Forgets about the first one completely ...
View 2 Replies
View Related
Jan 6, 2015
how to combine two bytes (each byte is 8 bits wide) in order to get the original value. I am displaying values(from 0 to 500)sent from my microcontroller on the GUI.I can successfully display values from 0 to 255 as this requires just sending a byte. However sending values from 256 to 500 requires sending two bytes. The problem I am having is that I was unable to re-combine the received two bytes in order to get the original value. Below are my lines of code:
int main( void ) // this is the main function inside the microcontroller {
sei();
USI_TWI_Master_Initialise();
Spi_Master_Init();
while(1) // I am using this loop to send 500(111110100) {
Transmitt_Receive(244);//this function sends LOW BYTE of 500(11110100)
_delay_ms(1000);
[code]....
When I combined the two bytes using the above arrangements, instead of getting 500 my GUI displayed 62708.I got the same result when I used BitConverter.
value3 = BitConverter.ToInt32(val,0);
View 7 Replies
View Related
Jun 17, 2014
I am given 2 methods and they want me to create a stand alone class for sql that will change the sql string.
my question is how can i take these 2 methods and make one class out of them that will used on various other forms.
#1
public string AuthenticateWithDB(CUiPontisDatabaseSpecification pdb, string sUserId, string sPassword,
bool bCreatePersistentCookie)
#2
public static void ChangeConnection(Util.ODBC.ODBCDSN odbcInfo, CPonDatabaseVendorType dbType, string uid, string password)
they want it so they can use it like
CUiHttpSessionManager.SimpleDataConnectionString = SomeNewClass.CreateSimpleDataConnectionString()
where some new class is my new class
View 5 Replies
View Related
Mar 16, 2012
Two questions:
1. I have some vector<unsigned char> containing binary data. I would like to combine them into one std::string. How is the correct way to accomplish this?
This is my best guess for sample code:
Code:
vector<unsigned char> data; //conatins some data
vector<unsigned char> data2; //contains more data
string temp(data.begin(), data.end());
temp.append(data2.begin(), data2.end());
Will this code work with binary data, or will it null terminate?
2. A similar problem.. I have some unsigned char* variables, and I want to combine them into one std::string. How can I accomplish this? will the member append() work here? or will it null terminate? Something like:
Code:
unsigned char* data; //conatins some data
unsigned char* data2; //contains more data
string temp(reinterpret_cast<const char*>(data));
temp.append(string(reinterpret_cast<const char*>(data2)));
Will the above sample code work without null termination?
View 4 Replies
View Related
Aug 15, 2013
I want to be able to write a program where I can record user input but combine it with command line arguments. For example I do a simple getline(); and the user types test how to combine it so it could be like test /q and it gives a different output depending on what additional input was added. Can this be done with lots of different inputs?
View 8 Replies
View Related