rocr's Q&A profile

• SQL Server Export Schema and Data

  This is a totally newbie question, but... I've create a database, I'm able to script the schema to a query window, file, etc. I can't for the life of me find out how to export my data so that it is scripted into insert statements. The data is standardized lists of data I will be distributing with the DB. For those of you familiar with mySQL, this would be the output of the mysqldump command which dumps schema and data all into one file mysqldumb <db> -u user -p > mydatafile.txt thanks, -David You won't be able to export it to INSERT statements, but it can be exported to a flatfile ...Show All

• Smart Device Development DataSet error

  hi all i have a problem in an application that accesses ms SQL Server via a web service using this code Dim handler As New WHService.Service1 Dim query As String Dim result As Integer Dim temp As New DataSet query = "Select .........................." result = handler.queryDB(query) ' Amethod from the web service tested & functioning For Each tempRow In result.Tables(0).Rows ' here is where exception happens 'do something Next the exception is null pointer exception when using table name and it becomes index out of range when using index to get table ...Show All

• Windows Forms How to display "Please wait, while your request being processed" message

  Hi All,   I need to display a message "Please wait..." while the user's request is being processed.I am making winforms application and on "Submit" button, the request takes long time to pull data from database and then display it to user. During this wait, Can i display some message. Is there some standard way to do it. thanks Hi Paul,   Thanks for your valuable response. I was able to make splash form work. Thanks... ...Show All

• Visual Studio Tools for Office Working with Microsoft Excel

  I want to know how can i work with Excel sheets.\ I want to insert data to the sheet and to merge cols This really isn't the best group to ask such questions, since it specifically pertains to Excel.  Ade provides some helpful links to get you to the right place: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=288110&SiteID=1 Also, some advice.  It appears you're putting in relatively little effort in asking a question that will require a complex and time consuming answer.  I would invert the effort: read basic information about Excel Automation, run tutorials, and get star ...Show All

• SQL Server Extracting the parameter values

  I have a report application where I am using Microsoft AxBrowser and url acess to view the reports. I have a report with multivalued parameter. I need to extract the user selected parameter value for that rpeort for some other purpose. How to extract the parameter value Please help Do you have access to the cookies collection of the AxBrowser control If so, then you can try to get the RS session ID and call the SOAP API GetExecutionInfo() on that session. It will return the effective parameters for the current session. Assuming you haven't changed them then it should be the parameters that were used to ...Show All

• SQL Server How to change chart color.

  Hi, Anyone can help me on how to set the chart color let say i got a pie chart. and i want the color is fix with the data i have. can it be done regard terence chua i found the solution for this question. <Style> <BackgroundGradientEndColor>=Switch( Fields!bKeyId.Value = 5, "Red", Fields!bKeyId.Value = 4, "Blue", Fields!bKeyId.Value = 3, "Yellow", Fields!bKeyId.Value = 2, "Cyan", Fields!bKeyId.Value = 1, "Green")</BackgroundGradientEndColor> <BackgroundGradientType>VerticalCenter</BackgroundGradientTyp ...Show All

• Software Development for Windows Vista Vista 5308 Media Center Extender issues

  Does anyone know if the extender function in the Media Center module of the February CTP is compatible with the Xbox Media Center Extender (MCX) I have been attempting to set this up on my test system, and will get as far as the programming the device stage of the extender setup, but at this point the setup will sit there for over an hour without completing. Is there an update that will need to be obtained to allow this to function, or is this feature only compatible with devices such as the Xbox 360 at this time Morias I have an Xbox 360 and I get the exact same thing that happens to you. It will autom ...Show All

• SQL Server Complex Query

  Hello, I am having trouble in getting the expected results. I have two tables as below. I need Idno,transdt,cd,cycdt,amt from joining two tables. The criteria is that if the transdt greater than same month of cycdt then we need get the next month cycdt and corresponding amount for that, if it is less than or equal to same months cycdt then get the same months cycdt and amt. Cd is dummy field which can be anything. I am using sqlserver 8.0 table1 idno,trandt,cd 12345,04/15/2005,cd1 12345,04/15/2005,cd2 12345,04/22/2005,cd3 12345,07/03/2005,cd4 12345,09/10/2005,cd5 3421,03/05/2005,cd6 3421,05/06/2005,cd7 3421,07/04/2005,cd8 3421,07/15/2005, ...Show All

• Visual C++ Singular preprocessor definition needed

  This is my first post, I hope to be clear enough (sorry for my eglish) and I hope to be lucky and find the answer to a very big problem. I have a VC++ project and I need to create, during the compilation, a define that has the same name of the file that I am currently compiling. For example, if when I am compiling a file called Main.c I need to create runtime a define #define main 1 I do this by specifying the in Preprocessor Definitions section $(InputName)=1 The problem is that the command above create a define #define Main 1 instead I need the name of the file in lower case . I thought in the beginning to create a custom task in M ...Show All

• Visual Studio 2008 (Pre-release) OrderBy/ThenBy and stable sorts

  Hi, From the documentation in the LINQ Preview I read that OrderBy/ThenBy operators do NOT perform stable sorts (i.e. the don't respect the original order of elements having the same key value). What's the reason behind that Efficiency Regards - Octavio ...Show All

• Visual Studio Express Editions Registering Visual Basic 2005 Express

  I am trying to register Visual Basic 2005 Express. I use Lotus Notes for E-Mail. Every time i click register I get the following error: The notes.ini file can not be found on the search path. the file is in C:/Windows which is in my search path. Do i have to be using Outlook to register VB 2005 Express Do you use the Help->Register product... menu from inside VB Express You might need to use Internet Explorer to register. The FAQ describes how to set IE as default browser, paragraph 8. EDIT: The link to the FAQ http://msdn.microsoft.com/vstudio/express/registe ...Show All

• Visual Studio Team System looking for web test

  VS 2005 newbie. I have VS team edition for software developers RTM version. I am trying to create a web test.  However, web test is not an option. NOTE:  The AuthoringTests.txt eludes to test version - but this is not specifically stated. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/vs05tmsyswebtst.asp  does not give an explicit statement that the web test is for test edition only. "Applies to:    Microsoft Visual Studio 2005 Team System    Web development" So why is the web test not an option Thanks, Johnathan ...Show All

• Windows Forms Bad opinion about .NET framework

  Dear Friends, I am using Visual Studio.NET 2005 (Whidbey) to do my developing and designing work. I have developed windows application.I copied the EXE which I have developed,to some other machine (Machine which doesn't has .NET framework 2.0). While running the EXE,I have an error that "you should have .NET framework version 2.0.5314.0 ..." This is really bad. How do they expect that all sys have the framework Then what is the purpose of EXE This is really bad.. Once again they have proved that they are "Microsoft (Not clear)". Any other comments.... Sorry to moan, I was reading this thread and had to comment.   I find your ...Show All

• SQL Server Problem in creating reports using BI fields

  Hi, I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there. Does anybody have any suggestions as to why this is happening and what the way to overcome this. Thanks in advance MNJ ...Show All

• Visual Studio Tools for Office XMI - Tool compatibility

  Hi, Is it possible to get the formats in which different tools use to emit XMI while exporting file As of now, there is no standard XMI format that all tools follow isn't Why is it so Is there any possibility that this could become possible in the future Thank you. Yes, we do provide an add-in to Visio that lets you export parts of a UML model in XMI format. However, the answer to your question of why there is no common standard that all uml tools follow is quite a complex one. Here is an excerpt from Steve Cook's article on Domain Specific Modeling and Model Driven Architecture that talks a ...Show All