pauldr's Q&A profile

• SQL Server Clustered and Non-clustered indexes

  hi, how clustered indexes and non-clustered indexes been saved in memory non-clustered is a table of a references to the actual table and what about clustered indexes thanks. Indexes have nothing to do with memory. A simple way to explain indexes is just as an index in a book. You have the non-clustered index telling you on what page you can find specific information. The clustered index defines the order in which they are stored, eg. name in a phonebook could be seen as a 'clustered' index because the phone numbers are listed in alphabetic order by name. I tried to give a very simple expl ...Show All

• .NET Development problem using subnet mask 255.255.0.0 and .NET sockets

  Hi, I have two computers connected to a network switch. Both use static addresses. Computer 1 uses:  192.168.1.80,  subnet mask 255.255.0.0,  Windows XP Computer 2 uses:  192.168.2.79,  subnet mask 255.255.0.0,  Windows CE 5.0 .NET Ping works fine is both directions. I can also connect to the CE box using remote tools like Performance Monitor, Process viewer, etc, using cemgrc. No problem there. I want to establish a TCP socket connection between those computers using .NET sockets but I always get the exception "Socket encountered a dead network" on the Connect() method. Everything works fine if the two com ...Show All

• Visual Studio Fatal error by opening a EAP file

  When I open a file with "eap" extension, I receive the following error: Fatal error: "The Microsoft Jet database engine cannot open the file \\itsrv\Proyectos\temp\sst1B.EAP . It is already opened exclusively by another user, or you need permission to view its data". When I try it from another computer, the file is opened but with some strange character beginning by Standard Jet DB". It doesn't matter if Enterprise Architect is installed or not, I get the same error. Is it possible to configure VSS in order to recognize these types of files ( I tried to add the eap extensio ...Show All

• SQL Server Filling up ListControl from a SQL query

  Hello, I use MFC ListControl. Is there any way to fill it up using SQL query without adding one row at a time All I could find was m_List.InsertItem(...) and m_List.SteItemText(...) Are there any other ways Thanks One possible way to do this is using virtual listctrl: Fill(insert) the list items with bound data addresses first, then do SQL fetch for the result. ...Show All

• Visual C# Do you know what's the different between "equals" and "=="

  Hi, Do you know what's the different between "equals" and "==" No, you *can* use == on string variables, as System.String overrides == operator (note that both sides must be string variables, otherwise System.Object's == operator is called, which does a reference comparison)   string s1="Test"; string s2="Tes"; s2+="t"; /*prevent string interning*/ Console.WriteLine((s1==s2)) //prints True   ...Show All

• Windows Forms What is a ComboBox Items Data Type?

  Hi all, I need to set a property on Form to return a SelectedItem of a ComboBox on that Form but don't know exactly what Data Type it is. I currently have the following property... public object m_StatusFilter { get { return cmbSnagFiltersStatus.SelectedItem; } } But on the Form that calls this, I don't know what DataType to cast this returned property to so that I can get additional values on the ComboBox's selected item Hope you can help. Thanks Tryst your cast depends on the data type of the value you set for the comboBox's ValueMember property (if you used data binding) but if you used the Items collection when p ...Show All

• Windows Forms Form freezes on new thread

  Im having a little difficulty Show()ing a new form on a thread separate from the one called by application.run(). Here's basically what im trying to do: I have my main UI thread, and i have a server runing on a separate thead in the background. Everytime my server accepts a new connection, I want to open up a window for that client. When i make the new form and use the Show() method on my server thread, the form opens but it doesnt draw anything in the box, and in the title it says "not responding". I tried using invoke, but i get the same problem. When I use Application.Run(new form) in my thread, the window opens corr ...Show All

• Smart Device Development smart phones

  Hello people.. i have bought the audiovix 5600, and i'm not able to know how to downloud an application on it to make it read other languages instead of English... for example i'm reacieving an ARABIC text msg and i'm not able to view it... What shull i dooo ! ! ! ! does windows mobile support arabic language on this device ! can someone help Please contact whoever you purchased the device from for your options. I'm going to lock this thread as it's off topic ...Show All

