Al-Arabi's Q&A profile

• Visual Studio 2008 (Pre-release) SQL Query with "BETWEEN" and "SUM"

  I have SQL Query: SELECT SUM(decimal_field) AS Summ FROM table_name WHERE (datetime_field BETWEEN '01/01/2006' AND '02/28/2007') So, how can I convert it in DLINQ query DateTime date1 = ...; DateTime date2 = ...; var sum = (from row in table where row.datatime_field >= date1 && row.datetime_field <= date2 select row).Sum(r => r.decimal_field); ...Show All

• Smart Device Development Change font in ListBox

  I want to have different style of font in ListBox like italic, bold and normal. How do I do that in .net CF Hi Tan, what you're looking for is an owner-drawn ListBox. That could be done with the DrawMode property: http://msdn2.microsoft.com/en-us/library/system.windows.forms.listbox.drawmode.aspx Unfortunately this property is not supported in the Compact Framework, so a solution could be writing your own Custom Control implementing a list of items, each with its own Font. Gian Paolo Costantino ...Show All

• Visual Studio Team System Coded webtest datasource problem

  Hey all, I've generated a coded webtest from a webtest that works just fine. When trying to run the unmodified newly generated coded test, I'm getting this error: Error WebTest1Coded WebTests Could not run web test 'WebTest1Coded' on agent 'MachineName': Object reference not set to an instance of an object. I've found that the culprit has something to do with this attribute: [ DataSource ( "TestData1" , "Provider=SQLOLEDB;Data Source=ServerName;Integrated Security=SSPI;Initial Catalog=DatabaseName" , Microsoft.VisualStudio.TestTools.WebTesting. DataBindingAccessMethod .Sequential, "TableName" )] If I commit out this line, the test runs fine...but I can't access my test data. Any ideas ...Show All

• SQL Server Formatting With Multiple Columns

  Hello, Is it possible to view the contents of a report in 2 columns for example, if i had a report contained a table with 1 column, could I, rather than epanding that table column down, use some of the room to the right of the table to "repeat" the columns in the table to show more of the data In crystal reports you could achieve this effect by using the "format with multiple columns" option. If you need a better explanation please let me know. Thanks in advance. ...Show All

• Visual Studio Class and Method Metadata Description for VS.NET Intellisense

  Hi, In VS when we make use of any inbuilt Class or method, we get a yellow color pop up description about that Class or method. However, I am not able to providde the same kind of descriptions for the classes and functions I have built. I need the description for the methods to pop up as these classes and functions will be consumed by other developers. I believe we need to make use of tags like C# : [Description] or VB.NET : <description> However, I am still unsure how to go bout it.... Can anybody help Thank you. - Goldy Verma Not really a Class Designer quesiton, but still a good one. Goldy is right about C# - you can use Xml documentation comments in your code to g ...Show All

• Windows Forms Suggestion: Add ClickOnce install for Services

  Since I'm able to create a Windows service in VB Express, it would be nice if the ClickOnce installer could actually install the service executable. This would include installing to a system-wide directory and performing the same tasks currently done via installutil.exe. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Beta 2 announced (date 'in a couple of weeks')

  http://blogs.msdn.com/xna/archive/2006/10/23/announcing-xna-game-studio-express-beta-2.aspx (apparantly this counts as a duplicate post even though its in a different forum so this text is to make it different) Quick Question Because XNA is using XACT which "belongs" to DirectX. This means that each time DirectX comes out with a new version of XACT, XNA would have to be update. So will there be mouthly releases like DirectX or will something else be done ...Show All

• Visual Studio Team System Users / Logins (CTP7)

  I'm experiencing some issues regarding users and logins in the CTP7 version. The story: At first, there's no database or login available in the SQL2005 instance When I create a user named testuser in the Schema View , it is nicely added to the users folder as testuser.user.sql . Since it is created without login , I change the piece of the script to for login [testuser] In the Pre-Deployment folder I change the Logins.sql script to create a login if it does not already exist. Why is the testuser sometimes included correctly sometimes included with without login (although the script says for login [testuser] ) sometimes excluded when building the database project Also, I'm not able to just create a login with password=N'wachtwoord' ...Show All

• Visual C++ Repost-Same code compiled sucessfully on a desktop but failed on a laptop

  Repost due to the display error.--- Below code can buit sucessfully on a DELL desktop but failed on a compaq laptop.The compiler said that snack 's size is unknow. #include<iostream> #include<string> using std::cout; using std::cin; using std::endl; using std::string; struct CindyBar{ string brand; float weight; int calory; }; int main(){ cout<<"Plesae enter the size to determine the array:\n"; int size; (cin>>size).get(); CindyBar *snack=new CindyBar[size]; cout<<"Please enter the items one by one:\n"; for(int i=0;i<size;i++){ cout<<"Please enter the No."<<i+1<<" 's brand:\n"; getline(cin,snack[ i ].brand); ...Show All

• Visual Studio receive "delay notification" when starting VS2005 help file

  hello. when i try to start my VS2005 help either from the IDE or from the Start | Programs dialog, there is about a 2 minute delay before the help file is displayed. If I start the help file from the IDE, i receive a "delay notification" dialog that it is waiting for some other process to finish.. There seems to be plenty of resources left on the PC ,and I see dexplore.exe is trying to load the help file. What could be the reason for this behavior Hi Barrym21, You haven't mentioned it, but if the MSDN Library is stored on your own, local machine, then let's take a look at your Help settings: In the VS 2005 IDE: Go to the main toolbar and open Tools > Options > ...Show All

• Smart Device Development getting passed argument

  is it possible in NETCF 2 to get a passed argument on the start of the app. I am using System.Diagnostics.Process.Start to start a NETCF 2 application. In the ProcessStartInfo, you can specify the executable to start and the agrument to pass. So, how do you get this passed argument within the called app Same way as if application would've started by user. For example, in C# there's an array with argument passed to Main: static void Main(string[] args) { ...Show All

• Windows Forms can i copy two relational records

  i have two relational tables in the dataset i need to copy the parent record from the parent table and all the child records belongs to that parent record ... how can i do that thanks in advance. I really do not understand the question. The datarow has a GetChildRows method which gets the child rows from a data relation. ...Show All

• SharePoint Products and Technologies how to debug an eventhandler

  I've written a eventhandler dor document libraries, wicht creates unique numbers for each document placed in a library. Ofcourse it isn't working, and I would like to debug my code. It looks like the evnt is never called. Can anyone tell me how to debug source code written for Sharepoint 2003 Eddy Thanks for your answer. Unfortunately I dont'have the rights to do that. I will 'debug' with writing to eventlog or textfiles. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mixed Platform Solution Template

  Are there any templates floating around of solutions which allow development for the 360 and Windows I downloaded the XNASharpNES emulator (http://code.google.com/p/xnasharpnes/) yesterday and I really like how the solution is set up. It contains 360 and Windows projects and "Mixed Platform" was one of the build options, so it could build both 360 and Windows versions at the same time. Or could I just create a solution, add a 360 project and a Windows project and then just have them both contain existing code files which aren't specific to either ...Show All

• SQL Server Float data

  Hello. We have a third party app that's database holds allsorts of info as floats. I have to update records in this database from my source database that stores it's data as decimal(8,2). so when I update a row with 25.00 it goes into the 3rd party app database as 25 because it's a float. Is it possible to put the data in so it reads 25.00 without changing the datatype from a float Thanks. The "float" data type does not store non-significant digits. The trailing 0 is non-significant. So the answer is no. You would have to reformat it to decimal(8,2) when you get it back out of the float. ...Show All