ydurt's Q&A profile

• Visual Studio 2008 (Pre-release) How to get Count in GroupBy

  I tried to translate the very common sql query Select Category, count(*) as NumberOfProducts from Products group by Category into linq syntax. I was able to write it like this: var orderGroups = from p in products group p by p.Category into g select new { Category = g.Key, NumberOfProducts = g.Count() }; Question: is there a O(1) way, to get the NumberOfProducts without using the Count()-Function running presumably O(n) Thanks! Depending on the underlying server, which in all of our cases at the moment, is SQL 2005 - Counting the number of rows in a group is actually a O(1) operation. It has a fixed cost because ...Show All

• SQL Server reporting services installing problem...

  I am trying install my pc Reporting Service with Report Server and Report Manager. But an error occured when I install this program. I had installed SQL Server 2000 Developer Edition in my PC. The error is: "This edition of Report Server Database is not supported on edition of SQL Server 2000 you have chosen. Please choose another SQL Server that matches the requirements. " What do I do Have you tried verifying the edition of SQL Server you're running The following should do it: SELECT SERVERPROPERTY ('edition') ...Show All

• Visual C# Multiple languages on the same WinForm

  Hello, I must write an application that must support input fields for a "left-to-right" language (as English) and input fields for a "right-to-left" language but on the same form . The keyboard is bilangual (QWERTY and a "right-to-left" language). When the user enters a left-to-right language input field, the keyboard keys must be QWERTY. When the user enters the right-to-left language input field, the keybord keys must automatically switch to the second language. Is it possible with C#.NET/WinForm/Textbox Thanks in advance, Stephane. The character set is a ...Show All

