Jurciks's Q&A profile

• .NET Development Accessing folders

  I have an application that accesses some files that are nested in folders. Every folder may have other folders and files. So i 'm asking if is any function that gets the files and subfolders of a folder Thank You absolutely. Take a look at the System.IO namespace, and look at the Directory class. The class contains functions to getFiles and get directories. you may wish to make a recursive method (a method that calls itself) to dig deep into directories and get files. Here is the information about the class(es) http://msdn2.microsoft.com/en-us/library/system.io.directory.getdirectories.aspx http://msdn2.microsoft.com/en-us/library/system.io.directory.getfiles.aspx an exam ...Show All

• Visual Basic Best method Connecting from VB6

  I'm currently working on a project that is going to read/write lot of data into a SQL EXPRESS 2005. What is BEST WAY(faster and reliable) for connecting, reading, writing updating from VB6... The code below is working except the RecordCount that always returns -1 I've tried to do a Movelast before, doing so produce this error --> rowset does not support fetching backward Private ObjConn As New ADODB.Connection Private ObjRS As New ADODB.Recordset ... in a function.... Dim i As Integer, j As Integer With ObjConn .ConnectionTimeout = 30 .CommandTimeout = 30 .Provider = "SQLOLEDB" .ConnectionString = "Driver={SQL Native Client};Server=MACHINE\SQLEXPRESS;Database=DSD;UID=sa;PWD=MYPass;" End W ...Show All

• .NET Development web service look up

  Hi, How do I access a web service method in C# to retrieve a paremeter value Thanks, Can you be a bit more specific Do you want to call a method of a web service Have you got a WSDL definition of the webservice E.g. ASP.Net WebServices can expose their WSDL by adding wsdl after their URL. Add that WSDL as a web reference to your project - see the context menu of your References folder in the solution view. That will create a proxy class. The class has one method for each WebService method. Just create an object of that class and call the methods to invoke the WebService. Does that answer your question -- SvenC ...Show All

• Visual Studio Express Editions Movement questions

  I Just began designing with Visual Basic, and just completed the tutorial.   I'm creating a game at the present and i have three questions. First, how do you make a single object move around. Secondly, how do you allow an object to be dragged about, and dropped somewhere Finally, What code will make everytime you click abutton, a picturebox will apear, and the object will move to the right a small bit   Thank you for your answers! I think he's talking about mouse capture: Public Class Form1 Dim MDown As Boolean Dim Formloc As Point Dim pbLoc As Point Dim CaptionHeight As Integer = System.Windows.Forms.SystemInformation.Captio ...Show All

• Visual Studio How to Reset My VS Profile/Settings?

  Hiya I need to reset or remove my VS 2005 Team System for Software Developers settings. What I want is for VS to think that I am starting it for the first time. This is to solve a problem I am having with VS not recognising the Orcas Extensions I installed but only for my profile. If another user logs in and starts VS, it shows the "Starting VS for the first time" dialog and then they can create WPF projects without a problem. If I log in I can't create these projects as it thinks they are not supported. As a workaround I am currently logged in as me, but running VS as local Adminsitrator and connecting to the TS server as me and it works so it must be some setting somewhere that's wrong in my profile. Can anyone help wi ...Show All

• Visual Basic textbox visible priority set to "false" will not keep value

  Hi, This should be simple to do but I just can't figure how to fix the problem. I have a form with one master table and 20 other tables showing related data. The data is linked by the key value in the master form. For example, I have a "Long_Desc" variable in the master table which holds the ky value for the descriptions I keep in the "descriptions" table. Maybe I am doing this wrong but I in my test, I was displaying the content of the key "Long_Desc" in a read-only TextBox just to make sure I was getting the right record from the "descriptions" table. I could also display the content of the "Long_Desc" TextBox using a messagebox. Now, I would like to hide the the "Long_Desc" field on the form. I set the "ReadOnly" priority to True and "T ...Show All

• SQL Server Maxis 3G Connection

  I cannot connect to SQL Server 2000(Remote Server) through Maxis 3G connection. The remote server does not has firewall. I'm using Windows Application to connect to SQL Server 2000. dim strsqlcon as string = "Server=000.000.000.000;databse=dbname;usr=sa;pws=1234" dim sqlcon as sqlconnection = new sqlconnection(strsqlcon) sqlcon.open() "It's Error : Sql not exist or access denied." But I can connect to SQL Server 2000(Remote Server) through Local Area Connection. Have any solution Thank you. I can ping the server through 3G Connection. Result : "Reply from xxx.xxx.xxx.xxx: bytes=32 time=369ms++ TTL=115" ...Show All

