MadhuK's Q&A profile

• SQL Server User Tables really accesed by SQL

  I administre a DB that has about 2000 user tables, unfortunatly I haven’t documentation, and the people that create thouse tables are no more in the company. How can I identify the user tables that really are used by SQL today I used the Profiler to identify the Stored Procedures that are called recently, but when I try to use Object:Opened event class to look the tables that are opened, it dosn’t display anything. I hope you can help me. Profiler Event: SP:StmtCompleted this event will log the actual queries being executed regardless of if the query was wrapped up in a proc or inline. Derek ...Show All

• .NET Development checkbox in datagrid

  hi all, I don't know whether this is the right place for posting this thread. If this is not the place means please do tell me where to post this thread. Actually i have created a datagrid in which i have added a checkbox. So this checkbox gets automatically generated according to the data's in database. The problem now i am facing is , i have three columns in my database and i have added the checkbox in the first column and the remaining two consists of label. So when i check the checkbox in my datagrid the value on the third column of that selected row should be selected. How to select that value ...Show All

• Visual C# Creating an instance of Abstract Class

  Iam analyzing the Source Code of ADO.NET, using Reflector... I notice that the DataColumn have internal Property called Storage from type DataStorage The Code Like This: internal DataStorage Storage { get { return this . storage ; } set { if ( this . storage != null ) { throw ExceptionBuilder . StorageChange (); } if ( value != null ) { if ( value . Table != null ) { throw ExceptionBuilder . SetForeignStorage (); } value . Table = this . Table ; } this . storage = value ; } } The DataStorage Class is an Internal Abstract Class and in the code above they define a property from type storage which is abstract c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to use fx software?

  hi all, I tried to usefx composer and render monkey create new fx file. But i not understand to create new effect file and how to add fx code in c# framework Please somebody help me. Best regards, Brian Tsim I suggest you taking a look at how it's done at www.mdxinfo.com Basically what you want is a .fx file with some kind of processing happening inside of it. What you could then do is load them using the DirectX API such as Effect.FromFile() method. This will return an effect that you can use to render your scene/objects with. There is obviously a bit more involved but mdxinfo's tutorials should give you a good understanding on how to accomplish this. I hope this helps. Take care. ...Show All

• Visual Basic How to retrieve every subfolders and files of a specified directory ?

  Hi everyone, I would like to import every subfolders and files of a designated folder, Code samples I tried so far, only shows first sublevel and do not go further (not the full tree), which can also be obtained by using Directory.GetFileSystemEntries().   Anyone knows a good method on how to import every files and subfolders , and store them into an array    Thanks a lot     try this... Dim theFolders() as String = System.IO.Directory.GetDirectories( path , "*", SearchOption.AllDirectories) Dim theFiles() as String = System.IO.Directory.GetFiles( path , "*", SearchOption.AllDirectories) ...Show All

• Visual Studio How to add pages to a report *.rdlc

  Hello. My question is very easy, but I have not been able to solved it. I need to add a new page to a report I am designing but I don't know how to add one. I extend the body page but this don't work. I need a new page (page no2 of the same report) in which I can add also the page footer. This in order that when I run the report in my program, in the upper bar I can choose page 2 of 3, for example. Thanks in advance, Mike I have the same question i need to add a new page at the front of each report somewhat like a cover page. Any suggestions thanks vijay ...Show All

• Visual Studio 2008 (Pre-release) Viewport3D BUG ?

  In Vista RC1 Viewport3D content becomes aliased when window is resized, even when I specified RenderingOptions.EdgeMode="Unspecified" in root Page object. How can I make 3D scene always antialiased My video card is ATI Radion X1600 XT with 256 MB video memory. Driver is from x64 5600 Vista build (installed automaticaly by Vista install). RAM is 2 GB. Without window resizing content displayed with AA even when I launched several copies of application. ...Show All

• Visual Basic Fill Several Combobox with the same values from database

  Hi, I have 15 Comboboxes in a form and I have to fill them with the same values from a database table. If I use the same datatable to fill them all at the same time, everytime I select a a value form a combobox, all the rest show the same value !!!!, I don't know why this happens. So I tried to use a function to open a new datatable for each Combobox datasource and works fine, but the problem is that my application turns slower when loading that form. This is my function when all ComboBoxes take the same value when some of them is selected: Public Sub FillCombos( ByVal xComboArray As System.Collections.Generic.IList( Of Windows.Forms.ComboBox), ByVal DBConn As SqlClient.SqlConnection) Dim i As Int16 ...Show All