• Windows Forms ErrorProvider does not display inside TabControl

  Document Outline Form --flowLayout ----tableLayout ----panelMain ------tabControlMain --------tabPageGrid --------tabPageDetail ------bindingNavigator errorProvider bindingSource dataSet tableAdapter Display of the errorProvider inside the tableLayout always works. Currently the errorProvider for controls inside the tabPageDetail doesn't display at all! (i can't reproduce the situation where it displays at one control inside that...mmmmh) Please help! Thanks Peter after setting a text instead of string.empty the icons appear correctly but blinking is completely unsynchron.... ...Show All

• .NET Development SQL Question??

  I want to set up my button control...so that if my data reader.HasRows then i want it to UPDATE the rows....If my datareader.HasRows is False then i want it to Insert the new information to its new ROW....here is what i came up with any help would be fantastic Private Sub btnSave_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim sqlconn As SqlConnection Dim sqlcmd As SqlCommand Dim uptcmd As SqlCommand Dim dr As SqlDataReader Dim cstring, str As String sqlconn = New SqlConnection(cnConnection) sqlconn.Open() If dr.HasRows = False Th ...Show All

• Visual Basic ADODC Control

  The one sentace version: ADODC refresh doesnt work. So I've got this form designed to edit domain tables and their fields. Each domain table has two fields, ID and Value. Basically the form has a combo box which lists the tables, there's a datagrid which lists the fields and values of the selected table and there's a frame with a two text boxes (id & field) used for editing values. There's a 2-dimentional array, TableList that keeps track of the table names and their associated field names. I have an ADODC control that is set up fine with the Access database. Cursor Location: Use Client Cursor Type: Open Static. As for the ...Show All

• SQL Server Use Partial or No_Cache mode in Lookup task

  Hello, Can anyone explain to me (or show me where to get info) in what scenario should I use Full Cache, Partial, or No_Cache mode in the Lookup task I got below warning message during execute my package. I understand that my lookup data have duplicate reference keys. I want to change the mode to partial or no cache to see how it works, but don't know what to change for the parameter map. Warning : 0x802090E4 at Data Flow Task , Lookup [37] : The Lookup transformation encountered duplicate reference key values when caching reference data . The Lookup transformation found duplicate key values when caching metadata in ...Show All

• Visual C# Accessing Object Properties from called objects.

  I understand that Reflection is a good way to get information about Attributes, Properties and Methods of a class but how do I access values of a specific instance of a class and ensure that it is the class object currently calling the class If I have a heirarchy of: object1.object2.object3.property how do I access a property value in object 1 from object 3 so that this works: public int AProperty { get { return Object3Variable + Object1PropertyValue ; } }   ...Show All

• .NET Development Eqivalent of MethodInfo.GetBaseDefinition for intefaces?

  Hi, MethodInfo. GetBaseDefinition will tell me where a method was inherited from but " If the method is declared on an interface, GetBaseDefinition returns the method." That is, if the method is an implementation of an interface myMethod.GetBaseDefinition == myMethod. i cannot use it to find out which abstract method a method which implements an interface is implementing - is there a recommended way of doing this or will it be a case of using methodInfo.Name to figure it out. cheers, colin OK, posted too soon. i should use Type.GetInterfaceMap() and the INterfaceMapping object it ...Show All

• Visual Studio Team System Could not bind to SCC when load a project

  After a project is added into the SCC(VSTS), it could not bind to SCC when it is loaded next time in VS. Either I click "Workoffline" or "OK" button of the dialog is of no use. I have to unbind it to make the dialog disappear. The proejct is added to the SCC via the command from File|Source Control|Add Selected projects into Source Control... What's wrong with my operation Unfortunately, you are better off adding the solutions to source control as Ben suggests.  This will be better in the next release. Buck ...Show All