Learning VB's Q&A profile

• Visual Studio Team System CTP4 Problem

  I just installed CTP 4 and attempted to create a new Database Project as follows: I select File | New | Project I expand 'Database Projects' and select Microsoft SQL Server I select the SQL Server 2000 template I enter the name and location etc. I click the OK button and after a few minutes I get an error stating, "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified). I have both SQL 2000 and 2005 installed on my laptop. I don't know what server/instance its at ...Show All

• SQL Server Dynamically create text file as destination

  I am trying to create a text file from an SQL query on a SQL table. I would like the SSIS package to prompt for the file name and path. The text file is tab delimited and the text qualifier is a double quote. Thanks, Fred Use expressions to assign the filename to the Flat File Destination (property Connection = User::variable) Add a Script task before your data flow task. This script task will prompt for the file location and set the User::variable. ...Show All

• Visual Studio Team System WorkItemFormControl hanging on .Item assignment

  Hello All, I am seeing the WorkItemFormControl form hanging while I initialize it with the following code: m_wifc = new WorkItemFormControl (); m_wifc.Item = paramWI; m_wifc.Dock = DockStyle .Fill; m_wifc.Name = "WIFC" ; When the .Item property is assigned, the control seems to hang and never return. Here is the callstack from the debugger: [Managed to Native Transition] Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.dll!<Module>.CLocker.Enter() + 0x19 bytes Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.dll!Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.FieldClass.IsReadOnly.get() + 0x69 bytes Microsoft.TeamFoundation.WorkItemTracking.Client.dll!Microsoft.Tea ...Show All

• Software Development for Windows Vista Explorer Crashes When I Try To Add a Network Printer

  Hi All, I just installed Vista Ultimate on a Dell Precision 670 and the Explorer bombs when I try to "Add a Network Printer" from the Control Panel-Printers menu. When I select "Add a Printer" then Add a network, wireless or Bluetooth printer" I get a "Windows Explorer has stopped working" followed by Windows Explorer is restarting. At this point, I only have Vista installed. Any Ideas Regards, Scott Unfortunately, I have no ideas for you, as I am experiencing something similar. I was able to successfully add printers a few weeks ago, but one of the printers I connected to had an IP change, and now Explorer crashes each and every time I try to print, look and printer properties, etc. ...Show All

• Smart Device Development BUG: xsd.exe and xsd:choice elements imported from other schemas

  Hi, One bug with the XSD.EXE tool. When there is a choice type in a schema whose choices are from imported schemas , there should be XmlChoiceIdentifierAttribute added to the choice item, but not. Then when constructing an XmlSerializer, it throws an exception about the absence of this attribute. Here are the example schemas and the generated code. XSD.exe is not supported for devices; you can only use VS to generate code from schema. ...Show All

• Visual C# write into XML using C#

  I may have 20attributes in my destination xml file.But the data in my segment may be <=20.Then how can i insert the datas into the corresponding tags of an already created xmlfile The empty space within the delimiters are considered as null data Now i want to write these datas into already created XML file within its appropriate tags. I have a text file that has delimiters. (i.e. MSH|^~\$|ADMIT|CLAY COUNTY MEMORIAL|||200502110938||ADT^A01|00860|P|2.2|||||| ) Using C# i need to Read this file, data by data and write these datas into the appropriate XML tags of a XML file i.e. my datas for a segment"MSH" (i.e root element) would be as below MSH--->root element ^~\$ ADMIT CLAY COUNTY MEMORIAL 200502110938 ADT^A01 00860 P 2.2 ...Show All

• SQL Server Easy Question Hopefully

  This happens in both SQL Server 2000 and SQL Server 2005 Database name: STAPLE Owner: Scott Table: ScottTab I could login as Scott and state: Select count(1) from ScottTab; and results would be returned because the table ScottTab was associated to Scott and I did not have to prefix the table It was backed up and restored to another SQL Server. I tried the same query and am receiving the error table does not exist. I have tried to run: exec sp_changedbowner 'SCOTT' and exec sp_change_users_login 'Change_One','SCOTT','SCOTT' as well and get errors Please let me know the proper steps I need to take to re-associate the new sql server engine to the restored database. The user SCOTT was setup the same way on both machines ...Show All

• Visual Studio 2008 (Pre-release) What's the recommended way to save an bitmapImage to a file

  I tried saving the bitmapImage.SourceStream but it's already closed. Any idea Should I keep a copy of the stream somewhere else Hello Paul, Maybe you could try saving a file this way: FileStream fs = new FileStream(@"c:\tmp\TestImage.bmp", FileMode.Create); try { BitmapEncoder encoder = new BmpBitmapEncoder(); encoder.Frames.Add(BitmapFrame.Create(bitmapImage)); // type of BitmapImage encoder.Save(fs); } finally { fs.Close(); } Hope this helps Edmundas ...Show All

