C#

FirstPrevNext

Re: Request for DB selection Mazdak22-Mar-04 23:59 Mazdak 22-Mar-04 23:59  Access is not for multiuser usage, its a desktop database. You should use SQLServer .(Of course I didn't talk about price & licening) Mazy "Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland Re: Request for DB selection Heath Stewart23-Mar-04 3:51 Heath Stewart 23-Mar-04 3:51  Access can be used for workgroups, but it isn't optimized for such and can be much slower since it is file-based.   Microsoft MVP, Visual C# My Articles Re: Request for DB selection Heath Stewart23-Mar-04 3:56 Heath Stewart 23-Mar-04 3:56  SQL Server has specialized support in the .NET Framework and has since 1.0. Oracle does not as well starting with 1.1 (there was a separate install before, but it wasn't officially supported). Price is definitely a concern with both. Like Mazdak said, though - Access is not optimized for multi-user environments. It's also file-based, and any file-based database solution has major cons. One nice thing about SQL Server, though, is that they have a freely downloadable and distributable desktop engine called MSDE. For all intents and purposes, it is SQL Server. It doesn't support near as many connections (only 10) but supports everything else from transations to backups. You can find more information about it at http://www.microsoft.com/sql/msde[^]. If you installed the defaults for VS.NET, you'll also have the setup on your machine already in the Setup\MSDE directory of your VS.NET installation root. Having applications like VS.NET, FoxPro (last I checked many years ago), Access, Office, and few others gives you redistributable rights to MSDE. Check it out. The really nice thing is that if you ever need to upgrade to the full SQL Server solution, just re-use the same MDF and LDF files from MSDE. Like I said, for all intents and purposes MSDE and SQL Server are the same.   Microsoft MVP, Visual C# My Articles delete temp files hazzem elrefai22-Mar-04 21:12 hazzem elrefai 22-Mar-04 21:12  iam developing application that get binary data from the database(.doc)files and iam storing these file in local files while dealling with it and after i finish i call System.IO.File.Delete(myfile); but most of the time the file doesn't delete so if any one know granteed way to delete my temp files Re: delete temp files Corinna John22-Mar-04 23:47 Corinna John 22-Mar-04 23:47  Files cannot be deleted while they're kept open. Are you sure that you close all stream which accessed the file, before trying to delete it? Re: delete temp files hazzem elrefai23-Mar-04 0:25 hazzem elrefai 23-Mar-04 0:25  i do not make streams with these files these files r doc files and i have activex control on my form opens these files and when the user exits the application these files must be deleted. Re: delete temp files Dave Kreskowiak23-Mar-04 1:50 Dave Kreskowiak 23-Mar-04 1:50  Then your ActiveX controls MUST close the files before the app exists. There must be some way of telling the ActiveX control to close it's files. If not, you're going to have to come up with some kind of shell around your entire app that waits for your app to close, then deletes the files... RageInTheMachine9532 Re: delete temp files Heath Stewart23-Mar-04 3:57 Heath Stewart 23-Mar-04 3:57  The ActiveX control would most likely close the file handles while being disposed, so making sure the temp files are deleted after the ActiveX control is disposed would help.   Microsoft MVP, Visual C# My Articles Re: delete temp files Dave Kreskowiak23-Mar-04 4:29 Dave Kreskowiak 23-Mar-04 4:29  Heath Stewart wrote: The ActiveX control would most likely close the file handles You said it yourself! most likely, but not guaranteed... I say this because I've seen some crappy ActiveX controls come out of Novell that didn't clean themselves up properly. RageInTheMachine9532 Re: delete temp files Heath Stewart23-Mar-04 4:50 Heath Stewart 23-Mar-04 4:50  He seems to be using the Office ActiveX controls which would close the file handles. Like you said, though, there are crappy ones out there that don't. From Novell I don't doubt that!   Microsoft MVP, Visual C# My Articles Re: delete temp files Dave Kreskowiak23-Mar-04 5:20 Dave Kreskowiak 23-Mar-04 5:20  Heath Stewart wrote: From Novell I don't doubt that! You sound like you speak from experience? RageInTheMachine9532 Re: delete temp files Heath Stewart23-Mar-04 5:22 Heath Stewart 23-Mar-04 5:22  With their networking protocols and the like, yes. I just don't like them and with Active Directory and *nix-based networks dominating the market, I can't believe Novell is still around. I guess they think that clinging to open-source will save them. Nothing like jumping on the bandwagon...until it falls off a cliff! Bwahahahaha!   Microsoft MVP, Visual C# My Articles Re: delete temp files Dave Kreskowiak23-Mar-04 5:29 Dave Kreskowiak 23-Mar-04 5:29  On top of all that, it still needs a DOS partition to boot and still relies on 16-bit code in it's kernel. Won't be fixed until NetWare 8 with a complete rewrite of the kernel, if the company survives that long... RageInTheMachine9532 C# Excel Sheet Reading Problems MeMyselfAndDotNet22-Mar-04 20:42 MeMyselfAndDotNet 22-Mar-04 20:42  Hello I have to read an excel sheet from asp.net using C#.i do hold a code minus using the Excel Object. This is my code.. What i need to know from the following code is that The Sheet1$ which i am querying from need not go always under the name Sheet1$.i need to find a way to read the Excel Sheet Tab Names instead of referring them by hardcoding as Sheet1$ Kindly advise.itz very urgent. string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Server.MapPath("./") + "\\uploadedfiles\\Fortek CIS1.xls;Extended Properties=Excel 8.0;"; System.Data.OleDb.OleDbDataAdapter myData=new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); myData.TableMappings.Add("Table", "Fortek CIS1"); DataSet myDataset=new DataSet(); myData.Fill(myDataset); int j=0; while (myDataset.Tables[0].Rows.Count>0) { if (j==43) break; Response.Write(myDataset.Tables[0].Rows[j+1]["name"] + "---------"); Response.Write(myDataset.Tables[0].Rows[j+1]["dept"] + " "); j=j+1; } Re: C# Excel Sheet Reading Problems Heath Stewart23-Mar-04 4:04 Heath Stewart 23-Mar-04 4:04  You'll have to use the Microsoft Office PIAs (Primary Interop Assemblies). If you are using Office 2002 (XP), you can download them from http://www.microsoft.com/downloads/details.aspx?FamilyId=C41BD61E-3060-4F71-A6B4-01FEBA508E52&displaylang=en[^]. If you're using Office 2003 Professional or Developer you can get these from the CD. They are not downloadable unless you're an MSDN Subscriber, though. In that case, however, you can actually use the XP PIAs because the supported interfaces are backwards compatible, at least for the functionality you need. In your code, create a new instance of the ApplicationClass and use ApplicationClass.Workbooks.Open to open your file. You can then enumerate the Sheets property to get the name. Make sure to close the workbook and call ApplicationClass.Quit when done. If you design an effective caching system, you could save yourself a big performance hit by remembering which files have which worksheets if you know they won't change.   Microsoft MVP, Visual C# My Articles Getting the exe path SatyaDY22-Mar-04 20:08 SatyaDY 22-Mar-04 20:08  Hi, Can we get the exe path using C# calls?? I am getting only the special folders path, (like program files, programs, etc). How to get the user created folder paths?? Thanks and Regards, Satya Prasad Re: Getting the exe path partyganger22-Mar-04 20:24 partyganger 22-Mar-04 20:24  Application.StartupPath ? Re: Getting the exe path SatyaDY22-Mar-04 21:03 SatyaDY 22-Mar-04 21:03  Hi, I have started the application like this in a Service called myservice. Process myapp=Process.Start("application path"); Now I want to get the application path (which is hard coded) through the program. With myapp how to find out the path of the exe. Regards, Satya Prasad Re: Getting the exe path hazzem elrefai22-Mar-04 21:09 hazzem elrefai 22-Mar-04 21:09  System.Diagnostics.Process proc = new System.Diagnostics.Process(); proc.EnableRaisingEvents=false; proc.StartInfo.WindowStyle=System.Diagnostics.ProcessWindowStyle.Hidden; proc.StartInfo.FileName=Environment.CurrentDirectory+"\\myexe.exe"; proc.StartInfo.Arguments=myargumentstring; //if u have arguments proc.Start(); Re: Getting the exe path SatyaDY22-Mar-04 21:41 SatyaDY 22-Mar-04 21:41  Hi, Sorry I think my question is not clear. I have some process which starts some exe's. Now I am hard coding those exe's names. What I want the program should get the complete path of the exe and start those exe. Because these exe can be installed anywhere, If I hard code it creates problem. As you said Environment.CurrenDirectory it gives only the process's current directory not the exe's directory which I want to start. Is there any way to get that path of exe. Thanks and Regards, Satya Prasad. Re: Getting the exe path Dave Kreskowiak23-Mar-04 1:58 Dave Kreskowiak 23-Mar-04 1:58  SatyaDY wrote: Sorry I think my question is not clear No kidding.... SatyaDY wrote: Because these exe can be installed anywhere, If I hard code it creates problem. You need some way of determining where those .EXE's are? Did you install them as part of your package? If so, then you could generate an .INI file listing the locations of the .EXE's. Your service could then read that .INI file to get the path to the .EXE's you want to launch. If not, your going to have to come up with a way to find these .EXE's and create an .INI file that can be used by your service. Possibly asking the user where they are? Or writing code to hunt them down? It's up to you... Another method, although less reliable and surely more problematic, would be to write code that searches the drive for the .EXE names you want, then launch them. I think you can see the security and reliability problems with that approach... RageInTheMachine9532 Re: Getting the exe path Heath Stewart23-Mar-04 4:15 Heath Stewart 23-Mar-04 4:15  When executables are in directories listed in the PATH environment variable, they can be executed without specify a directory. If they aren't in the path (including the current working directory), then you need to know where they are up-front like Dave said. If the executable is in the PATH and you still want the full path, use Environment.GetEnvironmentVariable for "PATH", then use String.Split to split the paths into a string[] array using ";" as the delimiter. You can then search those paths in order to find all the paths to the executables. If they aren't in the PATH, then you should either store the paths in the registry or some common file during installation, or creating an RCW (Runtime Callable Wrapper) around the MSI runtime (if you used Windows Installer for your installation of these programs) and query for the executable's component path. There's no automagical way to get this information.   Microsoft MVP, Visual C# My Articles Re: Getting the exe path Sascha Andres25-Mar-04 11:02 Sascha Andres 25-Mar-04 11:02  Hi, since now I used sonething like this: C# System.IO.FileInfo fi = new System.IO.FileInfo(Application.ExecutablePath); GlobalContainer.ExecutablePath = fi.DirectoryName; fi = null; Help states: Property Value The path and executable name for the executable file that started the application. Caveeat: You need to reference System.Windows.Forms. -sa -- http://www.livingit.de http://www.mobile-bookmarks.info http://www.not2long.net User control automatically resized when the parent form is sized in C# jayakarthikeyan22-Mar-04 18:42 jayakarthikeyan 22-Mar-04 18:42  Hello, I have added the user control to a form. How do I listen for form resize event inside my user control. i.e When ever form is resized, i need to resize the user control also. I dont want to use docking property of user control. I tried with the below statement: private void InitializeComponent() { //......... this.TopLevelControl.Resize +=new EventHandler(TopLevelControl_Resize); } But this is throwing NullRefrenceException - Object reference not set to an instance of an object. Is there any other way? Thanks & Rgds Jayakarthikeyan.S Re: User control automatically resized when the parent form is sized in C# Dave Kreskowiak23-Mar-04 1:59 Dave Kreskowiak 23-Mar-04 1:59  Try the Anchor property of the control. RageInTheMachine9532

Last Visit: 31-Dec-99 18:00     Last Update: 11-Jun-24 14:26 Refresh ᐊ Prev1...14066140671406814069140701407114072140731407414075 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.