• Smart Device Development ListView Vertical Scrollbar

  Hi, I need to have a ListView only with a Vertical Scrollbar, but i don't know how! At this moment i have a listview with the view propertie set to List ! In this listview i have only a colummn, but due to its size (listview), an horizontal scrollingbar was created Does anyone knows how to solve this Thanks timg_msft wrote: Put your ListView in a panel at (0,0). Make the panel's width the width of your ListView control less the width of a Vertical scroll bar. PInvoke to GetSystemMetrics(SM_CXVSCROLL) to get the scroll bar's width. Hi timg_msft, I am very new to Pocket PC application development. Could you please elaborate on how to use the PInvoke and the entire process. E ...Show All

• SQL Server Specified job_id does not exist

  Hi, We have snapshot replication set up on a SQL 2005 box where the publisher is a SQL 2000 box. Replication was running properly for weeks. Because of some application upgrades, we had to remove the publication and subscription and re-apply once the upgrade was done. Replication is still running properly, however when we look at the job history on the subscription, we get an error message: Could not show the Properties window The specified @job_id (.....) does not exist. (Microsoft SQL Server, Error: 14262). I suspect this is referring to the old job but am not sure how to clear this from memory. I can view the job history on the actual job within SQL Agent and the job is running properly, but this error still occurs when I v ...Show All

• Visual Basic User Control problem

  I have a UserControl which basically shows in a textbox the content of a row in a table relationally linked to another table in a database and also a combobox containing the contents of that second table. This mean that as you travel through the main table you can see what the linked text entries are and have a combobox when entering a new record. I started the table in VB.NET 2002 and upgraded it to VB2005 Express and have been using it successfully for some months.So, it has saved considerable code and added to my VB skills. However, having recently discovered the MaxDropDown size property for the combobox I wanted to add a line to the UserControl to fix the MaxDropDown size to be the size of the records in the table it accesses. T ...Show All

• Internet Explorer Development Set up cannot locate browsers plug in directory

  I'm trying to install adobe flash player 9 and I'm receiving this message that set up could not locate your browsers plug in directory. I have Windows XP, Internet Explorer 6. Please help. The Windows XP Internet Explorer 6 default plug-ins directory is: C:\Program Files\Internet Explorer\PLUGINS ...unless you chose to change to a different directory during Internet Explorer 6 setup. Good luck. John ...Show All

• Software Development for Windows Vista How to retrieve value of ActivityInstanceId (or Activity's ContextGuid) from an HandleExternalEvent1_Invoked method?

  I have a StateMachineWorkflowActivity where each state contains a EventDrivenActivity, HandleExternalEvent, and SetStateActivity. In the HandleExternalEvent1_Invoked handler, I want to be able to access the ActivityInstanceId (or Activity's ContextGuid) value   How can I do this (ActivityInstanceId is the name of a field in the ActivityExecutionStatusEvent SQL tracking database table.  An Activity's ContextGuid appears to server a similar purpose.) Michael. private void HandleExternalEvent1_Invoked( object sender, ExternalDataEventArgs e {     TaskActionSentEventArgs e2 = ( TaskActionSentEventArgs )e;     Console .WriteLine( "HandleExternalEvent1_Invo ...Show All

• Visual C++ Millisecond timer in C++

  Does anyone know of any timer function/class in C++ I can use that measures elapsed time (let's say before and after a function call) in milliseconds I seen some custom implementations on the Net (such as CDuration class) but that requires incorporation of custom classes written by someone else. Any other idea Thanks in advance. This is my class which uses high resolution time counter. Read instructions in the comments. In .NET there is StopWatch class which does the same. In unmanaged code I use this. // TimeCounterEx.h // // File is used to measure how much time take some parts of the program // // Using: // // 1) include this file to any C++ source file // // 2) Write // &nb ...Show All

• Visual C++ VS .Net 2005, how to disable intellisense...

  Hi I am really frustrated with the performance of VS .Net 2005. This is because I always see at the bottom "updating intellisense..." and it uses 60% to 70% of CPU. How to disable this updating of intellisense... Please this is making Visual studio unusable. Thanks Chandra Hi Chandra, Could you describe the size of your solution Do you have many projects Do you find yourself changing the headers often Do you change configurations often (e.g. from debug to release and back) Does your code make heavy use of preprocessor macros Thanks, ...Show All