how to set a picture with a specific alignment into excel cell - C# Discussion Boards

Re: Remove case sensitivity

Vikram A Punathambekar11-May-09 2:16

Vikram A Punathambekar

11-May-09 2:16

There are tons of articles that show you how to use XSLT. Google is your friend.

Cheers,
Vikram.

Current activities:
Films: The classic Pink Panther series
TV series: Friends, season 3
Books: Liar's Poker, by Michael Lewis.

Carpe Diem.

creating a directory in the solution during runtime

MustafaHamed11-May-09 1:28

MustafaHamed

11-May-09 1:28

hi,
I'm using this code to create a new directory into the solution during runtime

string targetPath = @"SampleDirectory"; \\directory name without any path to be copied in the solution
Directory.CreateDirectory(targetPath);

this code is working very well & creates the directory into the solution, but the problem arouses whenever I'm using an open file dialogue before this code, in this case the directory is created into the path specified by the open file dialogue not the solution path.

what can I do?

Re: creating a directory in the solution during runtime

ramz_g11-May-09 1:38

ramz_g

11-May-09 1:38

Hi,

You can maintain your solution path in a configuration file, namely App.Config.. Have a class that reads the xml file and get the path assigned to a property.. U can then use this property in your code wherever you wish to use the solution's path...

Hope this helps... Smile | :)

Re: creating a directory in the solution during runtime

Vikram A Punathambekar11-May-09 2:15

Vikram A Punathambekar

11-May-09 2:15

Environment.CurrentDirectory[^] perhaps?

Cheers,
Vikram.

Current activities:
Films: The classic Pink Panther series
TV series: Friends, season 3
Books: Liar's Poker, by Michael Lewis.

Carpe Diem.

Re: creating a directory in the solution during runtime

Dave Kreskowiak11-May-09 5:07

Dave Kreskowiak

11-May-09 5:07

Your code is assuming that the Current Directory is your "solution" path. This is not that case and you should NOT be relying on it. ALWAYS build a fully qualified path to the target folder/file you want when doing file I/O operations.

In your case, I'm assuming you want the new folder to be created in the same folder as your .EXE file. To get the full path to that folder, you can use Application.StartupPath. Then you can use Path.Combine(...) with that path and your new folder name to create the fully qualified path to this new folder and pass that to CreateDirectory.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: creating a directory in the solution during runtime

MustafaHamed11-May-09 7:27

MustafaHamed

11-May-09 7:27

thanks a lot, I used the Application.StartupPath and Path.Combine() and it's working very well.

Highlighting Text in Powerpoint 2007 [modified]

ramz_g11-May-09 1:04

ramz_g

11-May-09 1:04

Hi,
I was just trying to do some coding on highlighting a portion of text in Powerpoint so that I could insert a hyperlink to it. I could achieve it without any difficulty in Powerpoint 2003 and to my surprise, it did not work in Powerpoint 2007... The code that i used is as follows :

((PowerPoint.Application)applicationObject).ActiveWindow.Selection.TextRange.Text = "PPT";
((PowerPoint.Application)applicationObject).ActiveWindow.Selection.TextRange.Select();
((PowerPoint.Application)applicationObject).ActiveWindow.Selection.TextRange.ActionSettings[Microsoft.Office.Interop.PowerPoint.PpMouseActivation.ppMouseClick].Hyperlink.Address = "http://www.google.com";
((PowerPoint.Application)applicationObject).ActiveWindow.Selection.Unselect();

Can anyone tell me what could have gone wrong in the above code?

modified on Monday, May 11, 2009 7:10 AM

how to set a picture with a specific alignment into excel cell

tofa11111-May-09 1:01

tofa111

11-May-09 1:01

Hi to all,

I'm using clipboard to insert images in excel sheet, but I can't change the default alignment for these images,

the default alignment for these images is : top left of the cell

I want to change it to : middle center in the cell

I use microsoft office 11.0 object library.

I use this code to insert my images;

(the code is  written within a for loop)

Microsoft.Office.Interop.Excel.ApplicationClass Exl = new Microsoft.Office.Interop.Excel.ApplicationClass();
                
Clipboard.SetDataObject(dataGridView1.Rows[i].Cells["BarCode"].Value);

range.Select();

object dest = Exl.Cells[i + 1, 4];

and then I past it in the sheet cells,

object kui = Exl.Cells[i+1,4];

Microsoft.Office.Interop.Excel.Range mr = Exl.get_Range(kui, kui);

mr.Cells.Worksheet.Paste(mr, mr);

what I exactly need is just to put my pictures in the middle center of the cells

Thank u all

mohammed was a great prophet

NHibernate data visible in profiler but not written to DB

orinoco7711-May-09 0:20

orinoco77

11-May-09 0:20

Hi,

I've got an issue with NHibernate and it's causing me all sorts of headaches. I have a routine which takes an object and manipulates it into an appropriate state, then supposedly writes it to a database. What I'm seeing is that when I run SQL Profiler against the database, all the inserts and updates I'm expecting are present, but when I go to look at the database itself, the data has not been updated. Anyone ever experienced this? If I go back to Profiler and copy and paste the SQL into Enterprise Manager, then run it, everything happens as expected, the records are created/updated and everything looks fine. Profiler does not give any indication that anything went wrong with the transaction and I'm struggling to see what's going wrong. How can Profiler claim that the data has been written when it manifestly hasn't?

If anyone's got any ideas I'd be really grateful.

Re: NHibernate data visible in profiler but not written to DB

orinoco7711-May-09 2:03

orinoco77

11-May-09 2:03

Ignore me. In fact, don't ignore me, let me serve as an instructional example. Don't forget that NHibernate is going to do some funky stuff with transactions, and if any of your database operations fail, chances are they're all going to fail. Furthermore, you probably won't get to know about it through conventional means either.

