ashk1860's Q&A profile

• SQL Server Attach damaged database

  Is there any way to attach a database that is missing a ndf for a file group Note: The file group has no database objects on it. Thanks My first answer is no, but maybe you can create a "dummy" ndf file with all the same properties that the original ndf file should have ...Show All

• Visual Studio Visual studio Combo box selected detection

  I need to detect when a user has entered a combo box, for example, when the user enters the Types dropdown from the class's code view. You can select the Types dropdown menu using the mouse.You can also press CTRL + F2 to navigate to the Types dropdown. I want to do this so I can remind the user that there is an available short-cut for that particular action. This, I hope, will improve the efficiency of the programmer using the IDE. I will send a modal dialog that can only be closed by the user using the correct shortcut command--that way the user will slowly remember all the possible shortcuts. I have implemented most visual studio .net commands in this way by trapping the command events that are raised when a Visual Studio command has b ...Show All

• Windows Forms working with MySQL data bases from windows ODBC connection

  Here's the problem: I've installed the mysql odbc connect (v3.51.12) and I've created a data source connection ...added a DataSource to my project binded the data with a dataGridView and all worked well. My dataGridView fills up with the data from my db. All fine until this point. Now I want to be able to save the changes I make to the data in my dataGridView and update(insert) the data in my data base. How can I commit those changes Using query parameters InsertCommand.CommandText: Insert into FooTable (ColA, ColB) values ( , ); InsertCommand.Parameter: Create 2 parameters for the command with the dialog that opens. Charles ...Show All

• .NET Development XML Searlization of a text file

  I have a text file that I wanted to convert to XML based on a class that I create. It contains 21 string fields, all of various lenghts. Do I need to overwrite the Read and Write methods of the serializer interface, or is there a way to specify the lenght of the fields without having to do that Actually, the text documents contain 2 different field types, header and details. The header has 21 string fields, the details contains 14 fields. What I was thinking about doing was reading the files, using a stream reader object, then pass the line that is read to either a xmlserializer for headers or details, based on the line count. I have the line couter and the stream reader working, just needing the parser put together. Thanks in adva ...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 was looking to get the original xbox extender working. Have not go round to purchasing a 360 - I will need permission sanctioned from she who must be obeyed ...Show All

• Windows Forms UserControl as Container

  Hi all, Just a quick question and I am sure there is a simple solution but I just haven't found it yet. I know how to make my UserControl a container by using ParentControlDesigner etc. This works fine and I can drag and drop Windows Forms Controls at design time. However, if I add a Panel to my UserControl Class, compile it and then try to drag and drop another control on the Panel, the Panel does not act as a container. So my question is: If I have a UserControl which consist of a single Panel, which is a pretty lame control I know, how can you get the Panel to act as a container at design time Any help in this would be greatly appreciated. Kind Regards AM PS. The UserControl that I have written does not consist of a ...Show All

• SQL Server How to populate a junk dimension?

  Is there any best practise to populate a junk dimension Should I just create the table and fill-in all the stuff using some SQL I believe most records in the junk dimension are static. If you have a junk dimension key it is possible to put this information in a separate dimension table. Regards Thomas Ivarsson ...Show All

• SQL Server Unable to connect to sql server 2005 express edition

  Hi, I have installed SQL Server 2005 express edition on Windows 2003 Server, but i am unable to make a connection using sqlcmd -S <servname\instancename> -U <loginID> -P <pwd> -d <dbname> but i am able to make the connection using sqlcmd -S <servname\instancename>,<portnumber> -U <loginID> -P <pwd> -d <dbname> What could be the possible reason for this and how can i configure sql server 2005 express edition to make connections without specifying any portnumber in the connection string. Both the sqlserver database service and browser services are running. Regards Salil I have narrow down the problem and came to the conclusion th ...Show All

