WNBS's Q&A profile

• Windows Forms Set DB Connection object global for all forms

  Hello, I'm making a winform application who work with Oracle. I need to be always connected to oracle, since the application start to the application stop. The main form of this application is an MDI Form, on most of the other form are MDI Child. I would like to create a  Database object connection only one time, then i will be able to use th ...Show All

• .NET Development Affected records

  Can anyone tell me how to count the affected records in a datagrid view, BUT BEFORE THE UPDATE process I mean - i want to know how many changes i've been made befor update them in the table.  Thanks! Hi, In addition to that, you can also use the DataTable/DataSet GetChanges() method. It returns a databale containing all of the changes in a dataset/datatable.     cheers, Paul June A. Domag ...Show All

• Windows Forms it is NOT possible to setup win app without .net Framework?!!!!!!

  Hi Folk I have created a Win .net Application and when I try to install it, it asks me to install the .net Framework first!!  Is it possible to install a Win App on third party machines without the need to install the .net Framework !!!!!!!!! This is a big disaster, if I will need to install a 20 MB to make a 200 kb application Works!&nb ...Show All

• SQL Server combining 2 select with count and datediff into 1 select. need help.

  I have created two select clauses for counting weekdays. Is there a way to combine the two select together I would like 1 table with two columns: Jobs Complete Jobs completed within 5 days 10 5 ------------------------------------------------------------------------------------------------- SELECT COUNT(DATEDIFF(d, DateintoSD, SDCompleted) - DATEDIFF(ww, DateintoSD, SDCompleted) * 2) AS 'Jobs Completed within 5 days' FROM dbo.Project WHERE (SDCompleted > @SDCompleted) AND (SDCompleted < @SDCompleted2) AND (BusinessSector = 34) AND (req_type = 'DBB request ') AND (DATEDIFF(d, Datein ...Show All

• Visual Studio Team System Disk Space requirement during installation

  We're installing BETA 3 Refresh on a Virtual Server for testing purposes prior to developing a production machine.  According to the installation scan, we have met every requirement except disk space.   The virtual image has a hard drive of 9.98 GB.  There are 5.02 GB of free space remaining for the install. Looking through the install documentation, there are recommended hard drive sizes, but I don't see a required minimum hard drive size.   Aside from just randomly making a larger hard drive, is there a known minimum amount of free space required Thanks in advance. - Short on Drive Space (I know it's che ...Show All

• Windows Forms PDA Hardware Details

  Hai everybody,    I have creaated a PDA application.I need to read the hardware details of PDA on which i insatlled using code in .net.Can i use WMI in PDA.Please help me with a solution.  regards shine ...Show All

• Smart Device Development Can't initiate sync from PPC 2003 SE SDK Emulator.

  I have created a VS 2005 + NETCFv2 application which uses ActiveSync. I am able to deploy, debug, and run everything I need to on the WM 5 emulator and the PPC 2003 emulators with no problem. On the WM5 version of my app, I use ActiveSyncStart which works great. On the PPC 2003 version of my app, I'm using "repllog.exe /remote /all /h" instead. However, on PPC 2003, the synchronization does not start. I then tried initiating a sync manually from the device (emulator) by going to ActiveSync and clicking the sync button; but nothing seems to happen. I am able to synchronize when I initiate sync from the desktop ActiveSync. ...Show All

• Visual C# Separating data access form code.

  Greetings All, This inquiry is regarding the separation of data access from a windows forms application. I currently have a class called Data which exposes static methods that basically take in the form variables and then creates, updates and deletes those variables from a sql database. So in my form class I can call this: Int Success = Data.UpdateDate(DateTime date); (return -1 if unsuccessful) My question is – is there a better way to separate the data from the form logic. What are some more popular methods used I often hear the phrase n – tier application - where you would separate out GUI, busin ...Show All

• .NET Development XML File vs XML string

  Hi All, I have a simple Windows form that implement the Web Browser component.  This form is used to simple display data from a XML file using a style sheet (from a XSL file).  Basically, this has been accomplished by the following simple two lines of code (thanks to Microsoft ) protected internal AxSHDocVw.AxWebBrowser axWebBrowser1; axWebBrowser1.Navigate("C:\xxx\MyData.XML"); My problem now is that, instead of having the MyData.XML from a file, I got the XML from the database via a stored procedure that return me the XML formatted string. The old way:  I got the xml file and the xsl file. The new way: I got th ...Show All

• Visual Studio VS.NET 2005 Beta 2 automation samples ?

  Hai ....,          Can anyone please give me the link where I can find automation samples for VS.NET 2005 Beta 2 . I was very much confortable in developing Add-Ins for VS.NET 2003, but really struggling with VS.NET 2005 Beta 2. If anyone can guide me with a simple example : 1. How to: Build Basic Add-In example 2. How to: Deploy the Add-In 3. How to: Remove the deployed Add-In 4. and finally How to: Debug the Add-In          It would really be a great help for me Hello Mr.Brown,           &n ...Show All

• Visual Studio Run a target if a specific file is updated.

  Hi, I would like to know if it is possible to specify the launch of a target when a specific file is updated. Currently, you can use the BeforeCompile target to do this when the project is loaded or a file is included or excluded in a project. I would like to avoid the development of a custom tool. A solution exists Thanks for your help. Pascal. I would like to know if it is possible to specify the launch of a target when a specific file is updated. Are you asking if you can make a condition that a target executes after a file is updated, like a trigger If so this is not possible. However you may be able to achieve what y ...Show All

• Visual Basic WM_HOTKEY

  Could someone help me to learn how to use the WM_HOTKEY function to make a background program / process run code on a hot key press such as prnt screen or numb lock ...Show All

• Windows Forms file io permission with authenticode signed usercontrol in IE

  Have a Windows forms usercontrol embedded in IE.  Control is authenticode signed.  Receiving Fileiopermission error after selecting file in FileDialog.  Adjusting Policy on client machine is not an option.  I've tried several combinations of Code Access Security configurations in code without success. If I use assembly or class declaration such as: [FileIOPermission(SecurityAction. ...Show All

• Visual Studio Express Editions Release troubles

  Hi I have a strange problem. I have compiled and build my project, a small computer game, and it runs fine on my system. But as soon as someone else who doesn't have Visual C++ 2005 Express installed they can't run it. I really don't know how to solve this. First I tought that it was because I was building in debug mode, but now I have made a release build and it still doesn't work. It just says something like, "This application can not start because its configuration is invalid" I'm using a free game engine to develope my game, called GameX, from were I'm using a lib-file. This is my settings: Additional d ...Show All

• Visual Basic Making a Database

  Hi i was wondering if there are any tutorials around on creating databases in vb6 and vb.net If you have Visual Studio 2005 Standard or above (Maybe even Express ) you can simple add a SQL Server 2005 DB to your project. You can do a lot of fundamental DB creation tasks in the Sever Explorer (ignor the Dataset Creation wizard until you finish creating the DB). VS has integrated functionality for creating tables and modifying columns and restraints and relations and my personal favorite: Creating Stored Procedures (and testing this stuff all out with the query editor). If you have Express you might still be able to do it but I can't pers ...Show All