C#

FirstPrevNext

Winforms, Datagrids, Hyperlinks and Excel scotlandc22-Dec-05 6:25 scotlandc 22-Dec-05 6:25  Hello, I hope someone can help with this problem. I'm working on an app which reads the company database for a range of scanned images according to user and date. It retrieves a list of all relevant scans and displays the results in a datagrid, date scanned, image location etc. The image is not displayed. When I hit the Export button, the 'grid is made into an Excel spreadsheet and all the images downloaded locally. I need the image location column of the spreadsheet to be a relative hyperlink to the local copy of the images that were downloaded. I can go into the spreadsheet and manually turn every link into a hyperlink which is OK when the result set is only a few lines but there could be hundreds of rows potentially. I want to be able to do it programatically. Any ideas? I've messed about with the text in the spreadsheet as it is written with things like xl.Cells[rowIndex + 1, 5] = "/images/" + filename.Substring(45, 10) + ".jpg"; trying to turn it into a relative link this way but no dice. Any ideas please, as I'm stumped. Thanks in advance and Merry Christmas to everyone Scott scotlandc Menu like functionality VPMahank22-Dec-05 5:23 VPMahank 22-Dec-05 5:23  I need to have a menu with similar look and feel like the MainMenu except that I need to be able to put it anywhere in form( making little flexible). I started having Panel as holding main menu items. I need to provide functionality pretty much same as MainMenu. That means if a menu item has children it should be able to add an arrow to the right and show the sub menus on mouse over and make appropriate menus invisible on mouse out. I would appreciate if anyone would throw some light into it. Thanks in advance, VPMahank open a excel interface in my c# form Sasuko22-Dec-05 5:04 Sasuko 22-Dec-05 5:04  i need to create a table with this value for every row: Text Text Hyperlink Note Text i've to thounght about create an excel table in my form. My question are: 1)How can i control the field so to create hyperlink, set value or delete? 2)I've serched on COM dll about excel but i've found nothing! Where is the excel dll? Re: open a excel interface in my c# form KaptinKrunch22-Dec-05 7:09 KaptinKrunch 22-Dec-05 7:09  Check out the Microsoft PIA's. Book fmardani22-Dec-05 4:41 fmardani 22-Dec-05 4:41  Hi, Could you please recommend one good book on .net 2.0 and sql server 2005 (win or web) Thanks Auto Update for my application .NetRocker22-Dec-05 4:35 .NetRocker 22-Dec-05 4:35  Hi, I have written a software (a windows application) in C#.NET that is used by many clients of our company. Now my supervisor wants me to implement an auto update feature for the application. I think i am looking at a situation where my application needs to call a webservice to know if a newer version exists and if it does, it needs to download and execute the new version. Am I thinking in the right direction? If yes, can anyone provide me with what i need to do exactly? Any ideas will be highly appreciated. Thanks, Sandeep. Re: Auto Update for my application J4amieC22-Dec-05 5:34 J4amieC 22-Dec-05 5:34  Where does the first link lead you?[^] Re: Auto Update for my application Xodiak22-Dec-05 10:57 Xodiak 22-Dec-05 10:57  i had to do something similar at my company...small company here's what i did. we have a networked server that everyone inhouse can access. the version number is located in the assembly of the app and i compare that to a data file located on the server (you can use streamreader to do that, or if you have a database back end that you can have the version information located inside of some table that you can query off of). you will need to make a deployment application (plenty of literature out there on that). here's what i did: -create deployment app (one of the projects that you can put in your solution) and compile: (.msi file is created) -put msi file in shared server directory and resolve the directory path to some web address -when the person logs into the app (im assuming through some login screen), a query is run to check the assembly version of the one on their computer as opposed to the most updated version -if they require an update, this is what you do: -implement the System.Net.WebClient class and download the msi off the server via the web address -use the DownloadFile method of the webclient class -save to a local directory (c:\temp perhaps...or somethign along those lines) -execute the msi process using: System.Diagnostics.Process.Start("c:\TEMP\yourapp.msi") -and then close your application: this.close() or something along those lines -the installation should run as normal and then the user can start up the application again -obvioulsy the version will be correct and this process wont happen again. -read up on deployment applications, im sure you can do something manual like copy each executable manually over the web, but the msi makes it much easier...creats short cuts and everything. only bad thing is that you're going to have to manually install the first version of this on each person's computer best of luck Re: Auto Update for my application .NetRocker23-Dec-05 5:47 .NetRocker 23-Dec-05 5:47  Thank you very much for the tip. I was wondering how i could download files from a web address and you just solved my problem. Cheers! Connecting to a remote DB from a service Marc Clifton22-Dec-05 4:19 Marc Clifton 22-Dec-05 4:19  I'm getting a "Failed to open database using..." error when attempting to connect to SQL Server located on a remote machine, using a user account login. Do I need to use a different Account setting? I'm currently using ServiceAccount.LocalSystem. (and yes, I posted this in the ADO.NET forum too, but forgive me, this forum gets a lot more traffic). Marc VS2005 Tips & Tricks -- contributions welcome! Re: Connecting to a remote DB from a service .NetRocker22-Dec-05 4:54 .NetRocker 22-Dec-05 4:54  I guess you are using a windows service to connect to the database. The settting you have seems to be fine. Make sure the connection string you use has the username and password of an account that has accesss to your database. That should solve your issue. Re: Connecting to a remote DB from a service HerbCSO22-Dec-05 12:56 HerbCSO 22-Dec-05 12:56  You need to be running the service with a different account. LocalSystem is allowed access only to local resources. Sometimes even accessing localhost via TCP/IP will not work with this account! Go to the Control Panel/Administrative Tools/Services, double-click the service and under the Logon tab, change the account to one that is allowed to access the DB (or even just a domain account or even a local account on the server if you're not using Windows authentication to connect to the DB). -- Umm... what's a .sig? ;] HttpApplication talbot22-Dec-05 4:15 talbot 22-Dec-05 4:15  How can I access HttpApplication object within the class which does not belong to the same namespace as the application? Thank you. talbot Re: HttpApplication .NetRocker22-Dec-05 4:55 .NetRocker 22-Dec-05 4:55  Use the full name of the class. MyNamespace.Classname Re: HttpApplication talbot22-Dec-05 4:58 talbot 22-Dec-05 4:58  I don't want access the class, but the current instance of the application. How can I obtain the reference to the app? Re: HttpApplication .NetRocker22-Dec-05 5:23 .NetRocker 22-Dec-05 5:23  Pass the instance of the application as an object in the constructor for your class. Re: HttpApplication talbot22-Dec-05 5:27 talbot 22-Dec-05 5:27  Ok, thank you. Is there any other/elegant aproach how can it be done in case if I have a lot of nested methods? Re: HttpApplication .NetRocker22-Dec-05 5:39 .NetRocker 22-Dec-05 5:39  Well, frankly speaking, I do not see what is not so elegant about passing an object into the constructor. May be if you post some code, I can understand the situation well and could help you if i can. Re: HttpApplication talbot22-Dec-05 5:49 talbot 22-Dec-05 5:49  E.g.: namespace namespace1 { class HttpAppObj : HttpApplication { public s_i = 5; HttpAppObj.method1() { namespace2.cobj2 obj2 = new namespace2.cobj2(); obj2.method2(); } } } namespace namespace2 { class cobj2 { cobj2.method2() { namespace3.cobj3 obj3 = new namespace3.cobj3(); obj3.method3(); } } } ... namespace namespaceN // E.g. N = 20; { class cobjN { protected int i = 0; cobjN.methodN() { namespace1.HttpAppObj appObj = ???Global app instance???; // This is my task... i = appObj.s_i; } } } Sharing global data among accesses to the server talbot22-Dec-05 3:56 talbot 22-Dec-05 3:56  Hi. I want to share data (counter) among clients connected to the ASP.NET server. How could I do that? The data need not be persistent in case of server shutdown. Thank you for your help. talbot Re: Sharing global data among accesses to the server .NetRocker22-Dec-05 4:59 .NetRocker 22-Dec-05 4:59  You must post ASP.NET questions in its respective group.Anyways the answer would be to save the data in the application state. you can share an application state with all the users of your application. treeView child restrictions WetRivrRat22-Dec-05 3:55 WetRivrRat 22-Dec-05 3:55  I want to display the node text after selection in a label. However i need to restrict this display to only the 3rd-child node in the list so in other words, CompanyName - DeptName - UserName - UserPC UserPhone# - Dept1Name - User1Name - User1PC User1Phone# I want to restrict the display of name to only the username, user1name, user2name, etc. nodes, and it needs to stay until the next user name is selected... Once i figure out the restriction portion i'll beable to set the label text static until the next username selection... just would like some assitance with the setting of the node restriction. any ideas? string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity? Anybody out there??? I need some help! WetRivrRat28-Dec-05 4:00 WetRivrRat 28-Dec-05 4:00  I'm guessing that everyone was gone for the holidays, So i'm hopping that by adding to this thread will give it some more visiblity...... Help!!!!! string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity? Re: treeView child restrictions Dave Kreskowiak28-Dec-05 5:54 Dave Kreskowiak 28-Dec-05 5:54  Easy. Each Node has a Tag property. Just set the Tag property to some value that signifies it as a displayable node. TreeNode newNode = new TreeNode(); // Set Tag to 0 for a NON-Displayable node newNode.Tag = 0;   // Set the Tag to 1 for a Displayable node newNode.Tag = 1; When the user selects a node, check its Tag property to see if it should be displayed in your label. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: treeView child restrictions WetRivrRat28-Dec-05 6:30 WetRivrRat 28-Dec-05 6:30  hmm, good catch... but, can't do it all of my nodes (save the root) are loaded by the dataReader, so i am currently loading the node text and tag from the db so i can't edit the tag value unless i create a tag_value coulumn on the db... where i could set the usernames as 1 and all others as 0 unless someone else has a better idea / plan. string Beautiful; Beautiful = "ignorant"; label1.Text = "The world is full of " + Beautiful +" people."; Why is common sense such an un-common comodity?

Last Visit: 31-Dec-99 18:00     Last Update: 7-May-24 2:54 Refresh ᐊ Prev1...11957119581195911960119611196211963119641196511966 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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