Insignals's Q&A profile

• Visual Studio Unable to debug Stored procedure using Visual Studio

  Hi, What is the procedure to enable SQL Server Debugging I have the following apps. installed in my PC: IDE: VISUAL STUDIO 2005 With SP1 Beta, DB: SQL Server 2005 Developer Editon The problem is, after setting up my connection and sucessfully opening it and started my debugging procedure by right clicking onto the opened stored procedure, i don't see the 'Step Into' button to add my break points. So, i was wondering maybe the debugging function is not enabled. Thanks. Dencio, You need at least the PRO version of Visual Studio 2005 in order to debug stored procedures. Which SKU do you have Azeem Khan Visual Studio Debugger. ...Show All

• Visual Studio Express Editions scrolling panel as text expands

  Hi all, I'm using a panel to display text using the e.Graphics.DrawString function... Unfortunately, the amount of text that I will be displaying is bound to vary, and as such, I need my panel to scroll as needed. Of course I have the autoscroll property set to true, but when more text is added to the panel that can be displayed (ie, i need to use a vertical scrollbar), a scrollbar doesn't appear, and I can't view all of the text. Does anyone know how I can make the panel scroll appropriately as needed Thanks so much Any input is greatly appreciated! Thanks again -Robert Stephen - thanks for that: "Scrolling the text is glitchy" You're not kidding. I think this could be made to work but like I suggested above al ...Show All

