Lalicia Bickerton's Q&A profile

• Windows Forms Cursor not visible after DroppedDown property is set to true

  Hi,      I have a dropdown control with few list item in it. I am setting the DroppedDown property to true in the textchanged event to show the dropdown, the problem is the mouse coursor (the pointer) is not visible after the dropdown is shown, its stuck inside the dropdown and only when the focus comes out of the control I am able to see the Mouse pointer again. Am i missing something. Regards Deepak This problem is reported in Product Feedback ; it is a side-effect of the Windows "Hide cursor while typing" option, set in Control Panel + Mouse. I tried fixing it by calling the ShowCursor() API function but that didn't work. Triggering the dropdown with a timer ...Show All

• Visual C# define a property which accepts a parameter

  Hello! What's the C# syntax to define a property which accepts parameters. The VB syntax whould be: Public ReadOnly Property Item(ByVal index As Integer) As Object Get Return CType(Me.List.Item(index), MemberDataValidationError) End Get End Property thanks, I know c# has string arrays and collections but I want a property - I want to write my own logic when a set operation is performed and again, I know I can use a set method but I want propertty mainly for COM interop, so the type library will use this feature and be similiar to an old type library I have ...Show All

• Windows Forms FillBy doesn't populate BindingSource for relations

  I have an application which heavily uses relations and bindingsources. It works great as long as I fill all the tables with the tableadapter fill method. However, if I use a FillBy query to reduce the records returned, none of the bindingsources based on relations show any records. I have verified that all the tables are populated. In this case I have Fill by client ID methods for each tableadapter. All the tables get filled and all are related on clientid. Is this simply not supported Must I use the Fill method to use relational bindingsources Thanks for any help in advance. Mike Wang, The commented lines are using the FillBy queries and though they pull related data into the tables and ...Show All

• Internet Explorer Development IE7 Crashes when closing streaming video window

  I am running Windows XP Home and Windows XP Pro at home. All boxes are up-to-date with Microsoft patches. My boxes were very stable until I installed IE7. Now when I am watching streaming video from a news source or a trailer from a movie source and I finish and close the streaming window, I get the Microsoft error window that wants to send the error data to Microsoft. If I send or don't send the data, all IE7 windows are closed. I have backed out IE7 on one of my boxes (by using Microsoft Restore Points) and I get my stable IE6 environment. I want to upgrade to IE7, but I can't have the browser die so easily. I have a pretty standard load of software on the boxes. I do have Microsoft OneCare Live installed also. Can anyone help me Tom ...Show All

• Visual Studio Tools for Office How to copy part of Excel to another Excel using C#

  I am new to Excel programming using C#. Can someone help me to copy only part of excel sheet to another excel and this has to be run nightly and the data in destination excel can be deleted and updated. Thanks Hi Ankola this forum is specifically for questions about using VSTO technology. The best place to get a discussion about how to do what you need would be the office.developer.automation newsgroup; Excel object-model-specific questions are best directed to the Excel.programming newsgroup. http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en& ...Show All

• Visual C# Release mode in VS2005

  Hi I have notice that when I run my project from the IDE in Release mode the debugger still stops on the breakpoints. What is happening here This behavior is different to VS2003. I want to run my app without disabling the breakpoints thanks kenny You can turn this off by going to your project properties in visual studio Go to the build tab make sure Define Debug is not checked go to advanced and select none in the debug combo. Your app is still built in release mode but all debugging information supplied also. so that you can debug when the release mode acts differently to the debug. ...Show All

