qzrlsd's Q&A profile

• Visual Studio Express Editions BindingManagerBase Position_Changed Problem

  Hey Everyone, I have a program that has several textboxes bound to 1 dataset which contains only one table. When the form loads, the data is displayed in the textboxes allowing the user to add, edit, delete, etc., as well as navigate through previously entered records. However, when trying to navigate through the records, it doesn't do anything. The recordCountLabel, which keeps track of the record number that is displayed, changes, but the first record stays on the screen. Here is a little of my code. Protected Enum Record RecordNum DDate Shift ATO Vehicle End Enum Private Sub Form_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load 'Loads data into the 'TripSheetI ...Show All

• Visual Studio 2008 (Pre-release) Catch property changed event in xaml

  hi, i'm creating a custom button control which inherits from System.Windows.Control.Button and implements the INotifyPropertyChanged interface. How can i catch the event in my XAML when a property of the custom changes Can i do this with a EventTrigger within my style in the XAML File Furthermore i want to the change the style of my control in XAML, depending on the value of the property Any ideas Thanks a ton, bkohler Actually, it depends on which operation you gonna make based on the property change event, if you just wanna change the look and feel of your custom control, then triggers is the best solution, if you wanna take some actual behind-the-scene work for instance updating ...Show All

• Windows Forms Mouse scroll event

  Hi I need to stop the mouse scroll event in a combo box in a form because for each selected index change i need to send a request to a web service which would become costly if the user scrolls as it would send n number of requests to the service. Please let me know the event which is fired when the mouse is scrolled. Thanks and Regards, Karthick. Try subclassing the combo box:     public class NoScrollComboBox : ComboBox     {         protected override void WndProc(ref Message m)         {             const int WM_MOUSEWHEEL = 0x20A;   & ...Show All

• SQL Server SSIS - Connection String Issue

  Hi I have been trying to resolve a connection string issue all day, and havent figured out whats the problem. I keep getting the Acquire Connection error everytime I run my package. Can you someone review the format of my connection string, and confirm that it is indeed the correct format: I have two conn strings specified in my config file, one is to connect to a remote database and one is for local. I have validated the connectivity from my server to these databases via Management Studio, and it seems to connect fine. But when I run my package it keeps failing. SQL Server Authentication(Remote Database Server): Data Source=server_name;Username=useraccount;Password=xxxxx;Initial Catalog=dbname;Provider=SQLNCLI.1; Window ...Show All

• SQL Server Create a custom login.

  Hi all, I need an user to do the following tasks. What kind of login I could provide him and how do I give him rights to do them without providing hin the SA (sysadmin role) Create Login Create Database Create Tables ( with Pks, Fks & Indexes) Create Stored procedures Create Functions ( table valued / scalar valued) Insert Master data Create Jobs Execute Job for first time Populate sample Thanks in advance, DBAnalyst Refer to books online about database fixed roles for the steps you have asked such as: 1) db_accessadmin 2,3,4,5,6 & 7) db_owner ...Show All

• SQL Server Report from prcedure that return multiple recordsets

  Hi there, I am creating a report from a stored procedure that returns multiples record sets. For an example, my stored procedure is as follows CREATE PROCEDURE MYPROCEDURE AS BEGIN SELECT * FROM TABLE1 SELECT * FROM TABLE2 SELECT * FROM TABLE3 END Now lets say I want to create a report that will display the result of the query no 2 (which is SELECT * FROM TABLE2 in this example). How can I do this Is there any way to bind the second record set to the report dataset with out changing the stored procedure I will appreciate any kind of suggestions on this Thanks Moim Can you mark this one as answered so others can see that multiple recordsets aren't s ...Show All

• Visual Studio Influence Destination of Copy Local

  Is it possible to influence the directory that referenced assemblies are copied to during the build process (for references that are flagged as Copy Local) I want to put them into a lib subdirectory rather than them sitting side-by-side with my assemblies. William, I am unaware of any way to change where the IDE places refrenced files. In my company, we have created a local "reference" drive that each dll (and all other output such as pdb and xml files) is copied to after compilation. This is done through an xcopy in the post-build step. We then have additional MSBuild code in our project files that generates a list of folders in our "reference" directory and adds it to the reference ...Show All