• Visual Basic Publish Error - Application Improperly Formatted

  Hi. I have developed an application using VB Express Beta 2. I am trying to publish it to share the application with others. When I try to publish it to my hard drive and then run the setup.exe, I get an Application Failed pop up that says the application is improperly formatted and the details are as follows: PLATFORM VERSION INFO  Windows    : 5.1.2600.131072 (Win32NT)  Common Language Runtime  : 2.0.50215.44  System.Deployment.dll   : 2.0.50215.44 (beta2.050215-4400)  mscorwks.dll    : 2.0.50215.44 (beta2.050215-4400)  dfdll.dll    : 8.0.50215.44 (beta2 ...Show All

• SQL Server Extract only unique entries to destination as to avoid duplicates?

  Hello, I have several source tables.  Some have unique keys, some do not.  All the tutorials I've seen on the web involve importing the entire collection of data from one source to the other.  I simply want to import data that does not exist in the destination table. Can we start simple   Suppose the source and dest. tables both have unique keys...how do I configure the lookup transformation to do something of an equivalent of a LEFT JOIN and copy only new entries The second challenge I have is for a table without a primary key.  Only thing I can reference are two fields, a date, and a time.  When paired, it ...Show All

• .NET Development .Net and SQL interaction

  I wrote a web application in VB.NET.  After deploying it at the user, I realized that my machine's regional settings and the client's settings, differ.  I added the Globaliszation .... to web.config but now experience major errors on my database calls when I want to work from my machine on their database. I get the following error when passing a data parameter in a select statement:  "Cast from string "5/23/2005" to type 'Date' is not valid." My machine is set up as mm/dd/yyyy and the machine which hosts SQL Server with the backup of the clients db was originally set up as dd/mm/yyyy.  IF I change my regional settings ...Show All

• SQL Server How to create Trigger which CREAT TABLE from a Variable string?

  I have a Table Name "Forums" . I want to ceate an AFTER-Trigger on it. It will execute when ever a new row is inserted to "Froums" Table. Here is what I did but It needs to be corrected: :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ALTER TRIGGER CreateTopicsTableTrigger ON dbo.Forums AFTER INSERT AS SET NOCOUNT OFF DECLARE @myNewForum varchar CAST (@@ROWCOUNT as varchar ) /*Is it OK */ SET @myNewForum=@myNewForum+@@ROWCOUNT /*Here I dont know how assigments work in SQL*/ GO CREATE Table @myNewForum /*Will this work some ...Show All

• .NET Development Convert Hex to Decimals/Long?

  I have a problem. But on .NET 1.1 My Scenario: Actually I will have a string of hexadecimals read from a xml file. Then from the hexadecimals, i will add 1 value whenever i made any modifications. But just i do not how to get started. It is like an incremental hexadecimals. I have a string of hex. string strHex = "0100000000FF"; I want to convert this Hex to decimals, just like the windows calculate, when you type FF in Hex and click on Dec radio button, it will change to 255. I tried string.Format("{0:d}", strHex); I tried Convert.ToDecimal or Convert.ToInt64 But i still cannot find a solution ---- I know how to convert long to hex ...Show All

• Visual Studio Team System Task Duration MS Project vs. VSTF Task

  The task duration in MS project is in days. I use man hours in my Team Project tasks (work items). If I say something will take 20 man hours, MS Project sees that at less than a day. What does one do to make more sense of this inside MS Project Good find! By the way, we have a fix for this issue. if you would like to continue using commas in the resource names, call CSS and ask them for the free fix for this issue. Good luck! ...Show All

• .NET Development Read a pipe delimited file

  Is there some easy way to read a pipe delimited file into a dataview, dataset, datatable etc Basicly I'm working on an interface to a web app that will respond with a pipe delimited set of records.  IE each record on a seperate line and each field seperated by a '|' char.  I'd like to get this into some form of data object to be able to better deal with it in code. Hi, Here is a code snippet that loads the the data into a DataTable from a string if you have the pipe separated data in the string. DataTable objDataTable = new DataTable();    string [] strLines = null ; string [] ...Show All

• Smart Device Development Pocket PC and Merge Replication on SQL 2000

  Thanks in advance for advice. My company is trying to start developing on Pocket PC Palm Devices with Visual Studio 2003 and I am having a little trouble. I am trying to set up the merge replication on SQL 2000 and make my emulator sync and I cannot seem to get this to work properly. If anyone has any links or advice on where to go to get a better understanding of how this works i would greatly appreciate it. Thanks Again Trent Jackson DarcoWiz, What I had to do is go into the settings of the emulator and then into connections and set all connection settings to "Internet". This allowed me to get out on the Intern ...Show All

• Windows Forms Draw Rectangle.?!

  iam new in GDI+ i draw a rectangle in my form how i can select this rectangle at runtime and i can move it and resize it at runtime thanx Noooow wait a second, two guys with two answers.  lol You CAN, but like one developer said, you'd have to use the OnMouseDown, OnMouseUp, and OnMouseMove event handlers. OnMouseDown = tell the bool  ...Show All

• Visual Studio 2008 (Pre-release) Dynamically adding elements...

  I am trying to dynamically add shapes to a canvas at runtime. I understand how this process is done when pre-defined in XAML but I need to know how to do it from the c# level during runtime. I keep running into a compile time error which says "Error at element '' in markup file 'Window1.xaml' : Exception has been thrown by the target of an invocation" . Here is the code I have... Am I doing something fundamentally wrong or is this just a error with my code public Window1() { InitializeComponent(); Canvas c = new Canvas (); Ellipse e = new Ellipse (); e.Height = 100; e.Width = 100; e.Fill = Brushes . ...Show All

• Visual C# How to update an Access Database (C#)

  Hello All, I am a little new to Visual Studio, but I hold 3 years programming experience in both Java and C. I have created a program for my wife that allows her to organize and save her DVD collection to an access table. The program works just fine except for the save part. I can run my application, insert, delete, and edit the contents of the database, but it will not save. To my knowledge I am only working through the dataset and the data never hits the database file itself. I just need a little help here because I am excited to get this application rolling. It is a little useless if you can't save data. I have an access database ...Show All

• Visual Basic Problem with Picturebox control

  I wrote a windows app in VB that contains a PictureBox that displays a jpg that is contstantly changing. To refresh the picture I used a timer that on every tick would execute: Me .PictureBox1.ImageLocation = "FileName.jpg" It was working great until I reinstalled Visual Studio becuase of a differant problem. Now I just get the little white box with the red X in it as if the picture file doesn't exist. I haven't changed any of the code it just stopped working. I have tried using other images and image types but it still won't work. It does load the picture if I set it from within the IDE but when the first tick fires ...Show All