IamHuM's Q&A profile

• Visual FoxPro How to calculate the data connection time?

  I tried to add 2 fields, time_on, datetime, time_off, datetime to calculate user's log on time in the Users.dbf. How do I calculate the total time between the 2 value Any better way to capture users' activity Somebody just gave a piece of code. cc=time_off - time_on allt(str(INT(cc/3600))),':',allt(str(INT(MOD(cc,3600)/60))),'.',allt(str(MOD(cc,60))) ...Show All

• Visual Basic I've now got.>>

  I was wondering what would be the syntax to achieve an end result of something like this: Dim MyClass as New Class1 With MyClass.User .Name = "Dude" .Email = "Dude@email.com" End With With MyClass.Employee .Name = "Whoever" .Email = "whoever@comp.com" End with I've tried classes within classes, structures within classes; but I keep getting all kinds of errors. This was my last try: Namespace CompanyInfo Public Class Class1 Public Class User Public Name as String Public Email as String Public Referred as String = "Paper" 'A default, doesn't need to be set End Class Public Class Employee Public Name as String Public Email as String ...Show All

• Microsoft ISV Community Center Forums Get Excel Sheet Names

  Hi: I am trying to connect an Excel file and get all sheet names in the file. When using ADO.Net, the sheet names contain letters "$, or ' " around the sheet name, not getting the exact sheet name. I wonder why. I am also trying to get sheet names by using Excel as a Com object in VB.Net, like: myExcel =CreateObject("Excel.Application") myWorkBook=myExcel.WorkBook.Open("my Excel File") For i = 1 to myWorkBook.Sheets.Count     myTableName(i) = myWorkBook.Sheets.Item(i).ToString Next But the code does not work. Does anyone know how Thanks. jiao, please reply to this thread when you get a chance. I think it's important that you follow up for two reasons: 1.) If th ...Show All

• Windows Forms Expandable columns in DataGridView

  Hi, I have to create a customized datagridview to enable the expandable columns. If anyone already worked out this, please help me on this. Thanks in advance, Natraj Guys, you can use a dataset designer (includen in VS) and create the xml squema for your dataset's tables, in there, you can define datarelations between the tables which will therefore make your datagrid show the expandable + signs when you bind that dataset to it. ...Show All

• SQL Server Execute Remote Stored Procedure from the receiver's queue

  How can my receiver's queue procedure execute a procedure on another server Everytime it gets to that remote procedure statement, I get DISCONNECTED_INBOUND status. The procedure I want to call is on SQL 2000. It doesn't work for me. Can you try that I did try using Synonym, that didn't help. Is it a permission issue I did set my Target's queue procedure to execute as owner. ...Show All

• SQL Server Unable to run a report after deployed in a remote server

  Hi All, I encountered the following error after I deployed a report to a remote server. The deployment process was successful, however, when I try to run the reports from the remote report server, It gives me an error message saying: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'SessionOLAP'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors On the other hand, I deployed this report on the local machine and it is running perfect. Do you have any idea how to deal with this problem Thanks! I did wha ...Show All

• SQL Server #&^%@#$ Report services...... OMG how do you set a report parameter in code....

  Here's the error message.. Unable to cast object of type 'Microsoft.Reporting.WinForms.ReportParameter' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WinForms.ReportParameter]'. Here is the code Dim rp = New Microsoft.Reporting.WinForms.ReportParameter Me .RV1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote Me .RV1.ServerReport.ReportServerUrl = New Uri( "http://10.1.1.138/ReportServer/" ) Me .RV1.ServerReport.ReportPath = "/test/rEmailInvoice" rp.Name = "InvoiceNumber" rp.Values.Add( "0618050" ) Me .RV1.ServerReport.SetParameters(rp) <--- get error message here. Me .RV1.ShowParameterPrompts = False ...Show All

• Visual C# Title Bar Color

  Hi, How can i change the Title Bar Back Color of a particular form in C# Thanks Jith you may create custom shape form as the previouse response suggest but if you need to draw your custom titlebar which is called drawing in non client are you need to overried WndProc and handle some Messages like WM_NCPAINT to paint your custom drawing and other message like WM_NCHITTEST, WM_NCLBUTTONDOWN, WM_LBUTTONUP to work with titlebar buttons you can find some example of how to implement it in C++ and Visual basic sorry i dont know any example in c# ...Show All

