Answer Questions

• Jason Croft Review my code for improvements

  Hello, my code below imports a fixed width text file that is about 97,000 lines. It is then displayed in Datagridview1. Is this the best way to do what I'm doing Do I need to reduce the code in my Form1 Class and create a new class to handle the Import File Also, I'm dealing with a money value in DataColumn 6 that uses alpha characters to determine negative dollar amounts in about 10-20 random lines. For example, 503M would equal a NEGATIVE ($50.34). Is there a way to change the 503M to -5034 Thanks in advance!!!!! Imports System.IO Imports System.Threading 'not sure if i need this import Public Class Form1 Dim ds As DataSet Dim bs As BindingSource Private Sub btnImport_Click( ByVal sender ...Show All

• slein what happened to my thread?

  hi guys, i posted one thread titled 'refreshing listboxes',eagerly waiting for replies and now i cant find it! is it erased or what i really need help regarding this topic Hi, ListBox1.ValueMember decide which table column of the query result is bound to items' value of ListBox, while ListBox1.DisplayMember is to items' text. When you update the database, and want to refresh the listbox, you'd binds the data again to the listbox. How to do it depends what kind of binding way you use. And for further question, I suggest you open a new thread to discuss. Thank you Tanks figo, it solves my problem Hi, Ca ...Show All

• ds. Design and Documentation

  Hi again, Currently, we first always design any db-changes in Visio EA and only after the changes are approved, they are incorporated into the schema. We document all fields and tables within Visio. Unfortunately this documentation is not being transferred to SQL in the correct way for other documentation software like innovasys document-x) to pick it up. It seems also this DB project has no support for documenting the schema, nor for creating/maintaining DB diagrams for design and overview. You gave us a bunch of tools for messing around with databases, but Visio is definitely not integrated and DB project does not seem to care much for documentation either ! What's your recommended way of designing (before schema changes) ...Show All

• code_junkie How do I convert .NET 2.0 Coding into VB 2005 Express Edition coding?

  How do I go about understanding and converting the coding of .NET 2.0 into the coding that Visual Basic 2005 Express Edition can understand You should check out - the following 2 utilities which will convert snippets of C# code to VB. http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx http://www.kamalpatel.net/ConvertCSharp2VB.aspx This way you can do you own conversions of whatever code you using. Perhaps If you show use what coding you are talkign about we may be able to assist. As renee quite rightly said the .NET framework is an underlying managed framework which many languages can use. The most popular of which are VB.NET and C#. However there are actually ma ...Show All

• KompjoeFriek SQL Query Not Re-Running And Updating It's Data

  Hello, I have a login form where you enter the username and password then the form runs a query which is as follows: User = UsernameTextBox.Text Pass = PasswordTextBox.Text Dim Booking As New System.Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Alex\My Documents\Visual Studio 2005\Projects\Ground Zero Booking System (TEST)\Ground Zero Booking System (TEST)\Booking.mdf;Integrated Security=True;User Instance=True") Dim cmd As New System.Data.SqlClient.SqlCommand Dim rowsAffected As Integer Booking.Open() cmd.CommandText = "SELECT Count(*) FROM AdminAccess WHERE [Username] = '" & User & "' AND [Password] = '" _ & Pass ...Show All

• BetsyT How to provision a new team project with versioning for all document libraries

  When I lay down a new project using the MSF for Agile 4.0 schema (only one I use by the way), the project gets setup. Each of the document libraries like Development, Requirements, etc by default are setup without versioning enabled. I want to be able to provision a new site, and have all of these libraries setup with the versioning checkbox selected to YES. Right now, you see, I must go to the Project Portal, and access each document library that the team wants to use for versioning docs, and set the flag to YES for "Document Versioning" in the 'Change General Settings' screen. In summary, is there a config change that I can apply on the backend that will make versioning "on" by default for all document libr ...Show All

• James Nesbitt C# setup

  hi, I made a program in C# and I would like to distribuate it to friends into an setup.exe file. I could find a program already who could make this setup.exe for me by clicking the right things in the wizard. But the problem is it just compiles the data and then just extracts it into it's normal form. And people who don't have C# installed can't use the program then. Can somebody help me by giving me a free program who can create my C# project into a setup.exe file but so others can use it to without having to install C#. (I only have the free version of C#, so I can't do it directly using a setup project) Many thanks! Ok this is the thing I'm looking for, but are you really sure that the ...Show All

