|
Nice one, thats exactly the problem, thank you ver much
|
|
|
|
|
Hi Dave. I love your responses to CP questions. Always thorough and informative.
Just thought I'd offer you a virtual for your efforts.
|
|
|
|
|
Hey, Thanks! I'm glad to hear to it!
But, I'm not always this way! I can get rushed by my job and just don't have the time to put in a full answer (maybe I shouldn't answer then ), but I try. I also have lots of room for improvement.
I can get pretty short with some people. Specially when they ask a question like "what's wrong with the object I'm holding behind my back?" and don't give ANY details about the code or error message. I swear, I'm just waiting for the post that says "My app doesn't work." and that's it, nothing else!
But, if the question is a good one and all the necessary tidbits are there to figure out what they're trying to do with the code, I'll take the time to dig up the details of the answer and come up with an example if I can.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I know the feeling - all around
|
|
|
|
|
Hi guys howz!!
I 'm trying to retrieve an image from the DB,how can I get the size of that image and display it on a picturebox,or what else can I use to display an image,'cause the picturebox doestn't have a scroll so as to be able to scroll & see the whole image??
pls help with a c# code.
thanks in advance
|
|
|
|
|
Hi,
You can think of some picture viewers whose controls are available. Google might prove to be best for it.
Hope it might help,
With warm regards,
KEDAR
|
|
|
|
|
If you don't want to try to automatically scale the image, you could also try putting the image control inside a Panel with scrollbars and a fixed size.
As for getting the size of the image, that should not be too hard - if you're retrieving it from a database, you'll have to load the image from a stream, so you should be able to check the length of the byte array fetched from the table.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
Thanks Turbochimp!!
I used a picturebox inside a panel with scrollbars & fixed size,and is working exactly as I wanted.
Thanks a lot Guys!!! ;P
|
|
|
|
|
Hi all,
I'm writting importing data from Excel module. But there is a bug I can't fix.
Example: I have Student Name field (I want type of this field is Text) in Excel file, the value of first row is "John", the value of second row is "901". Then I read data from this file by using ADO.NET, the Student Name column in DataTable I receiving has double type. And the value "John" of first row is lost, it becomes DBNULL.
If I input value "'901" for second row, it will run well. But I dont want to use this way. Is there any way to solve this problem, fixing the type of field in Excel?
Note: I had fix type of field in Excel by using Format Cells, but it didn't work.
Please help me!!!!!
Thanks,
Thai Nam
|
|
|
|
|
You might be helped by knowing that there are some options you can apply in the connection string for your ADO.NET connection. The site http://www.connectionstrings.com is a great reference - here's what it posts for an Excel connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.
I'm thinking in your case you want the IMEX=1 extended property... maybe the HDR=No property too?
|
|
|
|
|
i have a table like this
|Name|Number|
Sasuko 09
Nichol 07
Joy 07
Michael 09
Simon 09
i try with the following query to get the value integer "2" that is the count of all the row have distinct value in this case 09 and 07:
SELECT DISTINCT TableInformation.Kind
FROM TableInformation;
but i get this:
|Temp|
09
07
if i do Select Count('DISTINCT Number') FROM TableInfo i get 5 that is the number of all the rows
then if i do Select Count(DISTINCT Number) FROM TableInfo i can't run couse sintax error!
What is the correct query?
|
|
|
|
|
Already answered in your first thread in the C# Forum...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
is it possible to store a word document in an SQL table? If so what type of field would that be and how would I do that?
Thanks
Tom
Tom Wright
tawright915@yahoo.com
|
|
|
|
|
|
Mike, Do you know if I would be able to open the document back up is the person wanted to edit it? I'm just storing it as a binary right? So if I pull it back out as a binary and save it as a temp for editing, that should work right?
Thanks
Tom Wright
tawright915@yahoo.com
|
|
|
|
|
Hi Tom - yup, that's the rub. You would want your code that accesses the binary in your app to also save it to the user's machine (temp file sounds good) for editing in Word.
|
|
|
|
|
Hai,
In my stored procedure I need to get the field value of "First Name".
So I tried
select First Name from table1
Since the space is coming between First and Name,these words is considered as key words.
So How I can query the table field 'First Name'
Thanks very much.
Pls show me the right way.
Thank You,
Rahul.P.menon
|
|
|
|
|
Hai,
I got it..
Use
select [First Name] from Table1
Thank You,
rahul.P.Menon
|
|
|
|
|
|
toxcct wrote: it is simply not a good thing to place spaces inside identifier names...
consider revising your schema.
Good point by toxcct, could not agree more
|
|
|
|
|
HI,
Im using Visual Studio Express 2005 to develop my application Im just trying to INSERT a MYSQL query into the database.Im using Managed and unmanaged C++ The following is my code:
MySqlConnection^ Mycon = gcnew MySqlConnection("Server=localhost;database=test;UserID=admin;Password=;Port=3306");
Mycon->Open();
MySqlCommand^ cmd = gcnew MySqlCommand("SELECT * FROM Patient", Mycon);
cmd = gcnew MySqlCommand("INSERT INTO patient(PID,Title,FirstName,MiddleName,Surname) VALUES ('+@txtPID+','"+cmbTitle+"','"+txtFname+"','"+txtMname+"','"+txtSurname+"')", Mycon);
I get the following error:
Error:
An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll
Additional information: Duplicate entry '0' for key 1
can someone pleassse help me!!!!
Many thanks
hbjs
makaveli
-- modified at 22:22 Wednesday 18th January, 2006
|
|
|
|
|
sorry i figured it out!
makaveli
|
|
|
|
|
Is there a way to auto-connect to specified database engines when SQL Server Management Studio is started ?
...cmk
Save the whales - collect the whole set
|
|
|
|
|
Simpley register the server under the Database Engine folder in the Registered Servers window.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hmmm, i had done that but the servers only show up in the Registered Servers window, not the Object Explorer window.
I still need to explicitly connect to the servers i want to view in the Object Explorer window.
What i want is for SQL Management Studio to start, not prompt me to connect to a server, and display a list of pre-defined servers in the Object Explorer window.
...cmk
Save the whales - collect the whole set
|
|
|
|