waroop's Q&A profile

• SQL Server Exporting data as XML file

  To get the data from the database table as an XML file we will use " for xml" clause in sql statement in SQLSERVER.   But i am not able to generate the following things in that XML file. please let me know how to get the following details in XML file using sql statement < xml version="1.0" encoding="UTF-8" > - < listOfIDXRefData xmlns =some url here>     Try the T-SQL forum http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=85&SiteID=1   -Jamie   ...Show All

• Visual Studio How to call close method on a VSSDatabase object ?

  Hi guys I tried to google and search within the forums for some post on close() however i could not find any post or gd explanation. I tried to do a .close() on the VSSDatabase object, however the method is not there, but on the Reference section in msdn2, such a method is documented however it is warned not to call directly from my code. Could anyone shed some light on this problem/ issue I think its abit sucidal not to be able to close the DB once i have opened it. Reference in your project the Microsoft.VisualStudio.SourceSafe.Interop from .NET tab of the AddReference dialog. Then, in your project use " using Micr ...Show All

• Visual Studio web project template, to fire code in gac class.

  Basically, I create a web project template, and another assembly ( in the gac which has a method ). I want when the project tempalte is used to create a new website, for it to call and execute said method. How would I implement what I am trying to do I found some resources online, and I defined the following in my template.. however, i dont know how to get it to fire a method in that class name, meaning, i am having trouble getting to this ProjectFinishedGenerating < WizardExtension > < Assembly > GBMProjectsTemplate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=80d799f04f11805c, Cus ...Show All

• Smart Device Development How to run msvsmon.exe on remote machine..Ver Urgent

  Hello: I am trying to connect to the remote server, which is a mobile device. Whenever I am trying to execute the program, an exception is thrown on my desktop application. Error: Unable to automatically step into the server. Connecting the server machine "xx.x.xx.xx" failed. The Microsoft Visual Studio Remote Debugging Monitor(MSVSMON.EXE) does not apper to be running on the remote computer. Please see Help for assistance. If this is the cause for the error, can anyone tell me how to add this exe in my mobile device. I am using Compact Framework 2.0. Thanks Vinay I am unable to run my server, which is a mobile ...Show All

• Visual Basic insert new rows/records

  Hi all, I have a problem inserting rows/records into my db. In my access db I have 1 table called "Channels" , this table consist of 3 columns (Id, Channelname, ChannelURL) primary key has been set on Id. Table has to be filled up with data captured from textboxes on the form (table is yet empty) When I hit Button1, no new records are added ! Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load DataSet1.Clear() OleDbDataAdapter1.Fill(DataSet1, "Channels" ) End Sub Private Sub Button1_Click( ByVal sender As System.Object, By ...Show All

• Smart Device Development Smart Building

  I have this problem to solve, hope that you can help me: I have a building with a “control system”. The control system, depending of the temperature inside and outside the building, opens and closes windows automatically. I want to create a 3D model of the building that displays in real time the processing mode of the building (temperature inside and outside, windows that are open and closed, etc). For that I have to interconnect the “control system” of the building with a computer. The control system gives data temperature inside and outside, windows that are open and closed, etc) in format txt. I want also to be able to use ...Show All

• Visual Basic code for opening and attaching an image file

  im only new in VB. I need a code how to open an image such as .jpg, .gif, .bmp. etc. ,and attach or diplay the selected image to the PictureBox. thanks! Very simple - use the load method on the picturebox and supply it with the filename you wish to display. PictureBox1.Load( "d:\blue.bmp" ) ...Show All

• SQL Server Are report parameters cached in the report server?

  Dear Anyone, I would like to ask if the report parameters in RS2005 are cached in the server. Im worried about this because each of our reports has an average of 6 report parameters. Each of which uses 2 data sets. 1 for retrieving the list of values and the other for retrieving the default values. Each report parameters are multi-select and almost all of them will contain not less than 500 selections. We have a very significant number of users and my worry is that this might bog down on our database server which is located on a seperate box. Any opinions or clarifications anyone Thanks, Joseph One problem that we're l ...Show All