• SQL Server Primary Key Violation

  Dear Friends, I am a DBA and I am getting a lot of table locks due to unhandled errors in front-end developed by Power Builder, 5 years back. The backend is SQL Server 2000 Enterprise edition. Below I will explain the problem in detail. The Big Problem. { O Users enter sales data into rm_salehdr (docid,..,..,..) table (LOCKED) O The rm_salehdr table need a new docid O The new docid will be generated by a function called as docnogen O The docnogen function o will select the last docid from ps_docno table o add 1 to last value o return docid to rm_salehdr o update the last docid with the new value. o ps_docno table will hold the lock till the insert transa ...Show All

• Visual Studio Express Editions Richtextbox: changing string(s) into pictures

  Hi Is it possible to change a word (string) into a picture (I know it's possible to change a certain string into another string with the replace command.) (for exemple: the use of emoticons. when entering a certain string that changes into the corresponding emoticon.) If this is possible, how do I need to do this. Thanks in advance. Shoot, didn't think that the forum bug was going to mess up my post. Giggle. The lamp icon in the post replaces "[ i ]" (without the spaces). ...Show All

• Visual Studio Team System Creating new field [Namespace]

  Hi, I am trying to create an entirely new work item field for my process template. I successfully created and validated the work item type definition XML but without creating the new field. I want to create the field "MyCompany.VSTS.MyProcess.MyField' . This is like 'Microsoft.VSTS.CMMI.SubjectMatterExpert1' 1. Where can I find object model [Interfaces, References] to create this field 2. What is the process in upload this assembly to server {I am unable to find any assembly 'Microsoft.VSTS.*' in any of the server drives or in my client development machine} Any help appreciated. Thank you, Praveen That is what exactly I did. I downloaded process template, edited it, renamed ...Show All

• SQL Server Printing History

  I need insert a record into a table each time a report is printed including information about parameter values on the report. Is it possible to add custom code to call an insert statement then the print command to achieve this There is no print command so I am not sure where you are suggesting adding the code. You could use the Execution Log and get all instances of rendering to EMF format. While this doesn't gurantee that it was a print job, it does give you the other information you need. ...Show All

• Visual C# simple streamwriter question

  This is what i have so far: private void radioButton9_CheckedChanged(object sender, EventArgs e) { devicesConfigurationFile_ = @".\Devices.xml"; using (StreamWriter sw = new StreamWriter(@".\Devices.xml")) { messageNode_ = "//DEVICES/DEVICE_LIST/MESSAGE_LIST_RECEIVE/MESSAGE/Login"; XMLDocNodes_ = XMLDoc_.SelectNodes(messageNode_ + "/Login"); sw.Write("no"); } Its writing a new text file every time the button is clicked when i just want it to append an existing file after parsing through to the correct attribute. The file it will be parsing through is XML. Any help would ...Show All

• Visual Basic Create new Webbrowser

  I want to create a new webbrowser and display it in a tab I tried this Dim browser as New Webbrowser in TabControl1.SelectedTab But that doesnt work... hopefully based on that code you know what i'm trying to accomplish.. it doesnt compile at all because of the errors but your solution works, but I also have another problem there is a button for a textbox I have the button saying webbrowser1.navigate(textbox1.text) But when there's a new tab, the browser in the window won't be called webbrowser1, it would be called webbrowser2 or something like that so how would i specify the button to navigate using the selected tab's browser ...Show All

• .NET Development XPathDocument and IDisposable

  Hello, I Have a large XML file where i use Xpath for retrieve some data. Now that works just fine. But my memory is increasing each time i open a new XML file. Is it possible to dispose the XPathDocument It is NOT possible to somthing like this: XPathDocument XDoc = new XPathDocument([Location]); ........ Searching in document .... ((IDisposable)XDoc).Dispose(); Is there a way to decrease my memory Please help me out and ... Thank you for your time. The better way to write this would be: using( XPathDocument XDoc = new XPathDocument([Location]) ) { // ........ Searching in document .... } This doesn't mean that document would be collected immediately, but it would be collected next time GC happens. You can e ...Show All

• Visual Studio Express Editions Control Not Registered At Runtime

  Hi, I've got a strange problem regarding a COM object. I've put a Winsock Control on my form to handle socket functions, now it all works in the design environment but when I publish to another computer the program stops and displays a error box telling me that a control in not registered, it only does it with the form that the winsock is on. Now I understand that controls have to be registered but I thought the setup did this automatically, I'm using 'ClickOnce' settings if that makes any difference, I've also tried importing the winsock's namespace in the publish options (it was unticked). If I launch it from my computer it all runs without problem. Its likely that the setup isn't registering the control, that seems to be the on ...Show All

• Visual Basic Trigonometry Woes

  Ahh, it's good to be back. Did y'all miss me Oh well, here's my question. I have asked this in the C# forums, but I am also very keen as to how this could be done in VB.NET as well, so I thought I'd pitch it at you guys, too: I am having a bit of difficulty with coding some trigonometric functions. The primary goal I have at the moment is to find the two unknown angles in a right-angle triangle of which I know all 3 dimensions. While I know how to do this in theory, finding the code to accomplish this is proving difficult. For example: I have a triangle with a base of 6cms, a height of 5cms and thus a hypotenuse of ~7.81. It is a right-angle triangle and thus one of the three angles is 90 degrees. How can I find the other two angl ...Show All

• Visual Basic Saving ID Values in Tables

  Hi, I am using Visual Basic 2005 professional and SQL Server express edition to develop an IT Asset Tracking System. One of the queries I have is how to save the ID values in a table when the Save button is clicked on a form. For example, one of my tables is called AssetCategory: AssetCatID Category 1 Computer 2 Software 3 Printer and then I have an AssetSubCategory table: AssetSubCatID AssetCatID SubCatName 1 1 Desktop PC 2 1 Server 3 1 Notebook 4 3 Laser 5 3 Dot Matrix My form has a category combo and a subcategory combo therefore if the user select ...Show All

• Visual Basic plz help me to know he differences between the following statements

  plz help me to know he differences between the following statements k = Chr(KeyAscii) Like "[0-9.]" k = Not (Chr(KeyAscii) Like "[0-9 -]") k = Chr(KeyAscii) Like "[0-9/]" thank you. thank you. i have another doubt in masked edit control. how to allow unlimited numbers to be entered. that is, i used masked edit for getting the amount details. so i may enter 1000.00 for one person and 10000000.00 for another person. i tried to hav ########.##. but if i hav to enter 100.00 its not moving to the decimal part. how is this made possible ...Show All

• Visual Studio Express Editions problems with getsystemmenu and removemenu from user32.dll

  Hi, I'm trying to edit the items in the system menu for my project, and have read all the previous posts on this, but it doesn't seem to be working for me - I found that previous posts all had an attribute list for GetSystemMenu Lib "User32" ( ByVal hWnd As Long, ByVal bRevert As Boolean ) As Long which didn't work for me, but I found out that GetSystemMenu Lib "User32" ( ByVal hWnd As Long ) As Long does work. Now I'm having the same problems with Removemenu and can't figure out what arguments it wants. Is there any way of finding this out Here's the code and the error: Private Declare Function RemoveMenu Lib "User32" ( ByVal hMenu As Long , ...Show All

• SQL Server Need some help with DTexec execution

  Hi! When i excute in the sql server this works fine xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx "' but when i excute throught the C# code jobCommand = new SqlCommand(@"xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx"'", cconn); It shows up red lines near the " and ' qoutes. I know that quotation marks are wrong but don't know how to solve it. some help please Thanks jas one more guidance needed with regard to the Quotation marks path = @"D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx"; jobCommand = new SqlCommand(@& ...Show All