Lecenio's Q&A profile

• .NET Development SQL Server Database Connection

  I posted this question before, but my post was deleted before I got an answer.  So, I'll try again. I have a SQL 2000 database that I access from a web server (IIS)  running on a Windows 2000 Server.  Now that I moved both web pages (ASP) and database to a Windows 2003 Server Enterprise Edition it no longer makes a database connection.  I still have a copy of the web pages on my Windows 2000 server and it opens a con ...Show All

• .NET Development Loading Access DB in Memory, efficient way ?

  Hi, I want to load three ~150 Mb sized Access 2000 DB's in memory to perform a lot of operations. Loading ONE complete DB in DataTables will result in an out of memory exception. The memory of the DataTables blow up to 1,400 Mb. Is there an memory efficient way to hold tables in memory, the tables have around 8 million entries and work with them fast Has anyone sample code or a hint what mechanism to use Thx.... ...Show All

• Visual Studio Tools for Office Outlook add-in error 80010106

  Hi, I have an Outlook add-in which works on most of the time, but I have a computer where i get the following error: Retrieving the com class factory for component with clsid {3FA7DEB3-6438-101B-ACC1-00AA00423326} failed due the folowing error: 80010106 Can any one help regarding this error Thank you! [STAThread] static void Main(string[] args) Adding the STAThread line removed the error for ...Show All

• .NET Development Autonumbers and currency

  I was wondering if currency only applies when you are editing a record as opposed to adding or deleting a record. For example, say there are 2 users that are using some disconnected database software. Each of them starts to add records to their respective datasets at the same time. When they run an update to push the values back to the server, will the autonumbers collide I'm still learning the basics, so any information will help out grea ...Show All

• Visual Studio 2008 (Pre-release) Why can't show the Indigo Service Page?

  I have downloaded the Lab 1: The Fundamentals of Programming the Windows Communication Foundation, follow the lab1 correctly. Build it successfully,but I choose Run from the windows Start Menu,and enter: http://localhost:8000/Derivatives/ IE has no page,error text: Why How can I show the Indigo Service page Thanks a lot!! Koukai Internet Explorer cannot display the webpage Most like ...Show All

• Visual Basic Playing a sound file

  This may have been answered before i am not sure, i am running Visual Studio 2005 beta, i would like to know how i can play a sound file in the background when someone opens a form. Any ideas I am using the my.computer.audio.play function to play an alert. The alert is the result of checking a database for new entries every 10 seconds. If there is a new entry that the software has not seen yet, it uses the VBPower Tools Notificati ...Show All

• Software Development for Windows Vista how do you install vista ???

  i must be an idiot or something ive been trying all week to install vista on my pc with nothing but problems. i have a sata hard drive running windows xp. i also have a fully formatted ide hard drive that i want to install vista onto only. i dont have a dvd burner so i cant burn the iso files to a cd to create a bootable install . i can use a virtual drive ( daemon tools ) for this i believe what is the best thing to do in my case should i ...Show All

• Visual Studio Team System Workitem to Workitem Transition

  I want to customize my Agile Workitem Types so I can be able to do workitem to workitem transition in such a manner: I have a "Customer Inquiry" type with the following states: Open Closed What I want to be able to do is create the following transitions: <empty> ==> Open (New) Open ==> Closed (Answered to the Customer) Open ==> Closed (Bug Detected) ==> New Bug Workitem with the information pro ...Show All

• Windows Forms DataGridView add rows

  Hi, what is the best way to add rows to an unbound DataGridView based on current columns in the grid In a DataTable I have to ability to just call: DataRow r = this.NewRow(); and the row will contain all the columns present in the DataTable. The DataGridView doesn't have that method and I have to create a new row and then add all the columns manually iterating through the grid. I'm wondering if there is a better way to do this Thanks, Tom ...Show All

• SQL Server List of tables in use by a view

  Hi, I wonder if I can list the tables (and views) used inside a view, I mean the list of tables in the FROM clause Thanks, Arty One way is to use SMO like: Database db = srv.Databases[ "test" ]; string a = "sp_depends " + objname; db.ExecuteWithResults(a); There are other ways of using SMO to get the dependency information, but I do not have the code available. Peter ...Show All

• Windows Forms Sample Code: DataGridView progress bar column

  I have a column that has integer data in it, I want to display it as a progress bar in the column so the user can quickly identify lagging processes.   I just started with 2005 and it looks great but does anyone know a quick way to do this I would also like to change the color of the progress bar based on the cells value. I found in the data sources toolbox where I can change the column to progress bar but that does not pass thr ...Show All

• Visual C# WebClient

  Ok. I want to download a file from a server to a specified location using the WebClient.DownloadFile() Method. I also have a progressbar. I want the progress bar to increment in value continuous to the actual progress of the download. Can someone tell me how to do this Add an EventHandler to the DownloadProgressChanged event and increment your progress bar there ala: wc.DownloadProgressChanged += new System.Net.DownloadProgressCh ...Show All

• .NET Development internalprotected access modifier? (not internal protected!)

  Hi forum! I'm currently developing a library type project with a bunch of internal types responsible for internal logic. My problem: i can't use these types in protected methods of  public library types! The compiler quits with an "inconsistent access modifier" error. So my question is, are there any plans to add an "internalprotected" access modifier (i.e. protected -- but only internally) to future c# specs The only solution i can come up ...Show All

• Visual Studio VS 2003 C# Date Convertions Or Comparision

  Hi. I've 2 dates. One in US format, the other one in European format. How do I convert a date to another format or how can I compare these 2 dates. DateTime.CompareTo doesn't work. Hello, I think this question would be most relevant on the .Net Development General forum: http://forums.microsoft.com/msdn/ShowForum.aspx ForumID=39 Thanks, Jeremy Jones ...Show All

• SQL Server What is the best way for users to view cubes?

  Hi, Our company is about to purchase SQL Server 2005 as an upgrade to running the reporting out of MS Access (so I am new to SQL Server). I have been trying out Analysis Services cubes and would like to know how others using SQL Server are allowing users to view cubes. I am using the Cube Browser from within an Analysis Services cube project which is excellent. This made me think that there must be an equivalent program that end users are able t ...Show All