friggityfraggity's Q&A profile

• .NET Development DataView Rowfilter

  I am loosing my mind on this :) I have a dataview and I am doing something like this dv = ds.Tables(0).DefaultView At this point if I do dv.Table.Rows.Count It returns 5 If I do dv.RowFilter = " pos = '1' " where pos is one one of the column dv.Table.Rows.Count returns 5 when it should have returned 2 .There are 2 records with pos=1 I am not sure what Iam doing wrong ANy help is appreciated. thanks I think you try to get count by using this property int records = dv.count ; It will return you count 2. You should not you dv.table.Rows.Count property. let me know if you need any code for this ...Show All

• SQL Server Help writing SQL

  I want to select records where a column is null, is not null or is equal to a specific number. How do I do this in one sql statement. My application is an asp.net web site with a business logic layer, a data access layer and sql server. Thank you in advance. ...Show All

• Visual C# WHy doesnt this simple code work? starts at 14 why??

  When I compile this, it starts at 14. But why Shouldn't it start at 1 Like, it would write the number 1 for 25 times, then the number 2 for 25 times, etc till number 25 for 25 times. I don't understand what is wrong with this code. Thank you using System; namespace ConsoleApplication3 { class Program { public static int index,op; static void Main(string[] args) { for (index=1; index < 26; index++) { for (op = 1; op < 26; op++) { Console.WriteLine(index); } } Console.ReadLine(); } } } there is nothing wrong with your code, but the console's screen li ...Show All

• .NET Development Urgent! Pls answer me. Database.

  1. What is the disadvantage of using database (example to keep track high score) 2. If using xml in web service to keep track high score, would it be better Considering of the size of a xml file and a database. fel_down wrote: 1. What is the disadvantage of using database (example to keep track high score) Well, it has of course more overhead than when you update a cell in an array, but it has capabilities to do transactional data storage and for example faster data-retrieval based on queries. 2. If using xml in web service to keep track high score, would it be better Considering of the size of a xml file and a database. I'd consider that the most slow method of doing so. But per ...Show All

• Visual C++ Rebuild using shared precompiled headers doesn't work

  To combat a long build time, I consolidated common headers across 20+ projects into a single precompiled header, to be shared.  The pch file is generated from a separate project (pch.vcproj with stdafx.cpp/h), and it works with clean builds and incremental builds (from editing one of the files belonging to the 20+ projects), but I get compile errors when I choose Rebuild.  Before presuming a bug, I'd like to ask the forum for help.  There are several things that have to be done to get this to work, and unfortunately, I'll have to reveal them to legitimize asking for help.  For sake of generality, lets say one of these projects is A.vcproj.  For PCH\PCH.VCPROJ: (This is a completely default configuration for ...Show All

• Software Development for Windows Vista Black Screen / Freeze after first reboot

  I have spent many hours the past week trying (unsucessfully) to install Windows Vista. I have downloaded and installed all the most recent drivers and BIOS updates for all of my hardware. I have run the Vista Upgrade Advisor and it says that my system should be good to go and that there are no serious issues. The only item on the "Task List" is to download Vista drivers for a wireless networking adapter I have in the system to be installed after. I have tried to do an upgrade from Windows XP and a Full Install of Vista with the same results. I start the install and everything goes smoothly (installer unpacking files and getting ready for installation) until right after the first reboot. The system restarts and tries to boot in ...Show All

• Visual Studio 2008 (Pre-release) XAML to C# Code Covertor

  Is there a way to convert XAML code to a C# code that can then be linked into a project or solution There are several samples in the SDK like FontDialog that work fine by themselves but adding them to a solution that has WPF windows and Windows Forms, the XAML will not compile. It will not give a reason except for error messages stating that methods like InitializeComponent could not be found. This is becoming a showstopper as one can not re-use code. It would be great that all samples have a programmatically created UI version also till such time tools catch up with XAML. Thanks Thanks, Doug , and to all who responded. I will use your suggestion of including Page target when mixing XAML with Window Forms. A way to co ...Show All

• SQL Server using Output clause and return timestamp and return value

  I am trying to bring my stored proc's into the 21st century with try catch and the output clause. In the past I have returned info like the new timestamp, the new identity (if an insert sproc), username with output params and a return value as well. I have checked if error is a concurrency violation(I check if @@rowcount is 0 and if so my return value is a special number.) I have used the old goto method for trapping errors committing or rolling back the transaction. Now I want to use the try,catch with transactions. This is easy enough but how do I do what I had done before I get an error returning the new timestamp in the Output clause (tstamp is my timestamp field -- so I am using inserted.tstamp). Plus how do I check for co ...Show All

• Visual Basic Wait a moment!

  In VB6 there was a wait command that would halt the program untill a button was pressed, or some other type of event would restart the programme. Is this still available in VB.Net Unless your code is telling the program to do something (through a timer, for example), the program by default will not do anything until it receives an event. Using Sleep() in your main thread will not help you if you are waiting for a button push. If you have a process that you want to pause, program it to 'stop' at your predefined point, then monitor a flag, waiting for it to be set. Set the flag in your button push. Alternatively you could throw up a messagebox ("Push me to continue"). ...Show All

• Smart Device Development Slow when retreiving data from database

  Hi I have this problem of slow starting forms in my pocket pc application. Its only for the forms that starts with a connection to a database. the application is also slow when making any connection to the database. I was wondering if there is a proper way to speed this up, and whether using XML files (or even txt files) fatser (almost on the fly) I'm creating a database class that makes a connection and query the database using this code: private DataSet Query(string SQL) { SqlCeConnection cn; SqlCeCommand cmd; DataSet ds; SqlCeDataAdapter da; cn = new SqlCeConnection(LocalConnection); cn.Open(); // Initialize a new command cmd = new SqlCeCommand(SQL, cn); // Initialize a new dataset ds = new Dat ...Show All

• SQL Server Running value

  Hi In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***% For the Row % under total i write like this: =Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2) For the *** % under cumulative total the expression is: =RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100, sum , "AgeByGender" ) But i am getting this error: The Value expression for the textbox '* ...Show All