• Visual Studio Express Editions Problem connecting to access db

  Public Sub OpenDB() Dim dbFilename As String = Application.StartupPath & "\database.inf" If My.Computer.FileSystem.FileExists(dbFilename) = True Then Dim objReader As New System.IO.StreamReader(dbFilename) Dim dbLocation As String = objReader.ReadToEnd If My.Computer.FileSystem.FileExists(dbLocation) = True Then Try dbPath = "Provider=Microsoft.Jet.OLEDB.4.0;Password=TAPis;User ID=Admin;Data Source=" & dbLocation & ";" DBCon.ConnectionString = dbPath DBCon.Open() Catch ex As OleDb.OleDbException MsgBox(ex.Message, MsgBoxStyle.Critical, "Error") End End Try Else MsgBox("Th ...Show All

• Visual Studio Team System source control

  does visual studio team system for database professionals incude source control if yes, is the source control at the database level meaning if someone goes into Management Studio will they "see" that a stored procedure is currently checked-out and then they cannot modify that sp.   bfarr23 wrote: there needs to be something to prevent a dev or dba from going to SSMS. Until then there exists a hole in the source control process in VSTS for database code.      Is this not an issue about proper procedures being put in place to ensure this doesn't happen Tools are all well and good but they have to be used properly. That would be the ...Show All

• Visual Basic PrintDialog form pre-sizing in VB 2005

  How can I pre-set the PrintDialog1 form size before I call it I want to set it at say 80% or the screen height (to be easily readable) rather than the normal appearance which in some circumstances is too-small and always has to be dragged bigger, but I can't find any reference to how to set the dialog form size. Is this possible Thanks, Nick B Me again ..... idiot, I didn't read what I wrote. I meant the PrintPreviewDialog of course ... ! A good-sized readable dialog is required, just how do I ... Nick B ...Show All

• Visual Basic firing numericupdown event from another function

    and also knowing once it is fired whether it is an up click or a down click OtherFunction() UpDown1_DownClick(UpDown1, New System.EventArgs())  Dim iUpDownValue As Integer Dim iPrevUpDownValue As Integer = 0 Private Sub UpDown1_ValueChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UpDown1.ValueChanged            iUpDownValue = UpDown1.Value            If iUpDownValue > iPrevUpDownValue Then 'Upclick                  Else 'Downclick   &nbs ...Show All

• .NET Development XmlDeserialization string into bool

  I created my C# class file from xsd.exe I have an xml file which I Have deserialized successfully. Now in the xml file I want's some nodes to be of boolean type.Same in the class file. My xml file is < xml version = " 1.0 " encoding = " utf-8 " > < Exporters > < Exporter > < ExporterName > FirstExporter </ ExporterName > < TransformationFileName > FirstExporter.xsl </ TransformationFileName > < IsEnabled > True </ IsEnabled > <!-- True || False --> < IsTransFormtionNeeded > True </ IsTransFormtionNeeded > <!-- True || False --> < CopyToFtpNetWorkLocal > F </ CopyToFtpNetWorkLocal > <!-- F f ...Show All

• SQL Server Is there a script to delete all database constraints?

  Hi all, I am trying to delete all of my table constraints and I generated this script: declare @table_name sysname declare @alter_table_statement varchar(256) declare @const_id integer declare @prt_obj integer declare @const_name varchar(256) declare @parent_name varchar(256) -- definindo o cursor... declare constraint_id cursor local fast_forward for select id from sysobjects where XTYPE='PK' OR XTYPE='F' order by parent_obj declare parent_obj cursor local fast_forward for SELECT PARENT_OBJ FROM SYSOBJECTS WHERE XTYPE='PK' OR XTYPE='F' order by parent_obj -- definindo o cursor... -- apagando as constraints... open constraint_id open parent_obj fetch next from parent_obj into @p ...Show All

• Visual C++ Errors, Help!!!

  When I try to include string like: #include <string> I always got following errors: E:\MicrosoftVisualStudio8\VC\include\cstdio(37) : error C2039: 'Unsafe_sprintf' : is not a member of '`global namespace'' E:\MicrosoftVisualStudio8\VC\include\cstdio(37) : error C2873: 'Unsafe_sprintf' : symbol cannot be used in a using-declaration E:\MicrosoftVisualStudio8\VC\include\cstring(20) : error C2039: 'Unsafe_strcat' : is not a member of '`global namespace'' E:\MicrosoftVisualStudio8\VC\include\cstring(20) : error C2873: 'Unsafe_strcat' : symbol cannot be used in a using-declaration E:\MicrosoftVisualStudio8\VC\include\cstring(21) : error C2039: 'Unsafe_strcpy' : is not a member of '`global namespace'' E:\MicrosoftVisualStudio8\VC\i ...Show All

• .NET Development Databinding to a datagrid

  Hello I have a datagrid for which i want to bind to just some of the columns returned from a sqlceresultset the code is: bindingsource1.DataSource = resultset1; datagrid1.DataBindings.Add( "Text" ,bindingsource1, "Product" ); I would think that these two lines made the datagrid show the "Product" column in the "resultset1", but the datagrid is totally empty. When i use "datagrid1.DataSource = resultset1:" it shows all the columns as expected though. What am I doing wrong If this is not possible, then how would I do it I'd rather not use datasets or datatables, because speed is very important. Those two lines of code are cancelling each other out. The problem i ...Show All

• SQL Server Parsing CSV name=value pairs into columns

  Hello smart SQL people, I have a field in the DB that contains name value pairs in the form of csv. Is there a neat trick (using a stored proc) to get it to be diplayed as in columns (maybe create a view around it or somthing ) EX. Select 'name1=val1;name2=val2;name3=val3' as MyData --> Returns MyData ----------- name1=val1;name2=val2;name3=val3 ============================================ How can i get it to return name1 name2 name3 -------------------------------- val1 val2 val3 You should really normalize your tables so that you can do simple and efficient operations. You can split the string using various techniques. The link below discusses lot of those: http: ...Show All