|
Thanks - Cider was the keyword I needed to find all the downloads I need. Thanks a ton.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi,
I'm hoping someone can help me with a problem I'm having with an app that reads in an Excel spreadsheet. For each worksheet in the spreadsheet I want to create a DataTable that has the same name as the Excel worksheet. My code currently looks like this:
foreach (Microsoft.Office.Interop.Excel.Worksheet ws in wrkBook.Worksheets)<br />
{<br />
<br />
if (ws.Name != null)<br />
{<br />
this.lstSheets.Items.Add(ws.Name);<br />
strWorksheet = ws.Name.ToString();<br />
System.Data.DataTable ws.Name = new System.Data.DataTable();<br />
}<br />
}<br />
This doesn't work as it thinks I'm trying to reassign an existing object, rather than create a new object with the name of an existing object's property.
Can anyone explain how I can create as many datatables as exists in the spreadsheet file I open, and programmatically give each DataTable the same name as the worksheet from the spreadsheet?
Any assistance would be gratefully recieved!
|
|
|
|
|
You can't. There are no dynamic filenames in C#.
Put the datatables in a collection, like a HashTable.
---
b { font-weight: normal; }
|
|
|
|
|
Guffa, thanks for your response. I'm new to C# and I've not used HashTables before, could I just clarify how this would work in my example?
From looking at what I can find on HashTables, would my code look like this?
<br />
System.Collections.Hashtable h = new Hashtable();<br />
foreach (Microsoft.Office.Interop.Excel.Worksheet ws in wrkBook.Worksheets)<br />
{<br />
<br />
if (ws.Name != null)<br />
{<br />
this.lstSheets.Items.Add(ws.Name);<br />
strWorksheet = ws.Name.ToString();<br />
h.Add(strWorksheet, ws);<br />
}<br />
}<br />
For anyone else reading this post looking for further information, I found a short tutorial on HashTables here:
http://abstractvb.com/code.asp?A=1026
|
|
|
|
|
Now you are putting the work sheets in the hash table. Didn't you say that you wanted to create data tables?
---
b { font-weight: normal; }
|
|
|
|
|
Guffa,
You are correct. I am an idiot. I have fixed that small oversight, and am hopeful it will be plain(ish) sailing from here on in. Thanks very much for your help!
|
|
|
|
|
Yeah, that would work unless the worksheets have the same names - Hashtables do not allow duplicate keys. But you might also use a simple List<Worksheet>
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Question people.
I can easily update my database from my dataset using the oledbadapter.Update method perfectly fine.
But this only is good for select,add, delete, and modify commands on records in the dataset (database)
What i need to do is update the database from my dataset when adding new columns to the dataset.
When i use the oledbadapter's Update method it does not reflect the changes in my access database the newly created columns in the dataset.
Can someone let me know what to do
Thanks in advance
using C#
|
|
|
|
|
Hi,
well the topic says everything: I have a form and I don't want it to be able to get focus. How can I achieve that? I'm using visual c# 2005 express edition, so I could make use of .net 2.0.
Thanks
|
|
|
|
|
You could set focus to the desktop window in your form's handler for the "focus received" event.
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
I'm in a computer programming class at the college I'm attending and I'm having a very difficult time with the program we were assigned. The assignment is this:
Ask the user to enter a single interger. If it is 0 or less display the number 1 as a result. Otherwise, display the result of multiplying all the numbers between 1 and the number the user entered. (Yes, the factorial of the number) If the user enters 5 then the answer to display is 120. That is the result of 1*2*3*4*5. You need to use a "for" loop
If anyone can help me with this, please post code for me. I've struggled with this since last Tuesday and it is due this coming Tuesday. Thanks.
-- modified at 13:58 Sunday 29th January, 2006
|
|
|
|
|
Holly21 wrote: please post code for me
No way. That's not how this works. YOU write the code! We help you with YOUR code, not ours. If we justposted the code for you, you wouldn't learn anything and you'd be screwed over even more on the next assignment.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I recommend first creating a flowchart[^] of actions (eg: "ask user for number", "check if it's zero or less", etc.) that describes the assignment's logic. Then, translate each item in the flowchart to a programming language of your choice (C, C#, etc.).
For example, the "ask user for number" item would translate (in C) to:
printf ("Please enter an integer: ");
The "check if it's zero or less" item would translate (again, in C) to:
if (number <= 0) {
}
Feel free to ask questions if you have problems with a specific part of your program. But be sure to try doing the assignment yourself before asking a question. Soliciting a working program from someone else is nothing but a disservice to yourself. And we don't want to do that - we want you to learn (and enjoy!) programming.
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
hi everyone, happy chinese new year
I wonder how do I change the font size of the text in the tabs in a tabcontrol. I tried changing the tab font, it changes all the fonts in the tabpage also.
Also, is there anyway to increase the size of the arrow buttons when there are too many tabs? I want it LARGe and very visible
thx for your help
|
|
|
|
|
You can put panel with normal font on tabpage - so you will get big font in tabs and normal font for the rest of the controls.
DevIntelligence.com - My blog for .Net Developers
|
|
|
|
|
Hi
I am a little new in the c# business so I would like 2 ask u people for a good C# Programming Exercises source so that I could train the knowledge while reading about it
thx
|
|
|
|
|
inside C# second edition is a really good C# book to buy. Beyond that, there are heaps of examples on this site. Why not work through the book, then download some samples, and examine them after trying to impliment the same hting yourself ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I use this method to copy a part of the screen to a bitmap, and it works well, except for semi-transparent windows, that simply aren't captured.
So I found on the net that the parameter CopyPixelOperation.CaptureBlt would allow to capture semi-transparent windows too, but it simply doesn't work. The captured bitmap is black. I work on Windows XP, so that parameter should be supported.
Here is the code I use
gr.CopyFromScreen(new Point(Control.MousePosition.X - 5,
Control.MousePosition.Y - 5),
new Point(0, 0), new Size(11, 11),
CopyPixelOperation.CaptureBlt);
Any idea or work-around?
___________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA]
|
|
|
|
|
It may be the file format - try saving it as a PNG or GIF to use transparency properly
|
|
|
|
|
The bitmap is displayed on the screen.
Anyway I tried to create a 32bit ARGB bitmap, but id doesn't work: always black.
Thanks for your reply.
___________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA]
|
|
|
|
|
Not 2 weeks ago, there was an article / hack on removing the title bar, form's caption bar, or whatever you want to call it but not the title bar buttons, Im not talking about borderless or fixed window types - I guess, it was a hack.
Think Microsoft Money's interface, its still movable, the title bar is there.. but it's not, you can only do this in Visual Studio 2005.
I know this a little vague - but it's all I got.
Anyone know the article im speaking of ?
Cheers
|
|
|
|
|
I hate the fact that I can't search for Visual Studio 2005 articles ONLY. Can CP possibly add the simple functionality ?
Cheers
|
|
|
|
|
|
Hello,
I want to keep the personal details including a picture of a user and store this information in a database and display later.
I binded the textboxes to a datatable but could not bind the picturebox and the image.
I tried the code below.. How can I handle that??
string selectStudent = "SELECT * FROM Students "; daStudent = new SqlDataAdapter(selectStudent, conn); dsStudent = new DataSet();
cbStudent = new SqlCommandBuilder(daStudent);
daStudent.Fill(dsStudent, "Students");
pictureBox.DataBindings.Add("Byte[]", dsStudent, "Students.Photo");
|
|
|
|
|
You can bind picturebox using Format event
<br />
...<br />
...<br />
Binding binding = new Binding("Image", dsStudent, "Students.Photo");<br />
binding.Format+=new ConvertEventHandler(binding_Format);<br />
pictureBox.DataBindings.Add(binding);<br />
And in Format event you must convert byte [] array to Image
<br />
private void binding_Format(object sender, ConvertEventArgs e)<br />
{<br />
using(MemoryStream stream = new MemoryStream((byte [])e.Value))<br />
{<br />
e.Value = Image.FromStream(stream);<br />
}<br />
}<br />
DevIntelligence.com - My blog for .Net Developers
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
