wandasoozq's Q&A profile
SQL Server Which SQL Server do I use..Please advice...
Hi, I am currently creating an application that requires the use of Pocket PC/PDA. The same application that runs on the desktop is to be run on the mobile device metioned above. I am confused as to which of the following combination servers i should use. Option1) Desktop - SQL Server Express Edition (Multi-user) Mobile Device - SQL Sever Compact Edition OR Option 2) Desktop - SQL Sever Compact Edition Mobile Device - SQL Sever Compact Edition To my understanding, if I use SQL Server Compact Edition on both my desktop and mobile device, when i need to synchronise, the entire database from the mobile device is copied over to the desktop and vice- versa. However, I prefer only modified data to be synchornized. Can I achieve it ...Show All
Visual Studio help with VB macro in .NET '05 IDE
hi, i wrote a macro to break into a running application while i am debugging. i did so because in C# when i break the "Program.cs" file is opened. i don't want it to open and i always dismiss it. here is the macro: Sub MyBreak() Dim i As Integer Dim Wnd As Window Dim FileName As String FileName = "Program.cs" DTE.Debugger.Break(True) 'find the window and activate it For i = 1 To DTE.Windows.Count Wnd = DTE.Windows.Item(i) 'MsgBox(Wnd.Document.FullName) If (Wnd.Document.FullName.Contains(FileName)) Then Exit For End If Next Wnd.Activate() Wnd.Close(vsSaveChanges.vsSaveChangesNo) 'now close it 'DTE.ExecuteCommand("Win ...Show All
SQL Server Dates problem in SQL Server Evrywhere edition.
I have created a sample Database for the school project, After executing the query below, the Date column is supposed to have the dates I have entered before, However the dates shown are 1900. Any idea why is this happening I appreciate your help. Thank you. Query: Drop table AccountReceivable GO --BEGIN TRANSACTION Create table AccountReceivable ( AccountRecID int identity ( 1 , 1 ) not null, PatientID int not null, PresentCharges int default 0 not null, PaymentMade money default 0 not null, PreviousBalance money default 0 not null, BalanceDue money default 0 not null, LastPaymentDate datetime not null, PresentDate datetime default ...Show All
Visual Studio Express Editions AccessViolationException was unhandled
Sometimes when I run my program I get the above error message displayed, other times the program will start fine. The message shows after my splash screen has gone and the main form is supposed to show. The message has become alot more frequent, if anyone can help my correct the issue with the exception detail I have pasted below, I'd be very grateful. Andy. System.AccessViolationException was unhandled Message="Attempted to read or write protected memory. This is often an indication that other memory is corrupt." Source="System.Drawing" StackTrace: at System.Drawing.SafeNativeMethods.Gdip.GdipDrawImageRectRectI(HandleRef graphics, HandleRef image, Int32 dstx, Int32 dsty, Int32 dstwidth, Int32 dstheight, ...Show All
Visual Studio Team System Unit tests problem
Hello. We have one serious problem with our Team Foundation Server System. We have autobuild setuped on Team Server - unit tests are builded and runned there every morning. These unit tests are completely errors free and working - on local machines (where they was developed) they are builded and runned successfully. BUT at the Team Server they is always one exception thrown during unit test runing - "System.Runtime.InteropServices.SEHException: External component has thrown an exception". This exception is always thrown at lines like this: "ComponentHost host(__uuidof(ComHost));". All creating COM components are registered at the build machine. The user under wich build process is running has all needed permission ...Show All
.NET Development Update Database from Dataset / Datagrid (Mixing Access/Excel Input)
I've been struggling with this as well. A lot of the documentation has to do with SQL and I am working with OLEDB from an Access DB. I want to import the DB to a dataset, populate the datagrid with the dataset. Updates will then be made to the datagrid programatically. Once verified they'll then be updated back to the dataset, then to the DB. I'm having an issue with sending the changes from the datagrid to the dataset and in turn, the DB. I modified the above code slightly to work with my adapter/datagrid and it looks like I need to convert my Datagrid to a datatable before attempting to update the dataset. I get the following error with the code above: Unable to cast object of type 'System.Data.DataSet' to type 'System.Data.D ...Show All
Visual C++ VS crash when updating intellisense
hello we using C++ manage code, with about 22 projects, when we open vs project from "VS2005 pro" updating intelisense is start, and when it get about 70% of it process we get microsoft error report, and Vs crash and restart , the only fix we find is to disable intellisense by rename FEACP.DLL. i find this solution unconvenion, we had this error in a last 3 months on diffrent computer in diffrent time. this is part of event viewer log (notepad with event id is attachment) Event Type: Error Event Source: Microsoft Visual Studio Event Category: None Event ID: 1000 Date: 30/01/2006 Time: 16:43:48 User: N/A Computer: **_XP Description: Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module vcpkg.dl ...Show All
Smart Device Development 'System.Xml.Serialization.XmlElementAttribute' does not contain a definition for 'Form'
Hello, I'm getting the above error message in the generated client code for a web service. The web service is a JAXWS 2.0 and I'm generating the client part with VS 2003. What I found was that the Form property is supported in CF 2.0 but not CF 1.0. I need to use VS 2003 so I'm limited to CF 1.0. How to solve the problem Thanks It seems my problem is very rare. I can't find any information about solving it. I also wonder why is the form property in System.Xml.Serialization.XmlElementAttribute generated in the first place. I used the web service address from the quickstart tutorials and there was no form property in the generated client code. Any ideas will be appreciated. ...Show All
Visual C# error message: An object reference is required for the nonstatic field ....
I am getting the error 'An object reference is required for the nonstatic field, method, or property ' when I attempt to run my client application. I am not sure what is wrong and the documentation on this error (#CS0120) in the VS.NET IDE is confusing to me. Does anyone know what I am doing wrong MY code is below. People is a collection class and myPeople is obviously an instance of it. Because the error appears to involve the client code and not the class library with the implementation of People, I did not include that code. I could if it would be helpful. Thanks for any help. using System; using PeopleLib; namespace Ch11N01 { /// <summary> /// Summary description for Class1. /// </summa ...Show All
Visual Studio vcbuild usage question
If this isn't the right forum, please point me to the right one... I tried posting in a VC++ forum and they directed me here. I've read that msbuild currently just invokes vcbuild, so I guess they're the same for now. Anyway, I'm converting a VS6.0 workspace to a VC 2005 solution. I've seen the pages with the vcbuild command line syntax at http://msdn2.microsoft.com/en-us/hw9dzw3c.aspx and the page for the options at http://msdn2.microsoft.com/en-us/cz553aa1.aspx. In my nmake makefile, I currently have: msdev ProjectName.dsw /make "ConfigurationName - Win32 $(MSDEV_CONFIG)" ... where $(MSDEV_CONFIG) is a macro. What is the vcbuild syntax for this The command line syntax page referenced above says I can use [config | $ALL] which ...Show All
SQL Server Implementing "preconditions"
I have about a half-dozen insertion tasks that depend on a condition: SQLServerProcessDate == OLEDBprocessDate. If the task executes early, old data gets inserted and needs to be backed out later on. (This happens about two-three times a month.) The jobs start at 8:00 PM, but on occasion processing runs late. In order to make the task intelligent enough to not insert old data, I've thought of a couple options: 1.) Separate scheduled job runs continuously, comparing process dates. When the dates match, it sends a message to the other jobs. Pro: less repetitive. Con: another scheduled job ! I'll have to learn the message queue task; a little bit complex; flood of database activity on message reception may slow system down 2.) Compare the dat ...Show All
Visual C# Process.start() how to
Hi All, I'm using process.start() to execute msbuild.exe. Is there any properties or method that I could set or call to wait until it completely finished before the next line of code get executed Best Regards, next line of... your C# code there is. you need to use a WaitForExit() method in the Process class. Example: Process theProcess = new Process(); theProcess.StartInfo = new ProcessStartInfo("filename.ext"); theProcess.StartInfo.Arguments = "args here" theProcess.WaitForExit(); theProcess.Start(); this will wait until the process has finished executing before running the next line of code in your C# app ...Show All
Commerce Server Browse.aspx and ProductList.ascx
More of an asp.net question than a commerce server specific one, but here goes. In the starter site, on Browse.aspx, the CommerceSite.Controls namespace is declared at the beginning of the page and the ProductList.ascx control is registered immediately after. This let's you drop a <site:ProductList> user control in to display products whose data comes from ProductFilterDataSource. I've got the need to dynamically create ProductList user controls (quantity from 1-n) depending on the category and I need to do it from code behind. I'm having problems registering and namespace and user ProductList user control properly so that my Browse.aspx.cs code behind file can utilize it. Clear as mud Thanks for any suggestions. Brad ...Show All
Windows Forms Determining whether a control came from an inherited form
Hello, I'd like to know if there is a way to determine if a control was added to an inherited form or was it inherited from a base form. I tried GetType but I couldn't figure out with properties/methods to use. Thanks, JR Thanks Brendan, but that's not quite it. I have a form that inherits from another form. The base form has certain controls that are going to be standard across several forms. After I inherit from the base form, I will add additional controls to the new form. Here's where I need to know if the control I just added is new - meaning it does not exist in the base form. I tried the following but it did not work: Public Class InheritedForm Private Su ...Show All
Windows Forms Working with Datasets & DataGrids
Hello there. I am working on datasets and datagrid tables and having some difficulty. I want to read some information from a file and place it in the table for different coloumns the command i was using to add information to a row of dataset was dataset1.tables(table1).rows.item("field1") = newvalue but this doesnt work. my aim is to add a new value for each of the coloumn in the table and move to the next row, then repeat the same process to add some more new values for that table. Also, in excel i can add a hyperlink to a cell if i want.i know the excel command for adding hyperlinks to a cell....can i do the same for dataset tables also.If yes,..then how , I want to add a hyperlink to point to a file.. c ...Show All