Re: NHibernate data visible in profiler but not written to DB

riced11-May-09 5:53

riced

11-May-09 5:53

First class reply Smile | :)

Is there an article about NHibernate gotchas lurking in your experiences? Big Grin | :-D

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis

Re: NHibernate data visible in profiler but not written to DB

orinoco7712-May-09 0:03

orinoco77

12-May-09 0:03

If I get to the end of this project with some hair remaining and my sanity intact then possibly Smile | :)

I'm still having issues with this actually. Everything I see in SQL Profiler now runs fine if I copy it and run it manually, so I don't know where the rollback is coming from. I'm currently wondering if we can just give the users a fancy looking frontend and ask them to write all the important data down somewhere...

Check if drive exists

Rajdeep.NET is BACK10-May-09 23:51

Rajdeep.NET is BACK

10-May-09 23:51

Hi friends,

In C#.NET, in order to verify whether a file exists and take the required action, we use this piece of code:

if (File.Exists(@"D:/whatsup.txt"))
{
//required code
}

Similarly, what will be the code to confirm the existence of a particular drive, say E://, in the system?

Your help will be greatly appreciated,
Rajdeep.NET Smile | :)

Re: Check if drive exists

Alan N11-May-09 0:18

Alan N

11-May-09 0:18

Hi,
Read up on System.IO.DriveInfo

Alan.

Re: Check if drive exists

stancrm11-May-09 1:21

stancrm

11-May-09 1:21

Use:

Directory.Exists(@"p:\"); <- true/false

Draw Line Chart

AlexDuta10-May-09 23:35

AlexDuta

10-May-09 23:35

Hi,
I'm new to Drawing in c#, i want to draw a simple "line chart" (plot).
I have some values (1,3,4,2) and the time when values were taken (10:00, 12:00, 15:00, 21:00).

I want to represent that 2 lists into a chart but don't know how.

Re: Draw Line Chart

Simon P Stevens10-May-09 23:43

Simon P Stevens

10-May-09 23:43

MS have a pack of .net chart controls. Your best bet is to use them. They will support stuff like line charts

Check out these links:
http://code.msdn.microsoft.com/mschart[^]

http://www.microsoft.com/downloads/details.aspx?FamilyId=130F7986-BF49-4FE5-9CA8-910AE6EA442C&displaylang=en[^]

http://www.microsoft.com/downloads/details.aspx?FamilyId=1D69CE13-E1E5-4315-825C-F14D33A303E9&displaylang=en[^]

If you really really want to draw stuff yourself (but I don't recommend it for doing charts) you need to take a look at the Graphics[^] class if your using winforms, or the various drawing libraries[^] in WPF.

Simon

Re: Draw Line Chart

AlexDuta10-May-09 23:51

AlexDuta

10-May-09 23:51

I forgot to say that I'm using Visual Studio 2005 with Microsoft .NET Framework 2.0

In a WindowsForm Application i've used ReportViewer and works fine.
Now I want to do a chart for a Windows Mobile Application, but there i can't use ReportViewer.

Any ideea for drawing chart on a Windows Mobile 6.0 Application?

Re: Draw Line Chart

Simon P Stevens11-May-09 0:11

Simon P Stevens

11-May-09 0:11

Ahh...Sorry, I don't really know much about windows mobile. The MSDN page (below) about the graphics class does say that it's supported on the compact framework, so you could go with that. But it's not exactly simple, you will have to draw every line manually. It might be worth looking around for a chart control that is specifically for the compact framework. (Googling around I can see a few, you'll have to evaluate them and see if any meet your requirements)

http://msdn.microsoft.com/en-us/library/system.drawing.graphics.aspx[^]

Simon

setup project

netDeveloper10-May-09 22:30

netDeveloper

10-May-09 22:30

Hi, I've created a wpf application and i want to create a setup project. I want to use ClickOnce. My problem is how do I use update location considering the fact that i use sql ce database and I don't want changes to affect it. Also, how do I create a certificate in order to not expire after 1 year?
Thank you

Re: setup project

Simon P Stevens10-May-09 23:50

Simon P Stevens

10-May-09 23:50

netDeveloper wrote:
how do I create a certificate in order to not expire after 1 year?

Check out the renewcert tool. It allows you to renew your cert when it expires. I think it also allows you to specify a longer expiry so you don't have to renew it every year.
http://may.be/renewcert/[^]

netDeveloper wrote:
My problem is how do I use update location considering the fact that i use sql ce database and I don't want changes to affect it.

I don't quite understand this question. You specify a location that the app will check updates for. if you make updates that require database changes to a local database you will have to provide that new database with the clickonce update. If you have a local database provided with the app and you need to update it and provide a migration of data from the old copy to the new copy it's probably a bit beyond the scope of click once installation, you should probably be looking at doing a proper client based installation project. Perhaps I've misunderstood your question.

Simon

Re: setup project

netDeveloper11-May-09 0:45

netDeveloper

11-May-09 0:45

I was saying that when i send her a new install that contains updates, it should not modify the local database. I found a solution: modify database name after install(when running application) and use that one. When a new install is applied, it doesn't touch the database, even if i set to uninstall first. I will implement changes to database by hand if needed.
Thank you very much

Re: setup project

Simon P Stevens11-May-09 0:50

Simon P Stevens

11-May-09 0:50

Ahh... I see what you are trying to do.

I think you could also just set the database file to "not included" when you publish the update.

Simon

Re: setup project

netDeveloper11-May-09 0:52

netDeveloper

11-May-09 0:52

And that won't delete the old database?

Re: setup project

Simon P Stevens11-May-09 2:44

Simon P Stevens

11-May-09 2:44

Not sure. Don't think so. Try it first is the best thing to do.

Simon

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.