Tom Gilkison's Q&A profile

• Visual Basic Loading drive into a variable

  I have this little segment of code that I plan on using in a listbox. I want to be able to select the drive in the listbox pulldown, load that to a variable and use it. I've included the basic code below. Dim getInfo As System.IO.DriveInfo() getInfo = System.IO.DriveInfo.GetDrives For Each info As System.IO.DriveInfo In getInfo ListBox23.Items.Add(info.Name) Next Also, does anyone know how to get rid of the double spacing in here Thanks I dont see any double spacing. What version of product are you using and where are you seeing the double spacing Please elabor ...Show All

• SQL Server Error Executing Parallel SQL Tasks

  I have three SQL tasks executing in parallel in an Integration Services package.   +-B-+ A-+-C-+-E   +-D-+ It starts with task A; then B, C, and D all execute in parallel; and finally task E runs after BCD are done. B, C, and D are all Execute SQL tasks, all with the same connection manager. Here is their code: B) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process      FROM temp_B C) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process      FROM temp_C D) SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END AS Process      ...Show All

• Visual C# Extract line number from Exception

  Is there any way to extract the line number from an Exception without having to parse it from the StackTrace property Thanks, wcprog ...Show All

• SQL Server How to Config Virtual Directory for HTTP Access to Achieve XML Template Query in SQL Server2005??

  Hi, I have built a system with xml template query using SQL Server2000. Now ,I want to update it with SQL Server2005. The problem is how to config the virtual directory In SQL 2005 the SQLXML ISAPI virtual directories are no longer being shipped. Instead we have things like SOAP endpoints and ASP.Net that can provide you HTTP access to your data. If these do not work for you, your SQL 2000 virtual directories should work against SQL 2005, and in addition SQLXML 3 SP3 is available as a Web Release and works against SQL 2005: http://www.microsoft.com/downloads/details.aspx FamilyID=51d4a154-8e23-4 ...Show All

• Visual Basic 2005 .Net Nightmare

  As a visB programmer who has been happily coding very successful applications for many years, I have been shocked at the verbose incomprehensibility of the .net framework. Where is the wonderful Basic language that has served so well for so long Is there a way to disable all the garbage in VisB 2005 in order to just write simple single thread applications in the Visual Basic language I have been unable to get even the simplest microsoft SDK examples to run in .Net. I really don't want to invest in learning a language as complex and dense as the .Net applications, I don't believe I will ever need ANY of this functionality. The whole IDEA beh ...Show All

• Windows Forms ToolStripMenuItem Checking

  Hey all, I just downloaded C# Express Edition and am having trouble with the ToolStripMenuItem.  I have started to learn C# and have started creating a windows forms project to play around with.  I have created a form and added a MenuStrip to the form.  Then I added some menu items and some click message handlers.  If I click the to ...Show All

• Visual C# Replacing Nulls in database table

  Hello, I experience the following problem: I have a data table in the database, which includes float and smalldatetime columns. These columns can accept nulls. However when I load the table to the application and fill it to datagrid I do not want the user to see that annoying word "null" in the table. I tried to replace it with empty string but it is impossible since the type of the field is double or datetime. Does anybody know how to solve this problem Thanks. You can set the DataGridColumnStyle.NullText to set the text that is displayed when the column contains a null reference. DataGrid ...Show All

• SQL Server Why getting (null) for all measures in cube?

  I thought I was starting to get the hang of Analysis Services, but have run into something I don't understand. All of a sudden every measure returns (null). I've looked at role and server security. I've reprocessed many times and tried all sorts of subtle changes to the dimensions and the measure groups, but to no avail. Even doing SELECT FROM [Cube Name] gives me (null). Any advice on how to troubleshoot this What parts of the cube's definition and the server's settings should I look into. Any advice would help a great deal... Try working through tutorial for Analysis Services : http://msdn2.microso ...Show All

• SQL Server sub report headings

  i have added in a heading on a sub-report.  It shows up when i run the sub report alone, but when i run the report which as the subreport in it.  The headings do not showup. any ideas ...Show All

• .NET Development How to protect my assembly

  Assembly a.dll is used by application b.exe, while we distribute the application b.exe, a.dll is also shipped together. My question is how to prevent a.dll from abusing by other appliations than b.exe. In other words, I like to make sure a.dll can only be used by b.exe. Is there any ways to achieve this Thanks Pass a security key between the two, and hope that no-one uses reflector to find out what it is. The only way to write secure code is to use C++, even obsfucated code can be reflected on, and read, although it will be, well, obsfucated. ...Show All

• .NET Development TableAdapters BaseClass

  Hi,    I have a problem with the TableAdapters implementation: let's say I want to implement a generic method that takes a TableAdapter and performs some operation on it.     For the sake of example let's say I just want to open the connection the TableAdapter uses:          public void PreOpenConnection(<TableAdapter base class > tableAdapter)    {          tableAdapter.Connection.Open();    }      With the current implementation I would need to accept a Component para ...Show All

• Visual Studio Team System Work Item task via Infopath or Webpage

  Greetings, I would like to allow my internal users to use a Infopath form or Webpage to enter Work Items (specifically bugs, and tasks). This will live in the Sharepoint site for the team project.  Are there any existing forms or pages that I can use for this requirement If there are no existing forms/pages, I am assuming that I can hit a TFS webservice to add a work item. However, I have no idea on how to retrieve the correct webservice/webmethod to call. Is there a reference site with details on the services that are exposed with Team Foundation Server Cheers, -Brad I wish I could give you a be ...Show All

• Windows Forms CLickOnce in AUG CTP doesn't display publisher info???

  Has anyone else seen this I was able to duplicate this by simply creating a Windowsform application and tried to publish it. When the ClickOnce application install dialog came up, all the publisher info was blank. I should also mention it doesn't display the application name or "from" information either. Thanks, Jim Hi Jim, thanks for reporting this issue. This is a known bug that has been fixed in more recent Whidbey RTM builds. Thanks, Sameer ...Show All

• Windows Forms serial port connetion problem

  hi, I'm facing a strange problem while establishing serial connection. Hyperterminal is always connected. so pgm couldn't make the connection. When i discontinue and minimize the hyperterminal connection ,then pgm is working. but not continuously. (If i close my hyperterminal,it automatically gets connected.) after some time, it's giving an error message like "Unable to open the connection". What could be the reason how to make a stable connection I'm using win32 API. Thank U! ...Show All

• SQL Server Restore Database from file

  Hello, I had backed up a database from SQL 2000, just before I format my computer. Now I have installed SQL 2005 and trying to restore that database to it, it doesn't work and I get the following error when doing that =================================== Restore failed for Server 'localhost\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 --------------------- ...Show All