Kovalev Maxim's Q&A profile

• Architecture Multi-tiered Application with client Server Architecture

  I want to Develop a Multi-tiered application with Client Server Architecture. I have one server and many clients around 10 to 15 or even more than that. I have one problem. When some master data is inserted by some clients it must be available to all the clients and server application at the same time and if the other clients has already opend the master form then it also immediately updated when another clients inserting record in that master. Can any one give me solution for this problem. How to implement this in .net 2.0 Thanks in advanced Nayan SQLQuery Notification works on SQL Express edition Diego Dagum wrote: Hi Nayan, You'll find several application examples at the MSDN SQL Server Develop ...Show All

• SQL Server Comparing DateTime to UK Format

  sorry folks the other message was on the wrong board! Hello friends, I am trying to return all records between 2 dates. The Date columns are in DateTime format, and i am ignoring the timestamp. The user should be able to input UK Date Format (dd/mm/yyyy) and return the rows. This sql code works fine for American date format, but i get an error: converting from varchar to datetime when i put in a UK format. eg. 22/11/06. Please advise on this problem! many thanks! ALTER PROCEDURE SalaryBetweenDates ( @WeekStart datetime, @WeekEnd datetime ) AS BEGIN SET @WeekStart = (SELECT REPLACE(CONVERT(DATETIME,@WeekStart ,103),' ','-')) SET @WeekEnd = (SELECT REPLACE(CONVERT(DATETIME,@WeekEnd ,103),' ','-')) END BEGIN SELECT s.StaffNo,s.S ...Show All

• Gadgets ActiveX for Sidebar best practices

  I am interested in further exploring the possibilities of using/developing an ActiveX object for use in a Sidebar gadget but havent done anything like this before. What are the best ways of proceeding with this Can i use Visual Studio 2005 to create an ActiveX object i tried using ATL project, i was able to compile it but not to register it I uploaded my entire TestActiveX Visual Studio 2005 solution as a zip here ; I am basically following Bruce’s "Powering Your Gadgets with ActiveX Articles" Part1 and Part2 very carefully, but perhaps I am missing something ...Show All

• SQL Server Visual C++ 2005 (C++/CLI) - Newbie with ADO

  Hi, I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database. For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine... When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratc ...Show All

• Visual Basic conversion from c# to vb.net

  public class FloatToolStrip : ToolStrip { private Form floatForm ; public Form FloatForm { get { return floatForm; } } c# is case sensitive so floatForm and FloatForm are different. vb.net is case insensitive so when the inline compiler sees FloatForm, it says it has already been declared. how do I convert the blue code into vb.net Thank you. -greg As you've seen, the case insensitivity of VB.NET will not like your code when directly converted... instead a common option is to prefix private variables with an '_' or 'm_' like so: Public Class FloatToolStrip Inherits ToolStrip ' Private m_floatForm As Form Public ReadOnly Property FloatForm() As Form Get ...Show All

• Visual Basic Date comparisons

  I have an access database that has a column of dates. As I display these records, I want to compare the date in that field to the current date and if it is less than today, I want to alter a seperate label to indicate that the item on the record is expired. I'm having a problem comparing the date in the db to the current date. the data from my db is being displayed in a text box, txtexpirydate. When I try to get the value of that as val(txtexpirydate.text) I get an error. that's even before trying to compare to anything. can someone please point me in the right direction. thanks tattoo get the date/time object from the database then try to do a TryParse to see if it can be converted to a ...Show All

• SQL Server PIVOT Table

  Can Pivot Table be done in 2000 RDL I need to be able to use this feature of Pivot Table. Pivot tables can quickly be rearranged by dragging and dropping columns to different row, column or summary positions. Thanks If you mean Reporting Services 2000 (*.rdl files) then, as far as I know, you cannot embedd interactive olap functionality into the report. //Johan ...Show All

• Visual Studio Express Editions prank program on my friend :)

  im making a program to pull a joke on my friend and i need a little help. the program's background is a picture of him and whenbuttons are clicked labels appear that say a 'smart' remark and other buttons appear. i am making it so that he has to enter a specific number in a textbox in order for the program's exit button to appear. if anyone can help to lead me in the right direction i would be incredibly grateful. thanks in advance problem: 1.) how to disable the ability for the program to be moved around on the screen. 2.) how to disable shortcuts such as Alt+F4 and double-clicking on the controlmenu .to minimize the mainform when it is maximized. 3.) how to disable Ctrl+Alt+Delete, or at least to change it to an inactive window when open ...Show All