• Community Chat object spaces???

  can anyone tell about object spaces object spaces is object mapping realtionship technology.... a new technology coming in .net3 hopefully with full class libraries and support and wid great features and durability. in fact by this we can make direct relationship between Class properties and Tables fields using XML configuration files (mainly 3 files) http://www.microsoft.com/belux/msdn/nl/community/columns/jtielens/objectspaces.mspx for more and authentic details visit above URL ...Show All

• Visual Studio Express Editions How to use MySQL VB.NET

  How to create database connection in VB.NET to connect to a MySQL Server. Can anyone help me to establish a connection using system objects, or using a shared resource. First step is to have a provider...there are a couple of freebies(SevenObjects) out there on the net...second is to have the proper connection string for that provider: http://www.connectionstrings.com/ carrier=mysql ...Show All

• SQL Server Colors in legend does not match bar graph

  Hi I have a bar graph with custom colors applied to it. The custom colors displays nicely in the bar graph, but not in the legend. The legend displays a mix of some of the "correct" custom colors, and some of the "wrong" standard colors. The colors in the legend vary, depending on the parameters passed to the report. Sometimes legend colors are all right, other times all wrong but must times a mix of right and wrongs. The value for the custom color of the graph is retrieved from a field in the dataset. However I doubt that this is the cause of the error because, the bar graph colors are correct at all times, and I have validated thet correct color names are actually in the dataset. Hope someone can help me out with this one. ...Show All

• SQL Server Upgrade to SQLSERVER 2000 - Which MDAC version on Windows NT 4.0 workstation

  Hi, We are upgrading our SQL Server 6.5 to SQL Server 2000. Currently on 6.5 we are using MDAC 2.1 and SP 1, can anyone suggest the suitable version for the following client /server configuration. Server: SQL Server 2000 on Windows 2003 standard edition. Client desktops: Windows NT 4.0   thanks in advance, venkat.           ...Show All

• Visual Studio Team System Please do not RTM yet!!!

  My biggest frustration when using VSTS for Database Professionals is that you still have to select one item at a time to skip if you don't want to migrate all changes. For instance, the "dt_" stored procedures don't do any good in my test or production environment and I have to click each one, one at a time, to skip them when scripting the differences between my local development copy and the test or production environments. A check box for each item, so you could apply a change to all selected rows at once, would sure help. I know you've heard this before. I know there are a lot of other problems that were identified very early on that have not been addressed as well. I guess I am just a little frustrated with the product ...Show All

• Smart Device Development Blocking Popups/Dialogs while receiving a file from Bluetooth

  Hello All, I`m using HTC. Whenever I receive a file from Bluetooth, 2 popups/dialogs come up. One is for the display and another is for permission for request to continue. I want to block these popups/dialogs. Is that possible With Regards, Manjunath. There isn't a direct way to turn off these notifications. One way would be to disabled the built in Obex listener (Settings > Connections > Beam > Receive all incoming beams) and run a custom listener - see ObexListener in http://32feet.net for example. Peter ...Show All

• SQL Server Storing & Retrieval Of Encrypted Username and Password Hashes

  Can somebody pls guide me on how i can Store & Retrieve Encrypted Username and Password Hashes. I want to know following :- 1. I'm doing all the encryption and calculating password hashes on client side (VB), which i want to store in SQL Database when a new user account is created. I want to know what data types to use in Database. I will prefer not to use strings at all on client side due to secruity issues, i want to do all transfer in bytes -> to and from SQL server. How i can do that 2. How the connections can be made encrypted or more secure when doing these communcations. 3. I want to know if this is the right approach or to use the built in features of SQL Server 2005, main reason for not using that is that not al ...Show All

• Visual Studio Tools for Office Word 2007 Interop problem

  Hi, I've upgraded to Office 2007 from Office 2003 and am having some trouble getting some software I made that uses the Word Interop to do search and replace working. I changed the reference to the new Interop assembly I got from the Primary Interop Assemblies . I tried converting my template documents to Office 2007 format, but that didn't seem to help. Everything else seems to be OK but I get an error at sel.Find.Text... Dim sel As Selection = app.Selection For Each objRep As ReplaceWord In DirectCast(arrReplaceWords.ToArray(GetType(ReplaceWord)), ReplaceWord()) sel.Find.ClearFormatting() sel.Find.Text = objRep.OldValue sel.Find.Replacement.ClearFormatting() The error I get is... Sys ...Show All