Jonathan Stratford's Q&A profile

• SQL Server Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, n ...Show All

• Visual Studio 2008 (Pre-release) WPF Overview for Executives

  An executive at my company expressed interest in WPF to me, but is not quite clear on what it provides over and above other UI platforms. If he knew what it is and can do, it would be easier for him to "sell WPF" to clients (i.e. provide me with the opportunity to work with WPF on the job!). Does anyone know of a good overview with images and/or videos which would help someone in that position gain a high-level appreciation for what WPF is all about I've looked around, but most of the things I've seen get too geeky and stray away from ways to justify including WPF in a new application's technology stack. Sure for experimentation and demos by all means use WPF and have fun - and its great if you have forward thinking bosses ...Show All

• .NET Development Creating DBF IN C# using OLEDB

  is it possible can any one show me the way of doing it thanks for you help. Hi Irene, A lot depends on what kind of DBF you want to create. There are several ODBC drivers and OLE DB data providers you can use to create the DBFs. You can use Jet, the latest FoxPro and Visual FoxPro ODBC driver, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates/odbc, or use The latest FoxPro and Visual FoxPro OLE DB data provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates. Jet will create DBFs in the older Dbase IV format. Over the years, new data features have been added to the Fox DBF structure. These new features are not compatible with Jet and will not open natively in Excel, for e ...Show All

• .NET Development broadcast messages to all connected clients

  Hi, i want to devlop a message server,which can broadcst messages to all connected clients. i have a VB application which is client side,i am updating the sql server 2000 database through webservice,written in .net. whenever a client updates the database.all connected clients should get a pop up message in their machine. how to implement this.. please give a solution........ Thanks & regards jecco That is OK, you can achieve stability in UDP with very less work. The main theme of the question was Broadcasting which is not provided by TCP at all and you have to Loop through all the connected client instances to send the same message to all of them which c ...Show All