• Visual C# XML Comment problem...

  if I add an attribute for the property browser it cancels my xml comments from displaying. Is there something I'm doing wrong here is a typical example of what I have... Thanks In Advance, Devin [ Description ( "Gets or sets whether to allow editing of this control. This will enable the drawing and draggin of edit grips to move and resize the control." ), CategoryAttribute ( "Editing" )] /// <summary> /// Gets or sets whether to allow editing of this control. This will enable the drawing and draggin of edit grips to move and resize the control. /// </summary> public bool EditMode { get { return this .editMode; } set { if ( value != t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT files(xgs,xsb,xwb) don't deploy during Publish; getting FileNotFound

  My problem: My game project in XNA uses 2 sounds. I went thru the XACT tutorial(for my uses I found it quite easy to add my .wav files used via XACT), and I now have all code in place, and functioning. When I Start Debugging in XNA, my game runs correctly, and I get the correct audio plays when the proper events cue them up. HOWEVER, once I publish the same project, and install it from the Setup.exe, the installed game crashes. I get the error: system.io.filenotfoundexception. What I have checked already: 1.All 3 XACT files are in my main game directory. 2. All 3 are set to 'always copy' to output directory. 3. All references in the Sound.cs class I created point to the correct XACT files(the build would not run if it did ...Show All

• Windows Forms Disabling TextBox fires Leave event

  Hi, i have a winform designed using Visual Studio 2005 Express Edition. There is one textBox with Leave event for validation purpose. When i programmatically disable the textBox, the textBox's Leave event is fired which is very surprising and not desirable. However, when the textBox is enabled programmatically, the textBox's Leave event isn't fired. Why does textBox's Leave is fired on disabling this control and is there a way to make these two independant Thanks, -srinivas yelamanchili Well, here we are first changing the focus from TextBox1 to TextBox2 (which fires TextBox1 Leave event and is valid). However, with focus on TextBox2 when Button1 is pressed, TextBox1 Leave event is fired when TextBox1 is ...Show All

• Software Development for Windows Vista Tracking consumer defined information

  I am writing a generic workflow service that allows consumers to submit, monitor and manage workflows. Consumers represent different domains and need to identify workflow instances in ways specific to the domain. WF of course provides the workflowInstanceID but I would like to avoid if possible a consumer have to store this ID when they submit the workflow and make queries on it later. I would prefer that the consumer performs queries on a workflow type related to the consumer domain and some additional domain specific information - things like a user or a batchID that it a consumer should understand. I have been looking at whether it is possible to use the tracking database. The kind of information I need to store is fixed for the l ...Show All

• Visual Basic How do i get my "About Dialog" to open when a linklabel is clicked on my form

  How do i get my "About Dialog" to open when a linklabel is clicked on my form ive looked thru the documentation with visual studio and its not very user friendly for newbies so maybe someone can help basically i have a program ive made and i need a "About Program" box dialog to show when i click a link inside the program. please let me know thankyou Anthony,   AnthonyUK wrote: How do i get my "About Dialog" to open when a linklabel is clicked on my form ive looked thru the documentation with visual studio and its not very user friendly for newbies so maybe someone can help basically i have a program ive made and i need a "About Program" box dialog to show when i click a link inside ...Show All

• SQL Server REporitng Services for 2005 Express Advanced

  Good day, I have recently downloaded the SQL Server 2005 Express Advanced. According to the site Reporting Services is included with this and when installing one can see Reporting Services installing so all seems fine. Well, after many days of pulling my hair out I am stuck. All I am trying to do at the moment is view the http://localhost/reports page and I can't. I keep getting an error saying the following: Server Error in '/Reports' Application. I did but I cannot remember what I did. I had all the good intentions of posting my results here but then got caught up in the next project. One thing I did note is that I upgraded IE to Ver. 6, but more than that I cannot remember. I am sorry ...Show All

• Visual Studio Team System Add Nullable Column

  I'm trying to add a nullable column. When I generate the conversion script, instead of doing an ALTER TABLE, it creates a temp table and copies the data. Why What am I missing Thanks What is the script for the old table, and what is the final script for the new table that you are trying to create Also, do you have "Preform Smart column name matching when you add or rename a column" selected That setting can befound under the Database Project Properties->Build tab. ...Show All