• MuscleHead Group Tasks

  hi all, is there any other way to group tasks, i mean instead of areas, iterations and related work items looking for a solution where you can see task and by expanding them where you see the subtasks. thx riv ok, thanks for reply! i will visit your blog (https://blogs.msdn.com/narend/) and have a look. best regards riv Edit: OK Naren, i found the blog, how did you call the post I do not see any other ways of grouping, except using hyperlinks that point to work item web views, or using custom links (I'll write a blog explaining it if you want to know more) - using these approaches will work to some extent but it is too hard to query on them. We see the need to use ta ...Show All

• Sam4u2e How to capture & validate server response message?

  Hi, I have to test a .Net application that has uploading features. On uploading the incorrect spreadsheet, the server will throw this error message as response " abc@xyz.com " has duplicate entries in the Excel Sheet. Please validate and upload again. Pls let me know how it can be captured and validated. Thanks in advance - Vijay. In another post you said that the excel values were read and displayed by your aspx code, but I don't think I fully understand your situation. You are seeing the values from your excel sheet during the recording process, but you're not seeing them during playback, is this correct Have you confirmed that the excel document is really being uploaded during pl ...Show All

• TheRealMrT Project to TFS sync problem

  I have a TFS project that I have synced with MS Project. I have noticed that some of my tasks in Project seem to have their start dates "fixed" at the project start date. If I create a start-to-finish link between another task (as the predecessor) and one of these tasks the link is created but the start date remains as the project's start date, making the link loop back to the left from the predecessor's end date to the successor's start date. Can anyone tell me why this is happening and how to fix it TIA Ron L Smitha Thank you for your response. The calculation mode was the problem. I know I had fixed that previously and didn't think to check it again. Doh! Apparently something in TFS is resetting it on an ...Show All

• vbjunkie Problem with RSS reader project

  Hi, I downloaded the beginners videos from http://msdn.microsoft.com/vstudio/express/visualcsharp/learning/#beginners and all was going well, I'm on lesson 15 and have read the additional writing for this project and have done everything shown in the video and I've looked extensively at the snapshot included in the download, my code is identicle and up until now always compiled and executed, after adding the code from this lesson however my application crashes. The problem seems to be here: // Begin the WebRequest to the desired RSS Feed System.Net.WebRequest myRequest = System.Net.WebRequest.Create(rssURL); System.Net.WebResponse myResponse = myRequest.GetResponse(); // Convert the RSS Feed into an XML document ...Show All

• kevin D. white BuildType download additional (unspecified) project

  I am trying to use Team Build to automate builds on a server. My team project source control has two version of the source code (v5 and v6 - with v6 branched from v5). I created a build type for the team project and in it, I specify to only build the v6 solution. When I execute the build type, the server is downloading and building both the v5 and v6 project (v5 doesn't build because it was imported code). In the <SolutionToBuildInclude> element in the build type's proj file, I see that it correctly list only the project that i had specified so I have no idea why it's trying to download and build the v5 code. Any idea what I am doing wrong Thanks The first thing I would check is the Wo ...Show All

• Bigmo write to excel using C#

  hello, i'am doing a tutorial i found on the microsoft website where i'm simply suppose to write a couple of values into a table in excel. well my program builds fine but i have run through a couple of exceptions that i'am having a hard time fixing. here is the script: using System.Data.Common; using System.Text; using System.Reflection; namespace myApp { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { static void Main( string [] args) { object path = "C:\\Documents and Settings\\LKaba\\Desktop\\"; System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLED ...Show All

• jsdratm How to stop users from inputing Text

  Hey all, I am trying to keep users from entering more than 5 digits into a text box and I am hitting a dead end in what I should be looking for or doing. Currently, in my key_press event i have the following: Private Sub txtSequenceNumber_KeyPress( ByVal sender As Object , _ ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtSequenceNumber.KeyPress 'Validate input Select Case True Case IsNumeric(e.KeyChar) 'User has pressed a digit. Accept it Case e.KeyChar = ControlChars.Back 'User has pressed backspace. Accept it Case e.KeyChar = ControlChars.Cr 'User has pressed Enter. Transfer input to variable Sequence2 = Convert.ToInt32(txtSequenceNumber.Text) ...Show All

• Maclau Visio Problem Reversing C# project

  hi, when i click Project -> VisioUML from VS2005 visio get started and the project seems to be reversed. I can see on the screen visio parsing .CS files.. but once the process is completed i only receive a bunch of errors from the visio output and a blank paper. mostly the errors are: "UMLE00034: Generalization53[Generalization] : [Generalization - WFR1] - A generalizable element may only be a subclass of generalizable element of the same kind." this happen when a class implements an interface... obviously the code from the project is correct and works perfectly. Any idea I'm sorry you're experiencing this problem, and I'll try to help. Have you ever been able to successfully rever ...Show All