• Visual Basic Nooby here again. Handle the keyDown event.

  Eh i cant believe i forgot this lol... How do you make a PictureBox move with Arrow Keys I keep trying this ... But, it doesn,t seem to work :( Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyUp: Picture1.Top = Picture1.Top - 50 Case vbKeyDown: Picture1.Top = Picture1.Top + 50 Case vbKeyLeft: Picture1.Left = Picture1.Left - 50 Case vbKeyRight: Picture1.Left = Picture1.Left + 50 End Select End Sub Thank you, Moveit Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown Select Case e.KeyCode Case Keys.Up Picture1.Top = Picture1.Top - 50 Case Keys.Down Picture1.Top ...Show All

• Visual Studio 2008 (Pre-release) Using Styles in WPF

  Hi I using a Tabcontrol and binding the items dynamically to a List of strings. I have written two different Styles in my Application Resource, Is it possible for me to use the first Style for the first two TabItem in the control and the Second style for the rest of the tabs that are created in the control. hi Iam tring to directly bind the "ItemSource" property of the Tabcontrol to a list of String so how to set the style's of the items...... Could you help me out with a code snippet Regards Ragu ...Show All

• Windows Forms How to color specific rows in DataGrid (.NET framework 1.1)

  Hello! I am still using .NET framework 1.1 and Visual Studio 2003 and I have DataGrid object binded to a DataTable. Everything is fine, the problem is that I would like to color just specific rows (fonts) (depends on some field in DataTable if the row will have different color or not) in DataGrid. I could not find any way to do this. I found out that it is possible to color rows (fonts) in Paint event of DataGrid. Is there any way to color just specific rows in DataGrid Thanx for any advice, Ziga You would have to create a custom column style to do this. Maybe this sample in the windows forms faq will help. ...Show All

• SQL Server Sum 5 minute data by hour

  I have a table that data gets stored in every 5 mins in intervals marked as 5,10,15,20...2350,2355,2400,5,10, etc. based on the current time rounded to the nearest 5 min interval. Now, with this data, I'm trying to make a query that can be ran to show the sum or average of the 5 min data for every hour interval. So, 100 would sum intervals 5-100 and 2400 would sum intervals 2305-2400. I just figured out how to use the DataGridView controls in the 2.0 frameworks but now I'm not stuck on this query. Thanks! I figured it out after searching through the T-SQL online language reference, which is pretty nice I must say...if you know what your looking for or get lucky like I did.  Anyways, here's the qu ...Show All

• Visual Studio Lets talk about rendering performance

  Hello. Our company distributes a vertical market accounting app which we've migrated from Crystal Reports to the WinForms ReportViewer. Our installed base is around 6,000 end users. We've found the viewer to be a solid product and we're pleased with the functionality and stability. That said, we may be forced to abandon reporting services for some applications due to performance issues. As an example, we have a report that processes 10,000 rows and perhaps 20 columns. On a 3 GHz machine with 2GB RAM, it takes 40 seconds to render the report (not counting query time). In addition, ReportViewer consumes approx 400MB of memory for this process (after garbage collection). These results won't cut it when a user is waiting for real-time outpu ...Show All

• .NET Development The best practice of using DataSet

  Hi all! I'm developing an application under Framework 2.0,  Visual Studio 2005. The business-logic model I'm using is a Table Module using DataSet. I want to do the application in a "classical" style of using DataSet and Table module business-logic and I want to use only standard "Microsoft-recommended" solutions. So I'm doing the following: to handle some use case (for example, to show joined data in a grid from several database tables) I'm creating a DataSet with the tables I want to join. Then I'm creating the big table to be shown on presentation layer. To insert the data into this "supertable" I'm using relations which I'm designing in the DataSet designer and xpression property of columns as ...Show All

• SQL Server sql 2005 Transaction log size

  We have a database that is backed up every night (full backup). The database size is around 5GB and the transaciton log is about 3GB. And it's 3GB after the backup too. I thought the log size should shrink after each full backup. I can't imagine what data the log needs to maintain after a full backup is complete. What can be done about this large transaction log TIA, barkindog "If, on the other hand, your log has gradually grown, and is showing as almost 100% full, " How can I tell how full a log file is Barkingdog ...Show All

• .NET Development Confused about authentication via certificates

  Hi there, I am developing a smart client and do not want the user to be prompted for credentials, nor do I want to use Windows credentials. Instead, I want to use certificates - one per client and one on the server. I will then attach the client's certificate to the WCF service proxy before calling the server. I have figured out how to generate a certificate during installation but I need to somehow sign that certificate with the server's private key, otherwise anyone would be able to generate a certificate. So my question is how do I generate certificates for the client that are signed with the server's private key Or am I looking at this problem the wrong way Thanks, Kent Thanks Lucian, I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Fullscreen problems....

  EDIT: I am using Beta 2. I use this as the constructor method... public Game1() { graphics = new GraphicsDeviceManager(this); graphics.PreferredBackBufferWidth = 640; graphics.PreferredBackBufferHeight = 480; graphics.PreferMultiSampling = true; graphics.ToggleFullScreen(); content = new ContentManager(Services); } Works great. But when I change the resolution to 800x600, all I get is a black screen. The loop is still running because I can still quit the program. I have also tried 1024x768, that works too. Thought maybe it was an aspect ratio problem, but they are all the same, 1.3333... I have tried turning the multisampling off to no avail. Didnt think that would be it anyways, I play World of Warcraft at 800x60 ...Show All

• SQL Server Error when schedule a job in SQL 2005

  Hi, I have a SSIS package that contains an Execute DTS 2000 process. This DTS 2000 is calling a legacy package, which resides on the same server. The legacy package is just to import a flat file into the database. When i right click and execute this package, it runs perfectly without any errors. However, if i try to schedule this package as a job, it keeps failing. I checked the flat file source for the permission, it does have the account of the executor of the package. In the view history, i didn't see any more information about why it is failing. It keeps saying "The job failed. The Job was invoked by Schedule 10...." Does anyone have any ideas See this KB about turning on logging and general troubleshooting of ...Show All

• Software Development for Windows Vista multiple instantiation of workflow

  Hi all, I'm implementing a WS based 'manager' based workflow. In turn this will call several 'child' workflows. I'm calling the 'child' workflows by raising events from the 'manager'. Question: I'm wanting to wait for the child to finish the request (from the manager), then continue in the manager . There may be several managers running at once . In beta 1 I raised an event back from the client to the manager and all worked sweet. This appears to have changed in beta2 slightly (handleexternalevent has different params) I'm wondering: (a) is there a way I can 'inherit' from one of mycustom workflow classes to create the child wfs. This 'notify back' functionality would be built in and each child workflow wouldnt have ...Show All