slentz's Q&A profile

• Visual Studio Express Editions Removing characters from a string

  I am importing a string into a database. I have noticed that from the text file I can see a Square Character. How do I remove these characters from the string Here is some Very early code that I am working on, Dim linenumber Dim theReader As IO.StreamReader = IO.File.OpenText( "test.txt" ) ListBox1.Items.Clear() Do While theReader.Peek <> -1 linenumber = theReader.ReadLine If linenumber.Contains( "MeridianMail" ) Or linenumber.Contains( "No Activity" ) Or linenumber.Contains( "Services Detail" ) Or linenumber.Contains( "Interval Start-End" ) Or linenumber.Contains( "Service" ) Or linenumber.Contains( "Accesses" ) Or String ...Show All

• .NET Development Returning Exceptions with ExecuteScaler and ExecuteNonQuery from RAISERROR in a SQL Proc

  I am experiencing that I am not able to return an exception from a stored procedures that I call using ExecuteScaler if my select statement is before the RAISERROR statement. I do understand that if I use ExecuteReader I have to perform a reader.NextResultSet to get an exception to fire. This is working fine. Is there any way at all to return an exception with ExecuteScaler(after the select) or is this not possible. I'm looking for the answer so I can avoid using this method entirely and move to using a reader. Is using a reader and calling NextResultSet the next best option if I want to ensure all exceptions get returned and have good performance even if it is only returning one value I'm assuming this will perform bett ...Show All

• Windows Live Developer Forums Zipcode/Ip address to Geocode conversion API

  Hi, Is there a way to get the geo code frrom the IP address or the Zipcode I have looked at options from sites like http://www.localsearchmaps.com/geo/ by_ip=1&ve=1 We would prefer using the VE api. Is there a way we can do it with VE API. Any help or pointers is appreciated. Thanks, Srikanth. "Yes" by ZIP code, "no" by IP address. For geocoding ZIP, just pass the ZIP code to the FindLocation() or Find() method. ...Show All

• Visual Studio Express Editions Irregular shape forms

  it is possible to design an irregular shape form in vb net 2005 Yes. Shaped Forms ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Microsoft.Xna.Framework.Audio.NoRendererException while compiling Spacewar

  Microsoft.Xna.Framework.Audio.NoRendererException was unhandled Message="External component has thrown an exception." Source="Microsoft.Xna.Framework" ErrorCode=-2147467259 StackTrace: at Microsoft.Xna.Framework.Audio.AudioEngine..ctor(Stream settingsData) at Spacewar.Sound.Initialize() in D:\Trent\Visual Studio 2005\Projects\MySpacewar1\MySpacewar1\Sound.cs:line 203 at Spacewar.SpacewarGame.WindowsGame_Starting(Object sender, GameEventArgs e) in D:\Trent\Visual Studio 2005\Projects\MySpacewar1\MySpacewar1\SpacewarGame.cs:line 94 at Microsoft.Xna.Framework.Game.OnStarting() at Microsoft.Xna.Framework.Game.Start() at Microsoft.Xna.Framework.Game.Run() at Spacewar.Program.Main(String[] args) in D ...Show All

• Windows Live Developer Forums What's problem about errorcode "80048869"?

  MSN Messenger in my computer can't login MSN server. But myself component demo can login OK. Would you like to tell me what's meant about "80048869" ...Show All

• Visual Studio Team System internet explorer script error, 8007f305 when printing a report

  I am getting an error when trying to print a report out of team explorer on my local machine. Can you tell me what is going on and how to fix it Thank you, Kevin Error: Internet explorer script error Line: 26 Char: 4 Error: Could not complete the operation due to error 8007f305. Code: 0 URL: http://loki/ReportServer/Reserved.ReportViewerWebControl.axd ExecutionID=Isqowo55a00qew553rrejomI&ControlID=393108d Do you want to continue running scripts on this page Steps: Open a report and press the "Print" button I'm sorry to hear you are having an issue printing reports. It appears to be a known issue with using the hosted IE control as opposed to the stand ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Product.cab not found?!?

  I tried to install Beta 2 after uninstalling Beta one and I got a lovely message when the installer was trying to copy over new files "Product.cab could not be found"... With the option to Abort, Retry or Ignore... Of course ignore rolled it back... What can be done to fix this I'll try to download the .msi again, but it's going to take me a while... i have same problem with XGSESetup-Beta1.msi , Download Size: 91 MB published on 30th-8-06 but there has been an update at XNA GSE download page and now setup file details are Download Size: 79 MB and published 1st-11-06, right now i am downloading it, hopefully this problem will be resolved. ...Show All