• SQL Server Using Many-many relationship in SSAS

  Hi, we have built a cube implementing many-many relationship within. will it have any effect on the performance if a many-many relationship is used within a cube with large volumes of data. It depends on your definintion of "large amounts" of data :) But yes, it is true you will see parent-child dimension perfrorming less efficient compared to the regular dimensions in some situations. But again it very much depends on the situation. Try and see if you can detect any slowdown. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Software Development for Windows Vista Error accessing the OLE registry (Build 5744 and msrdp.ocx)

  Getting an error trying to register the msrdp.ocx control on Vista RC2. Using regsvr32 it apparently "succeeds" however programs that use the control report it as not registered correctly. Using innosetup to do the installation gives the error: Error accessing the OLE Registry. Error 0x8002801C. That indicates a permissions error typically. Any idea why this Microsoft control will not register Using the version from Windows Server 2003 SP1. Is there a new version of the control that works correctly on Vista To make it clear, after creating the shortcut, open theshortcut properties and then choose advance button on Shortcut tabs. Thx a lot guys, really wondering how you guys found out the solution =) ...Show All

• SQL Server Conversation Timers in ServiceBrokerInterface

  Using conversation timers, I would like to send a message to myself. I could then use the self-addressed message to check on the availability of a provider. What would be the recommended approach for doing this using the ServiceBrokerInterface It seems that I might need to add a method to the Service class. Is it correct Thanks, You will need to add a method. I would add it to the Conversation class. public void BeginTimer(TimeSpan timeout); Rushi ...Show All

• Visual Studio Team System with http connection added forms in VB 2005 don't get added to source control Team project.

  One of our developers is using http to connect to TFS. When he adds new forms to his project they don't get automatically added to his source control project, nor is there any right click menu item to add it. If we try to drag one of the new files from file explorer, the hour glass goes on for a while, but nothing happens and file is not added to source control. Are we doing something wrong or is this a know bug We have developer who is a not a US citizen, so our corporate security requirements, require him to work outside our firewall, which necessitates his using http to connect to our TeamServer project. Out of the box VSTS is supposed to support http connections. We are just finding that it seems to be a bit flakey and temperme ...Show All