• Windows Forms Deleting Last Row of DGV causes nullreferenceexception

  I had a problem that I am curious if anyone has heard of.  I've searched the knowledgebases and forums but can find no information on it.  I'll post it here so that if anyone else encounters it they will have a resource to turn to. I have a databound dataGridView control bound to a database.  I can perform all the normal functions on the data and reflect those changes back into underlying database just fine, EXCEPT if I attempt to delete the last row displayed above the blank "add-a-new-row-here" row.  If I attempt to do so, I get the UserDeletingRow event just fine, then a nullreferenceexception before the UserDeletedRow event is fired.  It appears from the call stack that the exception is occurring in the meth ...Show All

• Visual Basic Dynamic Control Size as Form Size Changes

  I have a windows app in VS 2005 ... the main form has three panels (two skinny ones across the top and the third down the left side) and a webbrowser control that occupies the lion's share of the form in the lower right. Is it possible to set things up so that if the user changes the size of the form (by either hitting the Maximize button or dragging the lower right hand corner) to automatically have the web browser control and the left hand panel (which extends to the bottom of the form) get larger or smaller too As it is now, if, say, the form is made larger the added space is just empty space. Thanks. Yes, Look at the dock and anchor properties of the controls.  Anchor is probably more likely ...Show All

• Visual C# How to use c # to write shrinking algorithm?

  Algorithm use c # language is described shrinking Can write the code example thanks ----------------------------------------------------------- --This is group of data ,Judge next number through these datas What method have ----------------------------------------- 1: 019 　 2: 484 　 3: 733 　 4: 313 　 5: 736 　 6: 255 　 7: 459 　 8: 558 　 9: 504 　 10: 735 　 11: 193 　 12: 035 13: 550 　 14: 814 15: 916 16: ...Show All

• Visual Basic know the caller function name?

  Is there a way from inside a function know the name of the function that called it Sub main() p() End Sub Sub p() Dim s As New Diagnostics.StackTrace Dim f As Diagnostics.StackFrame = s.GetFrame(0) --> p Debug.WriteLine(f.GetMethod.Name) f = s.GetFrame(1) Debug.WriteLine(f.GetMethod.Name) --> main q() End Sub Sub q() Dim s As New Diagnostics.StackTrace Dim f As Diagnostics.StackFrame = s.GetFrame(0) --> q Debug.WriteLine(f.GetMethod.Name) f = s.GetFrame(1) Debug.WriteLine(f.GetMethod.Name) --> p f = s.GetFrame(2) Debug.WriteLine(f.GetMethod.Name) --> main End Sub ...Show All

• Visual Studio HiearchyNodes auto-expanding on load of custom project

  Hello, We have a custom project that we load up into the Visual Studio Solution explorer. On some of our development machines, when we open up an existing project (our custom one) it makes some of the HiearchyNodes (folders,files) that have children auto expand to show all the items. On other development machines, it remembers which folders were open. Other projects like C# ones don't have this same auto expanded problem on the affected machines. Our first thought was that any time you do an AddChild to a HiearchyNode it would expand the item, but on some of our custom HiearchyNodes this doesn't happen. Any input or help from someone who could shed some light on the issue would be greatly appreciated ...Show All

• Visual Basic SPEED UP application running

  Hi All, I'd like to speed up my application, I know I can (I have to) manage the code again... but does someone tell me if there's some optimization I can do tools, VB.NET funcionality and so on... TIA for any suggestion about. Dario Well here are some tips:   only use variables you need to use. Take advantage of the .NET Framework, if there is a class in there that does what you need for it to do, use it - dont use another way, such as PInvoke unless you really have to Make sure you are opening/closing connections (Database for example) only when you are going to be using them Make sure that you are not duplicating code all over the place, instead make a method/fun ...Show All

• SQL Server Showing different counts for the same dimension?

  Hello, For the life of me I can't figure out the best way to do this. I have 2 fact tables, hosehold and account where several accounts roll into 1 household. Each fact table has several dimensions attached to it on of which is the "core" dimension. The "core" dimension indicates if a household or account is "core" based on several business rules. I need to be able to show counts of "core" households and ALL of their associated accounts and also "core" households and their associated "core" accounts ONLY. What's the best way to set this up THANKS! Thanks again for all your help! I set things up the way you indicated and I'm closer, ...Show All