• .NET Development Access and Sql Connectivity for Software

  Hi, I have vreated a SQL- based project but now for few of my clients , i need that my project should work on Microsoft Access database , For this purpose :- Do I need to change all the queries of my project to work comatible to Access or Is there any other option for this How to create a database in Access , Is it similar as we do normally in SQL( like copying the .mdf and .ldf files onto Data directory), Is there any other option to create a database in Access by just copying some contents. Problem:- I want when somebody installs my software , it should ask for database like (Access or SQL) and creates a basic database with tables and data required for software in the selected server, Please let me know. Rega ...Show All

• Smart Device Development How to develope FTP capabilities LIST/GET/PUT on VB.NET CF

  I need to implement a LIST/GET/PUT FTP functions on a vb.NET application. I've read that System.Net for Compact Framework doesnt have this funtions, and I have to use a namespace called OpenNetCF.Net.Ftp. The problem is that i can get information of ftp server: Function TestFTP1(ByVal dir As String, ByVal user As String, ByVal pass As String) As String Try Dim creator = New FtpRequestCreator() WebRequest.RegisterPrefix("ftp:", creator) Dim ftpUri As Uri ftpUri = New Uri(dir) Dim ftpWR As New FtpWebRequest(ftpUri) ftpWR.Credentials = New NetworkCredential(user, pass) Dim ftpStream As Stream = ftpWR.GetRequestStream() Dim reader As New IO.StreamReader(ftpStream) Dim sRet As String = reader.ReadToEnd() ...Show All

• Windows Forms GridView and Selecting Value

  Hi, I am displaying values through two gridviews in my windows forms. Both gridviews display values properly. I see one gridview's first row is selected by defaut but the other one is not. Also how do get the value of that first row after it loaded I am able to get t he value after a mouseup event or cellclicked event, would I be able to get the value of the first row after gridview is loaded I do hope I didnt' confuse you. One more question how do i customize the gridview When gridview is loaded I see an extra column on the left and a row at the bottom with the * Can i get rid of them or can customize the datagrid Thank you. Hi, Hope these are what you want 1. To get the value of certain row, you may use the datagridview. ...Show All

• SQL Server inner join one varchar(50)

  Hello, I am doing inner join one varchar(50) fields, although I am sure the same data is available on both T1 and T2 but I am not getting anything with this inner join. SELECT * FROM T1 INNER JOIN T2 ON T1.FirstLastName = T2.FirstLastName What might the problem be In SQL 2000, leading space will make the comparison be False. For example, ' name' <> 'name'. Anyway, JIM.H., should post more details on your case. ...Show All

• Smart Device Development How to Maximize window when running external program?

  Hi, In my program, I have a menu option to open the Pocket PC Calculator program ("\Windows\calc.exe") which works fine, but I woud like to open it maximized so the user does not have access to the start button. Here is my current code: '** Code Start ** (Visual Studio 2005, .Net Framework 2.0, Visual Basic Code) imports system.diagnostics imports system.io ... Dim runCalc As New ProcessStartInfo() runCalc.filename = "\Windows\calc.exe" Process.Start(runCalc) '** Code End ** One potential problem with running calc.exe maximized, though, is that the user will not be able to close the program as the "X" button will not be there. Any ideas on how to do this short of writing my own ca ...Show All

• Smart Device Development IE error opening new smart device C++ project in .net 2005

  Whenever I try and open a new C++ smart device project I get the following error: Internet Explorer Script Error An error has occurred in the script on this page. Line: 4034 Char: 3 Error: Object Required Code: 0 URL: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/VC/VCWizards/SmartDeviceAppWiz/MFC/Application/html/1033/default.htm I have IE 7 installed. This happens for any of the VS installed templates. So I can't start a C++ project. Any ideas Thanks, BT This is a known issue with IE7 or Vista earlier builds, and has been fixed in VS 2005 SP1, meanwhile you can have a look at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=893504&SiteID=1 for a wor ...Show All

• Windows Live Developer Forums Pushpin Layer not updated

  i'm trying to implement geotagging on my website that allow my blog reader to add themself to the map using pushpin. under my map i've several field for the users to key in their details then upon clicking the "add" button... their details will be appended to a georss xml file... and this step works fine as the details can be appended without problem... but when the page refreshes after my user hav clicked the "add" button... the details added are not shown... and even click "refresh" on IE wont help... all i got to do to get the newly added details shown is to close the current IE and re-request the page in a new IE... then all the pushpins(including the last pushpin added) can be shown... y is this problem occuring am i doing a ...Show All