• Visual Basic Single Instance Windows Forms Applications

  I've searched the net for awhile and couldn't find a solution. Let's take Photoshop as an example. It runs in single instance mode and any new image opened by user is handled by the single instance. That is, the single instance has the address of the new image as an argument. I wanted to implement this concept with Mutex but coudn't find a way to pass the address of the new document. Any help in C# or VB.NET is appreciated! you could also detect the number of instances that the application has. So if there is already an instance (> 1) then you could just quit the new instance.... Dim theProcesses() as System.Diagnostics.Process.GetProcessesByName(Application.ProductName) if theProcesses.Len ...Show All

• Visual C++ calling sleep in header function causes wrong thread to sleep

  I'm experimenting with the BackgroundWorker and have a problem. If I use the Sleep method inside the dowork method the thread correctly sleeps, but, if I put the Sleep call in a function defined elsewhere in the code the main form sleeps. Does this only depend on the position of the call Is there a way to avoid it The sleep will be performed on the thread that is calling it. If you put a breakpoint on that line, you should see the thread calling it. Whether it is in a header function or somewhere else isn't relevant. ...Show All

• SQL Server Need help using GROUP BY clause

  I have two tables A. TEST_SUBJECTS_TBL with the following columns . This table contains the subjects in a test 1. TEST_SUBJECT_ID PK 2. SUBJECT_ID FK 3. TEST_ID FK 4. PM // This is the passing marks for the subject B. TEST_MARKS_TBL with the following columns This table stores the marks scored by students for each subject 1. TEST_SUBJECT_ID FK 2. STUDENT_ID FK 3. MARKS_OBTAINED I need a query which gives me the max, min,avg marks obtained in each subject for a test and the total number of students who have passed in the subject The query output should be something like this ___________________________________________________________________ SubjectID MaxMarks MinMarks AvgMarks TotalStudentsPassed _______ ...Show All

• SQL Server SSIS Transactions 101

  I want to truncate a table (remove all of its data) using an "Execute SQL task" and then populate that table using a Data Flow task. In case of failure, I want to "rollback" the table to its state prior to its truncation. Can this be done using SSIS Transaction support or is that support aimed exclusively at sql-based flows TIA, barkingdog barkingdog wrote: >> Have you tried the RetainSameConnnection approach No, not yet. But if I recall right, after setting up a simple SSIS transaction (in a single container) and trying to run it, I got an error message indicating that MSDTC was not started on my box. So I started it. In other words, I think ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA and multiple windows (swapchains) clarification.

  Hello all, I would like some clarification on the point of using multiple windows under XNA. I am looking at a major rewrite of software and am currently exploring alternatives. I have a Visual Basic 6.0 application that uses DirectX 8.1. The application has a main control form (standard VB controls). It also contains three other forms which render 3D displays. Each of these 3 windows uses standard VB controls for toolbars and statusbars; but render 3D scenes in a Picture box. Using this method I can render an aircraft in flight (chase view), a birds eye view of flight path, and weapon in flight view concurrently. I also have two forms rendering with the Win32 API, and another form for displaying database data in a grid control. T ...Show All

• .NET Development LongTime formatting problem?

  With the code, DateTime dt = new DateTime (2006, 11, 14, 1, 23, 45); Console .WriteLine(System.Globalization. DateTimeFormatInfo .CurrentInfo.LongTimePattern); Console .WriteLine(dt.ToLongTimeString()); Console .WriteLine(dt.ToString( "T" )); I get the result of HHmm:ss 012345 012345 Shouldn't I be getting 0123:45 instead of 012345 yes, i do believe you should...I'm getting the following output with the same lines of code: h:mm:ss tt 1:23:45 AM 1:23:45 AM ...Show All

• SQL Server Setting the Locale of Reports

  I am having a problem with date formats in reports. I have a two servers, one setup as En-US and the other En-UK in Windows. I have various reports that are rendered using the report viewer control in local mode. In my reports I have not set a language on any text boxes or on the report itself (using Default option in VS 2005). As I understand reporting services should therefore use the locale set in the browser, or else the locale of the report server. However, when viewing the reports, both servers display date time values in American mm/dd/yyyy format! I do not understand this as I am using the local machine to view the reports and the so the locale of the browser and the locale of the OS are En-US and En-UK respectively. Please could ...Show All

• Visual Studio Express Editions Default Value Not Working for SQL DataBase Table

  Visual Basic 2005 Express: In my SQL database table, I specified a default value of " " (space) for MiddleName. But, if I do not enter anything in this field, I get a "MiddleName does not allow nulls" exception and I lose all of the data that I just entered for that record. The primary key of this table is LastName, FirstName, MiddleName, CustNbr, so I cannot change it to AllowDbNulls. ...Show All