Answer Questions

• Mahmoud_Fayed Loop Sql, display data

  I had the flowwing code, trying to dsiplay all the email to this format ( "Test@testing.com, Test2@testing.com,etc ) in a textbox How do i do that Using EmailConn As New SqlConnection Using EmailCmd As New SqlCommand( "SELECT Email FROM Participants WHERE (SchoolName = @Email)" ) Dim Email As String = EventCmb.SelectedItem.ToString() EmailConn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename='C:\Documents and Settings\HP\My Documents\Visual Studio 2005\WebSites\FYP2\App_Data\Event.mdf';Integrated Security=True;Connect Timeout=30;User Instance=True" Try EmailConn.Open() Using rdr As SqlDataReader = EmailCmd.ExecuteReader() While rdr.Read() EmailCm ...Show All

• kart WebTest hangs on redirect.

  I have seen issue with my webtest being hung on redirect. Any idea why this is the case Any work around to the issue Thanks for your help in advance. Thanks, --Will I believe is "In Progress". What state is shown in the "Test Results" window when it is hung When you the the test is hung, do you mean that the web test stays in the "In Progress" state and the VSMSTEST process continues to run How long does it stay in this state Thanks, Rick It stays in "Redirect" state. I am not sure how long it stays in that state because I killed the test (I waited for approx. 5 minutes). It happens intermittently. I've set ...Show All

• Bartosz Manual installation, no Internet access, how do I register?

  I've got Visual C++ Express on my Win2K computer, which isn't connected to the Internet. I've got the .iso burned to CDROM and finally got that installed, together with everything it asked for. I'm thinking of registering it, as much for the ebooks and the royalty-free stuff as for anything else - because I didn't need to register it to install it. How do I register it, if it's not connected to the Internet Is there a site I could go to, where I'd enter details such as it being Visual C++ Express plus potted MSDN plus SQLServer, and so on and so forth Or is that unlikely FWLIW, I'm also intending to manually install the other Visual [language] Express, and I want the extras for them as well. To slightly rephrase what Brendan is ...Show All

• Mrs.shaza Question with VS 2005 and TFS

  Hello everyone, The organization I work for is beginning a redesign of our website and we're migrating from .Net 1.1 to 2.0. We currently use Visual Source Safe 6.0 for our source control and we barely use any of the functionality outside of checking files in and out (though I'm pushing to change that hopefully). So I've been researching other source control systems and, of course, ran across Team Foundation Server. I've spent most of the day researching the different "role" version of VS 2005 and found that our small development team wouldn't really need that (we have 3, sometimes 4 developers who write the code and then 2 or 3 people who do the HTML mark-up. Using something from the Team Suite might just be overkill). So my q ...Show All

• MajorDad how do we get number of days/hours comparing two diff date/time?

  how do we get number of days/hours comparing two diff date/time ... for example 12/05/06 to 02/01/07(number of days)......10:30 am to 20:05pm Hi, You could use VB's DateDiff function, like: Dim date1 As New DateTime(2005, 10, 14) Dim date2 As New DateTime(2007, 1, 19) Dim days = DateDiff(DateInterval.Day, date1, date2) Dim hours = DateDiff(DateInterval.Hour, date1, date2) Andrej The following code reads date1 and date2 from MaskedBox1/2, while time1 and time2 are read from MaskedBox1t/2t: After times are added to the dates, the calculation is performed as in the previous code sample: Dim date1 As DateTime = DateTime.Parse(MaskedTextBox1.Text) Dim date2 As DateTime = DateTime. ...Show All

• bluesky168 Screen Shot

  Hi, I am a novice programmer. I was wandering how do i take a screen shot of my screen every 30 seconds and save this shot as a JPG file with the name mmddyy-hhmmss ( months days years - hours minutes seconds ) In the C:\My Documents\myPics directory. EX. C:\My Documents\myPics\022607-231453.JPG Thanks. Do you know how to make it into vb.net windows form code Some how I can't get it to work. Can you send me the project at jcnconnect@gmail.com Thanks. I think it would be far better to start from scratch and borrow any usable code. Screen copy is quite easy although I would caution you on several things. Collecting, storin ...Show All

• tkrasinger looking for help

  I want to create a basic payment tracker. I would like to track two items. First I want to track payments and second I want to track balances. I have a sqldatabase that I have created to input the client info. now I just want to be able to track all of that clients payments and balances. I would also like to be able to see a average of the total payments and total balances. Can someone tell me the easiest way to create this Thanks I am still very new to VB but I am learning. You can make an EXE, and even embed an Excel spreadsheet in the EXE, but probably not the way you want: to modify the Excel spreadsheet you will need Excel (the application) to be installed, and use automation. ok so I see that I can not sen ...Show All

