|
Hi guys. Thanks for your suggestion. I'll try it out.
Don't Quit
|
|
|
|
|
|
Howdy,
I am trying to select a range of data within an excel spreadsheet using a SQL query. The two queries below do the trick but I was wondering if there's any way to combine both of these SQL queries into one query?
SELECT * FROM [Retail @home$A11:H46]
SELECT * FROM [Retail @home$J12:Q46]
I've tried:
SELECT * FROM [Retail @home$A11:H46, Retail @home$J12:Q46]
SELECT [A11:H46],[J12:Q46] FROM [Retail @home$]
Without any luck whatsoever.
I was hoping this article http://support.microsoft.com/kb/316934/EN-US/[^] would shed some light on selecting multiple different cell column ranges but it wasn't.
Any help would be very very appreciated!
cheers,
frank grimes
|
|
|
|
|
Can you do a merge on a temp datatable?
You may even try a union in the select
|
|
|
|
|
Thank you for responding.
I tried the UNION ALL SQL Query:
"SELECT * FROM [Retail @home$A11:H46] UNION ALL SELECT [Retail @home$J12:Q46]"
and it threw the following exception:
"Query input must contain at least one table or query."
I am not really sure how I would go about merging a temp datatable. I've investigated but I am still pretty much a newbie regarding datasets and datatables...I will investigate though...
thanks again for the response!
|
|
|
|
|
Error on my part, the UNION does work if you write it correctly
SELECT * FROM [Retail @home$A11:H46] UNION ALL SELECT * FROM [Retail @home$J12:Q46]
|
|
|
|
|
hi
how to resize Image of picturebox ?
i used this code but the following error shown me :
my Code :
this.pictureBox1.Image.Size.Height = int.Parse(this.numericUpDown_Y.Value.ToString());
error :
Cannot modify the return value of 'System.Drawing.Image.Size' because it is not a variable
how to solve my problem ?
thanks
|
|
|
|
|
|
hi
thanks for reply
but i want to resize my image in picturebox.image,(zoom in and zoom out)
wait for other replies.
thanks
|
|
|
|
|
|
Hi, i need to transform the contents of a richtextbox (rtf) to an image.
Any suggestions will be highly appreciated
Thank you
|
|
|
|
|
What have you done so far?
|
|
|
|
|
I display some text in the richtextbox which is bold and italic simple formating. All i want to do is get an image of the richtextbox and use in the DrawImage function I am calling this from my function, printDocument1_PrintPage.
e.Graphics.DrawImage(imageName, new Point(0, 0));
|
|
|
|
|
If you're using .net 2.0 framework you can use the controls DrawToBitmap method.
Let the rich textbox draw itself to a bitmap, then use the Graphics DrawImage method.
-Larantz-
|
|
|
|
|
This might help:
Bitmap screenCap = new Bitmap(this.richTextBox1.Width, this.richTextBox1.Height, PixelFormat.Format64bppArgb);
Graphics myScreen = Graphics.FromImage(screenCap);
int nX = this.Left + this.richTextBox1.Left + SystemInformation.Border3DSize.Width*2;
int nY = this.Top + this.richTextBox1.Top + SystemInformation.CaptionHeight + SystemInformation.Border3DSize.Height*2;
myScreen.CopyFromScreen(nX,nY, 0, 0, this.richTextBox1.Size, CopyPixelOperation.SourceCopy);
myScreen.DrawImage(screenCap,new Point(0,0));
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
It displays just the current screen with nothing on the richtextbox even though i have some default text. I need to display whatever is in the richtextbox store in an image and then i would like to print something like in my printpreview
|
|
|
|
|
In my web app I have a gridview with some records that I can delete and update. The gridview is populated with individual user data. I want to have a single Add New button at the bottom of the Gridview that inserts new cells that I can add information. The app is written in C#.net using asp.net2.0. If any can help please let me know.
|
|
|
|
|
I want to set windows xp registry key to make possible by right click on a file see the item = "Open with AAplic.exe" and run AAplic.exe when the user select that!
How?
|
|
|
|
|
Something like this may help:
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\*\shell]
[HKEY_CLASSES_ROOT\*\shell\openaaplic]
@="Open with AAplic"
[HKEY_CLASSES_ROOT\*\shell\openaaplic\command]
@="C:\\< mypath >\\AAplic.exe %1"
|
|
|
|
|
Yup. This technique works great. Every time I sit down to work on a computer, one of the first things I do is set up the registry like this so that the menu for .dll files and .ocx files include a Register and an Unregister option, calling regsvr32.exe.
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
|
|
|
|
|
Actually, though, I apply this to the dllfile and ocxfile nodes.
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\dllfile\shell]
[HKEY_CLASSES_ROOT\dllfile\shell\Register]
[HKEY_CLASSES_ROOT\dllfile\shell\Register\command]
@="regsvr32.exe '%1'"
[HKEY_CLASSES_ROOT\dllfile\shell\Unregister]
[HKEY_CLASSES_ROOT\dllfile\shell\Unregister\command]
@="@regsvr32.exe /u '%1'"
Then, of course, the same for ocx files, replacing dllfile with ocxfile. Works great!
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
|
|
|
|
|
hello every body .....
i need your help ,i want to fetch the cell ID and LAC from pocket PC mobile .....
so this paramters are in these DLL file but am still have a problem to do it in C#???????????
any body can help me............
|
|
|
|
|
Can't you import those DLLs, and call them in your C# app.
|
|
|
|
|
I could ask someone here at work but ill post this question here..
Lets say I want to setup a client application and I want to send another application jobs to do but send them via the client app on a wireless network. Do you think I should use something like soap to do this? Or is there a better way?
Thanks.
|
|
|
|
|
Web services will work fine. If the apps are going to be located behind the same firewall, use remoting.
|
|
|
|