mark.b's Q&A profile

• SQL Server Reporting Services parameters not in correct order

  Hi, SQL Server Reporting Services 2005. I have 13 parameters, ordered correctly within the Report Parameter screen. When displayed in the Preview tab they are all ordered correctly, but when viewed in the application the first 4 are at the top but ordered incorrectly. The remainder are ordered correctly. I have tried reordering, saving, deploying, viewing and then doing the same but in the correct order without any success. Please can someone suggest how I can get the parameters to appear in the correct order within the application Thanking you, dwemh Yup, can only have 2 columns in our UI and we don't expose a property to set the number of columns. I've added a design change request ...Show All

• SQL Server how to run dts package in ASP.NET or as a SQL query

  Hi Guys, does anyone know how to run a dts package in ASP.NET page at the moment i'm running it using dtexec /DTS "\MSDB\send mail test" /SERVER "." /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V /SET "\Package.Variables[username].Value";guru /SET "\Package.Variables[message].Value";"body of the message" i want to put this in a web page now invoke the same thing. also is there a way to execute a dts with a sql command insted of connecting to integration services engine help please hi, I am trying to do the same thing, but i have the package installed in a remote machine and i would like to excecute the package from my machine through ...Show All

• SQL Server Week Number calcluation

  Hi Chaps, I want to calculate the week number by the following rule "For the week that has the 1 st January included if any days are not in January then set the next week as week number 1" Can any tell me the piece of code thanx Anas Input will be of DATE and it will give the week number of that date but using the following rule "For the week that has the 1 st January included if any days are not in January then set the next week as week number 1" ...Show All

• Visual C++ Showing one instance of the same control in multiple windows

  Is this possible Can I, for example, have a CTreeCtrl in my CDocument class, that gets shown in all dialogs that might need it and updates on all windows when a change is made through one of the windows Thanks in advance It is not possible. A window can have only one owner/parent. However See Windows SDK forum for Windows programming questions ; you might get better help in a Windows programming newsgroup or forum. For questions about the Windows MFC Document/View Architecture, there is a Microsoft newsgroup for those. I am not sure if those questions are supposed to be within the scope of this forum. I can say this much: whenever possible, it is best to use MFC in a manner consistent with it's d ...Show All

• Visual C++ Access DB via ODBC in C++ console app

  Hello, We will program a series of small modules to update dbs without operator intervention. We look for a library / sample to start up. Where can we get a startup vc++ short console sample doing this Thanks and best regards. You can use ODBC API , but that can be a real mess even if you want just a simple console application. Much more easier is to create a Console application which uses MFC, then enjoy using CDatabase and CRecordset classes. Here is a startup vc++ short console sample that opens a database and inserts a record in a table. // ODBCTest.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include "ODBCTest.h" #ifdef _DEBUG # ...Show All

• Visual Studio Team System Unable to determine the workspace

  I am executing the below command line implementation as .bat file. I am getting "Unable to determine the workspace" while getting the latest version. IF NOT EXIST C:\TFSGet MD C:\TFSGet tf workspace /delete ws1 /noprompt /s:s1 /login:j,j1 tf workspace /new /s:s1 ws1 /noprompt /login:j,j1 tf workfold /s:s1 /workspace:ws1 /unmap $/ tf workfold /server:s1 /workspace:ws1 /map $/x/y/z/customer/9 C:\TFSGet tf get /recursive /noprompt echo getting files echo finished Yes, I am using more than one workspace in my system. The first one is default workspace and the another one i am creating through script. OK... Please let me know solution for handling more that one workspace AJS ...Show All

• .NET Development ToInt32 Exception

  I recently moved an application developed in VS2005 on Windows 2000 to VS2005 on XP pro. Now I have format exceptions occurring when using Convert::ToInt32 when the string is a "1". To check this further created simple project with button and two text boxes, working bit is: private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { String^ ares = textBox1->Text; int aint = Convert::ToInt32(ares); textBox2->Text = Convert::ToString(aint); } This fails every time when just 1 is entered with System.FormatException - Input string was not in a correct format, or if more than one digit is entered a leading 1 is ignored. Works ok if a leading zero is entered. If I change the second line to ...Show All

• Visual Studio Express Editions Add numbers

  Hello all, I need my program to add nine numbers together and get the some. I am using this code: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox2.Text = Txt1.Text + txt2.Text + txt3.Text + txt4.Text + txt5.Text + txt6.Text + txt7.Text + txt8.Text + txt9.Text TextBox2.Text = TextBox2.Text / 9 End Sub It is not doing what i need it to. Without deviding, lets say all of the numbers were 100, it would write 100 tons of times. How can i fix this Ok,   Now it has got the adding part down, but now the deviding part wont work. When i make it devide, the average ends up 150 for two 100's!   Edit:  ...Show All