• FocusedWolf Does anyone know when/if the Upnp APIs will become available as part of .NET?

  Are they part of .NET 3 What would be the best approach to programming for UPnP with software available today In C# In C++ Thanks ...Show All

• Jerry Hung Convert Byte Array to Int, Long, etc.

  Does anyone have a quick way of converting a byte array to an integer, long, etc. I have been trying different encoding types and also a Marshal.Copy but I keep getting unexpected results. I have a byte array (00 00 48 65). I know that that byte array value (as an integer) equals 11. I just can't seem to write the code to do the conversion. Any suggestions Thanks for the reply. I did try BitConverter as well but the results still weren't what I was looking for. Let me explain the problem in more detail: I'm creating a rectangle (11, 11, 3, 4). A region is made from that rectangle. I then look at the GetRegionData.Data for that region--it's a byte array. I strip off the header info and lo ...Show All

• Venkata Bayanaboyna How To implement ListView with controls like "eMule Transfers list"

  I'm looking for a ListView that include for each row an image box,checkbox,progressbar,label or textbox,combo box..ect.. Where can I find it Thanks thanks.....have u a sample code or sample project I even created a usercontrol !!! please heeeelp meeee !!!!! :) What do you need help with Start by making a UserControl that looks like one item in the "ListView". Then simulate the ListView with a Panel whose AutoScroll property is set to true. You'll need to dynamically create each "ListView" item by creating your UserControl instance and adding it to the Panel's Controls collection. Yell if you need code. Can you give me a sa ...Show All

• Voodoo45 Debug file not there?

  Hello, im a bit of a noob at Visual Basic and need some help. I recently downloaded Visual Basic again. (Yes, I have used Visual Basic before) and when I go to the directory where I saved my project, there isnt a debug file in the 'bin' folder. In the 'bin' folder there is only "windowsapplication1.vshost" in there. How do I fix this I would appreciate a speedy reply since I want to get started on VB as quick as possible Thankyou, Sam Wharfe ..How stupid of me.... How could I not know that... I realy appreciate your help. Thankyou very much DMan, Sam Wharfe You have to build the project at least one time in debug mode for the files and file structure to be co ...Show All

• tdcntt Setting Area Path When Adding A Work Item Using The API

  I receive the error "TF26202: Validation failed. Field 'Area Path' not supported." when I try to call Save on a WorkItem object that I've specified the AreaPath property on. Is it not possible to specify the AreaPath when saving a work item Can I specify the AreaId If so, how can I get the AreaId from an AreaPath There does not appear to be an Id property on the NodeInfo class. Should the Area Path be the full Area Path (i.e. \<TeamProjectName>\Area\<AreaPath>) or just the <AreaPath> It needs to start with project name, and then area path. No initial slashes. You can try copy/pasting from UI. I checked the source code and found that ...Show All

• Alexander Ekzarov Cannot imports Excel

  When i paste this " Imports Excel = Microsoft.Office.Interop.Excel" to the class, that underline, how can i do it Project + Add Reference, COM tab, select "Microsoft Excel 11.0 Object Library". You do need to have the Office 2003 Primary Interop Assemblies installed on your PC to make this work. I didn't know you could use an alias in the Imports statement. Thanks for that! I had follow the step >> add references and use office 2003 PIA Imports Microsoft.Office.Interop.Excel 'this code is ok Dim oExcel As Object Dim oBook As Object Dim oSheet As Object 'Start a new workbook in Excel. oExcel = CreateObject("Excel.Application") oBo ...Show All

• MarkW1 Should setting "Deny" permission override Admin priveliges?

  I am trying to limit checkin permissions on a certain branch in our source to only the Admin group. I thought the most expedient way to do that would be set the Checkin/Checkout priveliges to "Deny" for the Readers and Contributors group. However, when I do that, the admin group members are being denied access as well. In fact, if I set "Deny" on any permission for a group that an admin belongs to, that Deny permission seems to override the priveliges of the Admin group. According to the documentation here: http://msdn2.microsoft.com/en-us/library/ms252587(VS.80).aspx , I would expect admin group members' priveliges to be unaffected by setting "Deny" for a group to which the admin belongs. Am I misreading the ...Show All

• Chad D. Morgan Update Combobox DisplayMember based on DataGridView CellContentClick

  OK, now that I have the database binding I need to accomplish the following: The Form.DataGridView shows the table info. When the user clicks a row, the CellContentClick event kicksoff creating a query that combines the "Last_Name, FirstName" into a new column called FullName. This then updates the DisplayMember value for the combobox to FullName. If someone could show me an example, I would appreciate it. Thanks! ahmedilyas wrote: however its best not to do this at the SQL end (to be more efficient) and do this at your presentation layer (client side) What do you mean by this That I should have it as the SQL statement in the DataSet or do it upon the CellCont ...Show All