elmtree95's Q&A profile

• Visual Studio Express Editions ClickOnce trouble with April CTP of Visual C# Express

  I am trying to publish an application to a web server from Visual C# Express. Although the process completes and shows "Publish succeeded", I note the following error messages: File could not be downloaded from https://someserver/somedirectory . The remote server returned an error: (407) Proxy Authentication Required. Unable to view published application at https://someserver/somedirectory/publish.htm. Has anyone seen this before If so, how do I ...Show All

• Visual Basic Can't run SnippetEditor.exe

  it says, "Unhandled exception has occurred in your application. If you click....will close immediately. "Object reference not set to an instance of an object." Details: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at SnippetEditor.Snippe ...Show All

• Visual FoxPro memo file corrupt

  I am getting error 41: "memo file 'name' missing or invalid on one of my tables. Before I did something stupid I want to hear if there are any established ways to salvage the situation. I am getting this error when I am trying to use the file programmatically and also when I browse the table in browser. HOWEVER, in the browser I can read all the memo fields. I can open them up and also they appear in speedtips (It may be a dBase term): I ...Show All

• Visual Basic DataType Conversion help

  Hi, hoping someone may be able to help me convert VB.Net datatype to VB6 datatype. The module I'm working on takes a Dataset from a Web Service and converts it to a VB6 recordset. The problem is datatype selection and conversion. It seems that a case statement wont allow me to use a system datatype ie(System.Int32) as an expression. Public Sub GetRS() Dim newds As New DataSet Dim ws As New localhost.Service Dim value As DataTableCollection Di ...Show All

• Visual Basic MIgration from VB to .Net

  We have a sample code for a VB ASP based system. The objective is to convert the application into a .Net based system. As no specifications are available for the system in hand, business specifications first need to be derived from the sample code and then the system needs to be redveloped based on those specs in .Net. Is it advisable to do so or one should do requirement gathering from the scratch. What parameters can be used for such a decisio ...Show All

• SQL Server Subtotals broken in Report Builder?

  Sub-totals are not working as I would like/expect in an end-user tool when dealing with data from a relational schema with cascading 1-Many relationships.  Instead of performing aggregation at the level of the source table, it is blindly performing aggregation on the result set, causing incorrect results. An simplified hypothetical example will make this clear. Imagine the following relationships: Table "Patients"  related 1-many on p ...Show All

• Visual Studio Tools for Office Get Excel worksheet by index

  Hi there, I would like to get the data in an excel worksheet by the worksheet's order number. For example, If the order of the worksheet order are : WS1, WS3, WS4, WS2 And if the user enters 3, then he/she should read WS4's data. I've tried to implement this using two different approach OLEDB and COM, but both of them are not satification. OLEDB can only get the worksheet in the worksheet's creating order. COM requires the server to ins ...Show All

• Visual Studio Express Editions receiving the auto generated ID for the last row

  Hi, How do I recieve the auto generated row ID of the last row in the table ron Sorted Private Sub newaccount1() Dim rowcount As Integer Dim newaccountTableAdapter As New Database1DataSetTableAdapters.dataTableAdapter Dim newrecordTable As New Database1DataSet.dataDataTable newaccountTableAdapter.Fill(newrecordTable) rowcount = (newrecordTable.Rows.Count) - 1 ...Show All

• Visual C# C# - Namespaces - accessing of sub-namespaces

  Consider the following code snippet, in a file: namespace NamespaceA.NamespaceB.NamespaceC { public class ClassC { public static string StringC { get { return "string c" ; } } } } Now, I want to be able to access the property from within another file. The following works - using NamespaceA.NamespaceB; namespace Tester { public class TesterClass { public string String ...Show All

• SQL Server FMTONLY, LONG Running ?

  Hi There I have been running a trace for long running queries. I know what FMTONLY is, simply returns the metadata of the query. I have found something odd. SQLBatchComplete:SET FMTONLY ON SELECT SETID,FFIG_FIGURE_XX,(CONVERT(CHAR(10),EFFDT_XX,121)),EFF_STATUS_XX,FFIG_TYP_XX,PRCSR_CLASS_XX,SQL_SEL_TXT_XX,RUN_SEQ_AVAIL_XX,DESCR_XX,FFG_COLUMN_XX,FFG_VAL_COL_XX,LASTUPDOPRID_XX,LASTUPDDTTM_XX FROM PS_FFGDFN_XX_VW SET FMTONLY OFF. This performs 0 rea ...Show All

• SQL Server The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid

  Hello, I am getting the following warning in the Application Event Log: The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid. The warning is logged by the SQLBrowser service. This is happening on Windows 2003 server with SQL Server Express 2005. On the same machine SQL Server 2000 is installed. I am currently unable to connect from remote clients to the instance of SQL Express and I bel ...Show All

• .NET Development [VB.net] Add a TimeStamp

  Hi! I already asked something about Accessing an Access-Database in following Thread : http://forums.microsoft.com/msdn/ShowPost.aspx PostID=119542 That works! But now, I've got another question. I want to add a Timestamp into an Access-Database. For that, I tried following code : Dim insertsql As String = "INSERT INTO t_Personal(TIMESTAMP) VALUES(@TIMESTAMP) Try   Dim myconn As OleDbConnection   myconn = New OleDbConnect ...Show All

• Windows Forms How to manipulate forms/objects from sub programs in modules

  Hi at all, I have read "Working with Multiple Forms in Visual Basic.NEt but it don't really helps, maybe I'm rather to old for all this stuff. :-( I'm not able to find a real solution within the forum and the documentation so I try to post my problem and hope someone has a solution for this I have 2 forms - Form1 and Form2 and a module Module1. Form1 has 1 label, Label1, and 2 buttons, button1 and button2 . Form2 has 1 label, ...Show All

• SQL Server Performance Issues with Analysis Services 2005

  Hello I create a cube using SSAS 2005. The cube has 2 years' data. There are 4 dimensions (including date) . Thee are not large dimensions. THe largest dimension has 300 members. (other than the date ofcourse). I am facing serious performance issues while querying the cube. each query (click on a dimension member) takes about 15 seconds. I noticed that SSAS was using only 55 MB of memory - eventhough we have 2 GB on the machine. Th ...Show All

• Visual Basic controlling windows forms

  I am trying to create an application that will allow me to control several windows programs using my own windows interface. There are two Windows programs that I want to control by passing information from my user interface. This way, I will only have to enter the information once. I found a program that allows be to obtain the ControlID for the text boxes, buttons, and menus; but I do not know where to start. I am planning on copying the inform ...Show All