Alex Yakhnin - MSFT's Q&A profile

• Windows Forms datgridview and combo

  hi i have and datagridview to which im connecting a table thru code. one of the columns of the datagridview is combobox and i want to display one field of another table to the combobox on form load. hw can i do it DA1.SelectCommand = New OdbcCommand( "Select code from Company" , con) DA1.Fill(ds1, "Company" ) ds1.Tables("Company").Rows(0).Item(0) is what i want as data to that combocolum plz help You might try the following 1) Create a class say Customer. You want to capture all the credit cards the customer class has which you get from someother database table. Let this property in the customer class be Creditcards of type String []; 2) Create a binding List Object. populat ...Show All

• SQL Server Modifying Existing Table Schemas?

  By default, I constructed my database using the dbo Schema. I have since created new Schemas, and want to change some of the tables from dbo. Is there a way to change the existing schema of a table without disrupting the data that is inside the table For example: Current: dbo.Products Desired Change: NewSchemaName.Products Thanks. ...Show All

• Visual Studio Express Editions TableAdapter.Update does not save data

  How can I save data entered in a dataset via the UI I tried the code suggested in the "VB Guided Tour", Private Sub Form1_FormClosing( ByVal sender As Object , ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me .FormClosing Me .AddressesBindingSource.EndEdit() Me .AddressesTableAdapter.Update( Me .SQLdbDataSet.Addresses) End Sub but all changes are lost when I restart the application. Thanks. Hi all ! Man, forget all !!! If u using a bindindsource, verify your's components databindings. If they connected direct from dataset the updates not work. Bind using bindingsource object and done! Sorry my english!!! I hope helpful. ...Show All

• SQL Server Invoking a service on firing a trigger

  Hi Im trying to invoke a .Net service when a trigger is fired on a table in SQL Server 2000. The service is working fine but I need to invoke it when the trigger is fired. How can I achieve this Hi! At first, why do you think your problem is concern with SQL-NS The second: does you question relate to SQL Server 2005 You have wrote, that the trigger on SQL Server 2000 invokes the service and the services works well. Then, what do you mean by saying "invokes" Does the trigger start the service or it just send a message to him ...Show All

• Visual C++ msvcr80.dll Problem

  Hi there, can someone possibly tell me why Noton WinDoctor is telling me that 10 executables in the .NET Framework 2.0 cannot access the necessary dll file msvcr80.dll I see that the dll exists in the WinSxS directory and I'm running XP pro. I didn't have this problem until I downloaded the 2.0 framework at windows update. Any advice appreciated. Thanks. Naolin I am having the same problem... I even uninstalled it.. and it didnt show a problem then I reinstalled the update and it showed up as a problem in the Windoctor again... any ideas as to what is wrong with this update Im sure its a simple fix but I cant seem to get it.. ...Show All

• Visual C++ c:\WINDDK\3790.1830\inc\wxp\winbase.h(294) : error C2146: syntax error : missing ';' before identifier 'CRITICAL_SECTION'

  Hi, I am using VC++ (MSDE 2003 Version 7.1.3088) to compile my driver simulator code, but I am getting following errors in winbase.h file, can some one please help Regards, Pranav c:\WINDDK\3790.1830\inc\wxp\winbase.h(294) : error C2146: syntax error : missing ';' before identifier 'CRITICAL_SECTION' c:\WINDDK\3790.1830\inc\wxp\winbase.h(294) : error C2501: 'CRITICAL_SECTION' : missing storage-class or type specifiers c:\WINDDK\3790.1830\inc\wxp\winbase.h(295) : error C2146: syntax error : missing ';' before identifier 'PCRITICAL_SECTION' c:\WINDDK\3790.1830\inc\wxp\winbase.h(295) : error C2501: 'PCRITICAL_SECTION' : missing storage-class or type specifiers c:\WINDDK\3790.1830\inc\wxp\winbase.h(298) : error C2146: ...Show All

• SQL Server BIT-Wise Aggregation

  Hi, I have the following three tables : Account (Id int, AccountName nvarchar(25)) Role (id int, Rights int) AccountRole (AccountID, RoleID) In Role table - Rights Column is a bit map where in each bit would refer to access to a method. One account can be associated with multiple roles - AccountRole table is used for representing the N:N relation. I want to develop a store procedure - which would return all AccountName and their Consolidated Rights. Basically I want to do a BitWise OR operation for all the Rights in the Aggregation instead of the SUM as shown in the following statement. SELECT Account . Name , SUM ( Role . Rights ) FROM Account WITH ( NOLOCK ) JOIN RoleAccount ON RoleAccount . AccountID = Account ...Show All

• .NET Development Request clarification of simple code mechanics in GZipStream

  I copied the following code segment out of an instructional manual but how it is working is slightly unclear, could someone explain 1 static void Main( string [] args) 2 { 3 FileStream sourceFile = File .OpenRead( @"C:\boot.ini" ); 4 FileStream destFile = File .Create( @"C:\boot.bak.gz" ); 5 GZipStream compStream = new GZipStream (destFile, CompressionMode .Compress); 6 int theByte = sourceFile.ReadByte(); 7 while (theByte != -1) 8 { 9 compStream.WriteByte(( byte )theByte); 10 theByte = sourceFile.ReadByte(); 11 } the three streams (2 fileStreams 'sourceFile' 'destFile' ) and a compression stream (GZipStream). Information is pulled one byte at a tim ...Show All

• Visual Studio Express Editions Problem installing VB.NET 2005 express.

  Whenever I try to install VB.NET 2005 Express Edition on my machine, setup displays following error: Error 1304: Error writing to file: Microsoft.VSDsesigner.dll. Verify that you have access to that directory. I am using Windows XP with SP2 and it is installed on NTFS partition. K.Rohit, 1. I am using Windows XP with SP2 and install my VB Express Edition on NTFS partition, too. I've got no problem during the process of installing. So I am sure there is no mistake or bug in Visual Basic Express Edition setup file. 2. Please make sure you have installed the .NET Framework 2.0 before the VB Express installation. Then please make sure there are no program related applications using the Microsoft.VSDesigner.dll are open during your ...Show All

• SQL Server My sqlcache doesn't work consistently under ASP.NET 2.0, any suggestion?

  I have some problem with ASP.NET cache, I found other people has similar problem, but I didn't find real solution. The one bother me most is the SQLCacheDependency doesn't work stable. I insert object in cache and has SQLCacheDependency linked. After a period of time, it stopped working. That means the the object is still in cache, but change on db side doesn't remove the cache entry. I am not sure if it is ASP side or SQL side, I feel it is ASP side. I am using 2.0 + SQL 2005. Once the db command notification stop working, you have to restart IIS or clear all items in cache since you don't kno which one is changed. The following is the code I use to handle the cache : string cacheKey = LinkSites.GetMappedKey(virtualPath, fi ...Show All

• Software Development for Windows Vista How do you pass data from an html web form back to the custom form activity (to the XOML only state workflow)?

  Matt/All WF Gurus,   We are creating a custom Form activity that will load a web html form and retrieve results back into the XOML only state workflow.  We can program the form loading in the browser from a custom activity, but are not sure how to retrieve the data from the form directly into the state workflow so that the workflow can persist this data and continue working with this data (from the form).   How can you pass data back from a web form directly into a running workflow during an idle state (XOML only state workflow using WF 3.0)   Any suggestions     Sincerely, John Portnov John, I'd start by modeling the communication using an object or coll ...Show All

• Visual Studio Express Editions update data to database

  I have Form1 with serial number and item number and part number( 3 comboboxes), when I enter those items and click ok ( Dim myform As New form2) 2nd line (myform.show() )it then brings me form2 with the parts I want to add to the database such as cpu motherboard and so on. How do I connect form1 and form2 to update after I'm done with form2 Sorry but I'm really a newb just started 2 weeks ago. Got to start somewhere!!! I hope this makes some sense. Thnx David ok, update what the database well you need to insert data into the database as you like. Take a look at this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=753872&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=927324&SiteID=1 http:/ ...Show All

• Visual Studio Team System outside changes to solution don't make it into tfs

  OK We use an orm to create a data layer for our apps. This orm generates classes and modifies the project file from it's own ide. After a change, the vs.net ide says "hey you changed the project file, do you want to reload". I hit yes, and any new classes it generates are in my project now. The problem is that the new files don't make it into tfs like they used to with vss. Is there some way I can fix this Right now I have to remember to remove the new files with exclude from project and readd them back which is a royal pain. Even a right mouse click that had a add to tfs would be ok. Thanks. Note that the powertoy should work here. It should pend adds on the new files and edits on any ...Show All

• Visual FoxPro program starting problem, grid problem

  Hi I have several beginner questions for VFP 8.0 1) Where should I put the READ EVENTS method so the main form will show itself instead of showing the fox pro main window 2) When executing SQL simple select statement for filling a grid, it fills the grid inside the form, but firstly it shows the result in a grid outside the main form. How to show result only in the grid placed on the form Ok finally i understand all and it works :D Thx to everyone :):) But now i have another problem, make this grid with cursor : SELECT * FROM tasks INTO CURSOR mycursor NOFILTER READWRITE ORDER BY name Datasession = 2 && this is in load event in form In activate cell in grid i put this: LPARAMETERS ...Show All

• Software Development for Windows Vista Versioning in workflows

  I'm writing a web service that hosts the WF runtime and the idea is that people can write their own WF assemblies that are then picked up by the web service and made available to the outside world. This all seems to be working OK apart from the problem with versioning that has been mentioned elsewhere on these forums. I guess I can probably deal with keeping several different versions of the same assembly around based on what versions are still in use. But what I'd like to know is if there is a way to deal with in-progress workflows that can't find their relevant WF assembly, since the chances are this will happen at some time I'd like to be able to terminate them but I'm unable to get hold of a WorkflowInstance so can't terminate them tha ...Show All