silkkeng's Q&A profile

• SQL Server For loops in Tsql

  Can somebody please tell me how can i write a tsql statement in sql server 2000. Same time how can i get the last digit of a inteager variable through tsql .What i want is to write 'right(intVariable,4) which is in vb .I want that in sql server 2000 Thank you Hi rohanfernando, I moved your question over to the Transact-SQL forum. The folks over here should be able to help you with your question. Cheers, JJustice [MSFT] ...Show All

• Visual Basic Recording sound from microphone in VB 2005 EE

  Please, could you  tell me how to record sound from microphone in VB 2005 EE . If you would be so kind anything simply. Thanks. Wow, thank you!!! I was looking for a solution like this for a week now! (I was trying to work with overcomplicated sound class libraries that are not even implemented in VB.NET to do exactly what this code does until I stumbled across this thread) I have a couple of questions: Is it possible to record the sound and then play it without having to store the file in the harddrive If it's not possible, then is there a way to delete the record.wav file after playing it Thanks ...Show All

• SQL Server Web parts for Report Explorer

  I understand that a report explorer in Sharepoint can be used to show the lists of available reports from the report server. However how do I restrict a particular account the categories of reports he can only view..from sharepoint configurations and not from report server..thanks. Regards Alu but is it possible to leave the settings in RS alone while configuring only the restrictions in SPS ..the reason being that I am trying to center the 'functionalites' around SPS and RS is just a collaboration to it thus more control from SPS instead of RS... Thanks. Regards Alu ...Show All

• Windows Forms "Shortcut activation over network is not allowed" ClickOnce Error

  I can install the ClickOnce application from my local system onto my computer and it automatically installs on my profile which is located on our network. This works just fine. The problem comes when I publish an update and I then I open up my application without installing it yet. I have set my ClickOnce configuration to update once I run the application. As soon as I run the application I get a dialog box with an error message "Shortcut activation over network is not allowed". The details buttons shows the message below. Any idea how this can be fixed or worked around, without changing any network or system settings. Thanks, Eric PLATFORM VERSION INFO  Windows    : 5.1.2600.131072 (Win32NT)  Common Language Runt ...Show All

• SQL Server Execution Plan in Query Analyzer: What does this symbol mean?

  Hello, I just run an Execution plan ( not a Estimated Execution Plan ). Over (at the right bottom) some normal symbols of the Execution Plan appears a little symbol. That symbol is a yellow circle, with 3 arrows aiming at the left. Could you explain me the meaning of this symbol, please Sorry for my english, I hope you easy understand. Thank you very much Jonathan It could be due to parallelism, refer to the books online and this link http://www.codeproject.com/cs/database/sql-tuning-tutorial-1.asp  about understanding Execution Plans. Also try with Estimated execution plan and see whether you get that and if you put your cursor near to that icon you will get the information. ...Show All