• Visual C++ C++/CLI C++ Interop and FxCop/Code-Analysis warning CA2122

  I've purposely been ignoring a CA2122 warning in some C++ interop code I've been working on for quite some time.  I've just recently had the cycles to investigate the warning  The warning message is as follows Warning CA2122 : Microsoft.Security : MyClass.Method():Void calls into Marshal.GetExceptionPointers():IntPtr which has a LinkDemand. By making this call, Marshal.GetExceptionPointers():IntPtr is indirectly exposed to user code. Review the following call stack that might expose a way to circumvent security protection: ->System.Runtime.InteropServices.Marshal.GetExceptionPointers : IntPtr ->MyClass.Method : Void ... MyClass is a managed class where Method calls a native static (for readable illustration purp ...Show All

• Visual Studio Vista Compatability problem with VSIP package

  I implemented VSIP package which works under VS2003/2005 with WinXP/W2K. Inside our package, there is a functionality which writes different messages to the log file. After migrating to Vista, that functionality did not work because of "Access to the path 'XXXX' is denied.". After reviewing some Vista Compatability articles, I found that we need requestedExecutionLevel = highestAvailable which should be in app manifest. But our app is "devenv" and we cannot change its manifest. Is there a solution to run VSIP package with highestAvailable execution level Yes, you are right, when the devenv.exe run with Administrator credentials everything works well. But we cannot suggest users t ...Show All

• Visual C# ExtractAssociatedIcon Help!!!

  Hello, I'm trying to extract icon from exe files during runtime, i know about the following function. Icon ico = Icon.ExtractAssociatedIcon(@"C:\WINDOWS\system32\notepad.exe"); this .Icon = ico; The problem is when i save the icon object to the disk!! MemoryStream Memo = new MemoryStream(); ico .Save(Memo ); File.WriteAllByte(@"C:\DLICO.Ico", Memo ); The above code should write the icon to C:\ the icon is saved but its deformed!!, i mean its colors looks very bad, can any one help, mention that the icon appear correctly in this line this .Icon = ico; but the saved icon appear very bad. Please help, thanks I'm building an app. that take as an input exe file and encapsulate th ...Show All

• SQL Server Is this possible???

  Hello, My question relates to the following select statement: Select Report_description from Report where Report_name = (grab this value from the item selected from a listbox) I wonder whether it would be possible to make the above statement a stored procedure but instead of filling in the last value in the bracket, I would like to grab that value from else where, for example from an item from a listbox which has been selected by the user. Hi is Dude we use this n number of time. The thing you need to do is, just create the comma separated value of the selected item list in the front end. As an Example list selected values as 'i','am','a',boy' (you need to do this in the front end ...Show All

• Visual Studio Express Editions DATA ENTRY WITH A DATAGRIDVIEW

  Hello, I'm struggling with a problem. I have a datagridview (unbound) formed by 5 columns to be used as a data entry. the type of the columns in the order are: textbox,combobox,combobox,texbox,combobox. I enter a value in the first column.When I move to the second cell to enter another value the first column value disappeared... and I'm not able to to get it again. I want the entered values remain in cells ... Thank you, in advance for helping me NETLAND With DTGW .ColumnCount = 1 .ColumnHeadersVisible = True .Columns(0).Name = "TYPE" 'TEXT COLUMN .ColumnCount = 2 Dim VstrStruttura As String ...Show All

• Visual Studio 2008 (Pre-release) Communication Client Server via http

  HI , What is the best way to communication between Client and Server. The Sever will be a Web Server. Client will be a windows application, windows service or Web Services. Client cannot be a Explorer. Basically client need to access its own machine and machine on local network. And send the info to Server. Ofcourse, if you are posting on this forum, the answer is WCF! Seriously, what you're asking is a 101 scenario for WCF - client and server talking to each other where the server is hosted on IIS; and the client could be a self hosted console application. I would suggest you download the SDK if you havent and just go through some quickstart samples; if you get stuck, you c ...Show All

• Visual C++ Issues with Docking

  Hi Ppl, In my application I have a menubar(stingray) and toolbars. I want the menubar to stick to top. I have made menubar non-floating and docked to the top. But since there is a toolbar also, if I drag the toolbar on top of teh menubar, it docks on top of menubar. I want that menubar should always be on the top, an dno other ControlBar should be docked on top of it. Pl suggest as I am badly stuck :( Thnx Prateek What technologies are you using, MFC, Win32 APIs, etc Thanks Damien ...Show All