• Visual Studio Team System Preventing files being added as Pending checkins

  When I synchronise my solution with TFS by doing a recursive get latest, TFS will create a pending checkin for any new files that I have. I have a 'projects' folder and these files are created with our web site and are not meant to be put under version control. How do I stop TFS adding these files and directories. My projects folder is located at the root of the website ie Web\Projects. The sync process takes a very long time when there are 1000 files that it is trying to add. Also it cannot be canceled. This is most frustrating and wastes lots of time as VS2005 cannot be used while the Add is in progress. Should I locate the projects folder somewhere else Thanks for that Richard. I am migrating to use the web application project. ...Show All

• Visual Studio 2008 (Pre-release) Static DependencyProperty - State management

  Hello, I've been using DependencyProperty in my code without really understanding it. I guess that proves DP is a good abstraction :-) But now that I think about it, I can't figure out how it works. Check out the sample code. The DP StateProperty is static, that means there is only one of them for all the instances of MyStateControl class. So how does it actually manage State for the different instances I have a feeling it has something to do with DependencyObject, but not sure. public class MyStateControl : ButtonBase { public MyStateControl() : base() { } public Boolean State { get { return (Boolean)this.GetValue(StateProperty); } set { this.SetValue(StateProperty, value); } } public static readonly DependencyPrope ...Show All

• SQL Server Paramters in WITH part of MDX

  Hi, I need a parameter within the WITH part of an MDX Statement in Reporting Services. I tried several types, but all will bring an error. I will do it like: WITH MEMBER [Measures].[Amount] AS STRTOMEMBER(@MyMeasure) SELECT { [Measures].[Amount] } on columns, ...... The @MyMeasures should be a combobox with the values like Name: Sales Volume (kg) Value: [Measures].[Sales Volume KG] Name: Sales Volume (m2) Value: [Measures].[Sales Volume KG] ... and so on. What's my failure Thanks Hans Hi @All, After a lot of testing, I got it to work. The solution is, you have to mask the Parameter with apostrophes like this: WITH MEMBER [Measures].[Amount] AS STRTOMEMBER ( "" + @Sal ...Show All

• Visual Studio Team System ORM diagram

  Hello, Where can I download the Visio 2002 Enterprise Architect Version I am looking to do ORM using fact editor not ORM drawings from a stencil. I do not see this functionality in Visio 2007 . However the old VisioModeler had it. Thanks, Aswin. Hi Aswin, ORM source model (which contains the Fact editor you are interested) only comes with Visual Studio Team Arch SKU. You should be able to install it from your CD or via the MSDN download (provided if you have the subscription). HTH Patrick Developer, Visual Studio Team System. ...Show All

• SQL Server C code to import image to SQL Server 2000

  I know my question is kinda weird but it seems I have to do this way or threre are some better ideas. Could you show me a sample C code to connect to a data server and call a stored procedure to import an image file into SQL Server 2000 I am writing an extended stored procedure in VS 2003 .NET and it seems extended stored procedure can only work with C code. Thanks! YL Iy you are using ODBC, you can try SQLPutData There is some code sample in the following link http://msdn.microsoft.com/library/default.asp url=/library/en-us/odbc/htm/odbcsqlputdata.asp ...Show All

• Visual C# Custom class convertor problems

  Hy, I am trying to design a custom control. Some properties of this control are from a self made object I call "Voltage" witch consist of a float 'volts' and a enum 'soort'. to use this object in my custom control as a property I need to make a VoltageConverter to be able to set the propertys in design time. The problem is that I can not debug the VoltageConverter class since the Visual C# 2005 IDE Stops imidiately if I try to test the control in the Disign view. Is there some trick I can do to be able to debug this class, or is it yust a matter of trying and starting the IDE everytime again To be complete I will paste some code of the voltage class and the voltage converter. may be sombody can see where it go's wrong ...Show All

• Visual C++ Visual Studio Designer problem, "The designer could not be shown for this file..."

  I get this message from a component in a hierarchy of components: "The designer could not be shown for this file because none of the classes within it can be designed." While I edited the component file created by the IDE I did not change any of the data created by the designer which encompasses: " /// <summary> /// Required designer variable. /// </summary> System::ComponentModel::Container^ components; #pragma region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> void InitializeComponent(void) { components = gcnew System::Component ...Show All