• SQL Server Application hangs on SqlCeConnection.Dispose()

  Hi, I'm having the problem that my application hangs on SqlCeConnection.Dispose() when I'm closing the app. public class DatabaseManager : IDisposable { private DbConnection connection = null ; // Singleton private DatabaseManager() { this .CreateConnection(); } ~DatabaseManager() { this .Dispose(); } public void Dispose() { if ( this .connection != null ) { this .connection.Dispose(); } } // ... } This only happens when I'm calling Application.Exit(); and Dispose is called through the destructor of the DatabaseManager class. When I'm disposing the connection during normal work the call works as intended. BTW I'm using SQL Server Mobile 3.0.5214.0 on a PPC 2003 AKU2 (Symbol PPT88 ...Show All

• Audio and Video Development iHDSim crash referencing unloaded element

  This is both a question and a comment/bug report. Steps to reproduce the bug (iHDSim released 8/29): Load iHD application. In script, after markup is loaded, store a reference to an element on the current page (I used getElementById()). Use the <link> tag in a <cue> to cause a new markup page to replace the current page. Attempt to reference a property of the element stored in (1). The reference attempt is surrounded by try...catch(). iHDSim crashes with a memory reference error. Questions: What is the correct behavior I'm guessing an exception should be thrown. Is there a way to check whether an element exists before trying to reference it's property to trigger an exception It seems that something is getting deleted/garbage ...Show All

• Visual Studio Express Editions Web page viewer/browser in VB?

  For my program i'm thinking of having a news webpage on my website, which would provide news related to my program ie upcoming updates/new updates so on. I would like this webpage to be viewable inside my vb program in a panel. Is this possible to do I was fiddling around and I noticed a web control object, added that to the form and it worked. Didn't realize it was that easy. ...Show All

• Visual Studio Team System Custom Work Item Controls - How can you have one custom work item control trigger the InvalidateDatasource() method of another?

  I want to create two custom work item controls. Each control will be a drop down list box. In the InvalidateDatasource() method of Control1, I retrieve information from a database, populate the drop down list box, check to see if a value has already been selected for the list box, and if so, set the list box equal to that value. I've got this working (which is pretty cool!). Now, based on the contents of the first drop down list box, I want to filter what contents are in the second drop down list box, called Control2 (picture Control1 being a list of states, and Control2 being a list of cities, specific to which state is selected in Control1). How do I, from Control1.InvalidateDatasource(), trigger Control2.InvalidateDatasource() Con ...Show All

• Visual Studio 2008 (Pre-release) How do I implement the light gray background text in a TextBox?

  Windows Vista has lots of places where text boxes show a light gray info message on the background telling the user what they can enter in that box. The message disappears as soon as the user types something in the box. For example, the search box in explorer windows demonstrates this functionality. The Windows UX guidelines talk about this as well. How does one go about implementing this functionality in Avalon Is there a way to modify the TextBoxBase template perhaps This is what I ended up with... using System; using System.Collections.Generic; using System.Text; using System.Windows; using System.Windows.Controls; namespace MSCAF { public class InfoTextBox : TextBox { public InfoTextBox () : base ...Show All

• Visual C# Why string is a reference type?

  I don't understand it. System.String hola = "tal"; System.String hola2; hola2 = "talycual"; Debug.Print(hola2); hola2 = hola; hola = "___"; Debug.Print(hola2); And the output is: talycual tal If string is a reference type ... the output must be at the last line : ____, but 'hola2' has a copy of 'hola' . I understand differences between struct and class, and because is struc a value type and because is class a reference type but ... i don't understand because is string a reference type Regards. What follows won't compile, but should help you see the difference. See your original code as: System.String hola = new System.String ("tal"); System.String hola2; hola2 = new System.St ...Show All

• Visual Studio Formula field of Crystal Report

  Hello everyone in the forum. I am a new C# programmer and using Crystal Report10 for creating a report. My problem is, I have created a report which shows a list of company names and total sales figure for each company name.The sales figure has been calculated using a formula field. Now I want to insert a serial number(like 1,2,...) which will increase with each company name.Another thing is I want to calculate the total of the sales figures of the company's. I am confused whether I have to use another formula field or use a SQL expression field and How to do it Please help me out of this problem. Thank you for your reply. It solved my problem. Now I have got a new problem. I have three tables- ...Show All

• Visual Basic ListView control Problem - missing blue rectangle around selected item

  Help please, I did simple form containing Tabcontrol and Listview on one Tabpage. During initialization I put some items and set selected property of one of them to true. When the form is shown no blue rectangle arround selected item Similar problem is when I switched between tab pages. I selected by clicking one item. The blue rectangle is ok. Then I switched to the second tabPage and then returned back to first one with selected item in Listview - the blue rectangle disappeared. How to solve this problem Could you help me please. What I'm doing wrong (I' tried to call refresh, focus on listview control no improvement in behavior). Thank you in advance. Vlastimil ...Show All

• Visual Studio How adequate-rich or suffitient-complete the DSL?

  I want to develop Relational model or Data base - showing tables, connections, attributes, but also -type of attributes, their length, connection between tables - by attributes. So - how I can resolve desires to show more rich look then just table-attribute ____ Or for object model- how to show methods and objects separately or with some icon Or not with icon - by how can I show many different things or hierarchical things on attributes set One of the nice things about the DSL Toolset is its flexibility. For example, suppose you start with the Class Diagrams template. At first, each class is represented as a box, and each attribute and operation is represented as a line item within the box, in the ...Show All

• Visual FoxPro copying tables from sqlserver to foxpro and vice versa

  Hi Experts, How can I copy an entire table from an SQL server database to foxpro (*.dbf) i.e i need to create a backup of sql server tables in foxpro (*.dbf) Any help Thanks in Advance [1] Establish a connection to SQL Server [2] Use SQLTABLES() to get a list of the tables [3] Use SQLEXEC() to select all data into a VFP cursor for each table [4] Use COPY DBF("sqlresult" ) TO [vfp_table_name] to create the VFP Table. ...Show All