• SQL Server OPENROWSET bulk insert not working properly for my Text fields

  I am running a bulk insert on a csv file I have created however the problem I am having is that because some of the text strings I am inserting have commas in them bulk insert does not work. We used to use the text driver which split up the csv correctly but had problems as lines were chopped off at 255 characters as it tries to be smart and is failing. Bulk insert allows for a xml format file which is meant to solve this and seems to be doing that, but as I say it is not working correctly with the csv - if there is a way of giving the text driver a format file I have yet to find it. ideas I have the SQL I am running below if that helps. SQL with BULK - SET IDENTITY_INSERT branch ON; INSERT INTO branch([handle],[name],[company],[securit ...Show All

• SQL Server Problems with OraOLEDB.Oracle

  Good day everyone.... I have installed the OraOLEDB.Oracle Provider on 3 different servers, and have made a link server on all three. On two of the machines, I am successful in retrieving data from the Oracle database. But, on the third machine, I receive this error: Server: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "employee_prod" reported an error. The provider did not give any information about the error. Server: Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "tims2_prod". On the machine which is generating the error, I can use SQL*Plus to connect to th ...Show All

• Visual Basic open a form with only systray icon

  Hello, how do i open a form so the form does not show and only an icon appears in systray I know how to make the icon but everytime I do this the form appears. I want to make the form only appear when I right click on the icon and say "appear". Thanks! i donot know this is the right techique or not. you can set the form's opaque perporty to 0 and showintaskbar perporty to false at design time. and when user click on this system try then you set the opacity to 100 and showintaskbar to true. this way way you can achive this. ...Show All

• Smart Device Development UriFormatException

  I want my WebBrowser control to navigate to an existing file like this: ctrlBrowser.Navigate(New Uri("file://\My Documents\My Directory\My Book\home.txt")) Running or debugging on a Windows Mobile 5.0 device results in an UriFormatException, while debugging on the emulator raises no exceptions. Maybe different CF versions ... What puzzles me even more, is, the above mentioned code worked fine on my device, before I did a ROM upgrade and reinstallation of .NET CF 2.0. Same result with ctrlBrowser.Navigate(New Uri("file:///My Documents/My Directory/My Book\home.txt")) I would highly appreciate your help. Wolfgang Seemed to be a problem with some third party software installed on t ...Show All

• Connected Services Framework Should Active Directory be a Domain Controller or in a different domain ?

  MCSF uses Active Directory to store user details. 1. But does it need to be in a different domain or a domain controller 2. Can I just install AD and point MCSF to store users there Regards, Sachin Hi Sachin and Tilak, Thanks for your notes - please also note that the CSF Identity Manager component can not be installed on the same server as Active Directory, because the Identity Manager component uses impersonation, and Active Directory does not permit processes to use impersonation on the same server. Many Thanks, Sachin and Tilak!! -Rob. ...Show All

• Windows Forms DataGridView - LastDisplayScrollingRowIndex ?

  Hi To get the first displayed row index you use dgv.FirstDisplayedScrollingRowIndex. But how about when you want to get the last displayed one I want to have a certain row displayed, if it is NOT already displayed: if (rowIndex < dgv.FirstDisplayedScrollingRowIndex || rowIndex > dgv.LastDisplayedScrollingRowIndex) dgv.FirstDisplayedScrollingRowIndex = rowIndex; Kind Regards Maybe this will help using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace VisibleRowsCS { public partial class Form1 : Form { public Form1() { InitializeComponent(); } ...Show All

• SQL Server Help backing up and restoring database

  Hi, I have been using the backup feature of SQL Express for some time and I thought it would be good to test a restore in case the worst happend. I moved my bak files to a usb memory stick and copied them to a machine and installed SQL Express so its empty no database's etc. So I right click the databae folder and choose restore from device and point to the db's but I get errors restoring them. What am I doing wrong Is their any guides that give steps to backup and restore database's Any help would be great - I can of course provide more information need be. Thanks, Adam. hi Adam, 2326ac wrote: Hi, I have been using the backup feature of SQL Express for some time and I thoug ...Show All