• Visual Studio 2008 (Pre-release) IIS hosting on XP: "Collection already contains an address with scheme http"

  Hi, I'm trying to run some of the samples from the 15th April documentation CTP, but they keep failing in IIS with the error "Collection already contains an address with scheme http". I saw another post on the forum but it seems to describe an issue with host headers, which I think doesn't apply to my problem since I'm running XP. The exact same code hosts OK with the development server (c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\WebDev.WebServer.EXE), so this has to be an IIS problem, right Any ideas about how I could troubleshoot this Oh, I was going to try to run servicemodelreg.exe as described in the help to try to fix thi ...Show All

• SQL Server There was an error in the incoming SOAP request packet: Client, LoginFailure, AccessDenied

  Hello, I havent been able to consume an endpoint from my application. I have windows xp and I am logged in on my machine as LUCHO\Administrador. the code that I used to crate the endpoint was create endpoint MyEndPoint AUTHORIZATION [LUCHO\Administrador] state = STARTED AS HTTP ( path = '/sql/hello_world' , AUTHENTICATION =( INTEGRATED ), PORTS = ( CLEAR ), CLEAR_PORT = 90 , SITE = 'LOCALHOST' ) FOR SOAP ( WEBMETHOD 'GetSqlInfo' ( name = 'master.dbo.xp_msver' , SCHEMA = STANDARD ), WEBMETHOD 'DayAsNumber' ( name = 'master.sys.fn_MSdayasnumber' ), W ...Show All

• .NET Development Trace.Writeline skipped

  Hi I'm creating a web-service and am trying to trace to a listener using Trace.Writeline. However, the trace is not being written to and using the debugger, I see its because the Trace.Writeline() line is being skipped. However, if I change it to Debug.Writeline, it gets written. Can anyone help as to why Trace.Writeline is being 'compiled out' Thanks I'm not an expert on ASP.NET applications, so you are best to post this on the http://forums.asp.net forums. These forums are for non-web development posts only. ...Show All

• Visual C++ Open File Dialog

  Hi I`m trying to play a mp3 file with c++ a console application.. so i need the exact path to it.. i figured out how to show the open file dialog .. but i still have some problems CODE: OPENFILENAME ofn; char szFileName[MAX_PATH]=""; ZeroMemory(&ofn, sizeof(ofn)); ofn.lStructSize = sizeof(ofn); // SEE NOTE BELOW ofn.hwndOwner = GetActiveWindow(); ofn.nFileOffset=1; ofn.Flags=OFN_PATHMUSTEXIST | OFN_OVERWRITEPROMPT; ofn.lpstrFilter = L"Text Files (*.mp3)\0*.mp3\0All Files (*.*)\0*.*\0"; ofn.lpstrFile = (LPWSTR)szFileName; ofn.nMaxFile = MAX_PATH; ofn.Flags = OFN_EXPLORER | OFN_FILEMUSTEXIST | OFN ...Show All

• Windows Forms How Do I: Bind a TextBox to a specific column in a DataRow from a DataTable?

  I have a datatable, and depending on all kinds of factors i want to iterate each row using a For..Each loop.  When the correct row is found I want to bind a column from that row to the Text property of a textbox. The problem is that I can quite figure out what my binding should like: Pseudo-ish code: For Each row as New DataRow in DataTable1.Rows     If row.Item("id").ToString = "1" Then        Dim b as New Binding("Text", row, "id", True )       Text1.DataBindings.Add(b)        Exit For     End If Next ...Show All

• SQL Server running DBCC Shrinkfile code, from where?

  SQL2000 Server, SP4, a database with a 17Gb log file. It has been backed up so all transactions should be validated, now the real file size needs to be shrunk because I need the diskspace plus I want to speed up the backup process. http://support.microsoft.com/kb/272318/ Tells me what to do but not where to do it. So I need to run this code : DBCC SHRINKFILE(pubs_log, 2) but from what console do I run it Thanks, but that is not what I mean, is this a SP, or a SQL statement or what kind of code is it ...Show All

• Visual Basic Message Box in VB.NET

  Hello All, How to create a messagbox in VB.NET Windows Application with Yes | YesToAll | No | Cancel options I wanted to ask the user's permission to overwrite his details. Then a message Box should pop up with these options Is this possible as it is supported by Mocrosft os. How can this be possinly done in VB.NET Please Help Lisha Hi Lisha, I'm sorry i don't have it installed.  I wrote it in VS 2005 now from a old vb5 code. Maybe someone will be able to convert it to vs2003 version, i image there wouldn't be much diffculty. If not, you can always open the .vb files of the frm_dialog and copy ...Show All