Aarontt's Q&A profile

• SQL Server SQL 2005 bug? not follow the order by sequence in view...but SQL 2000 does!

  I have a table: CREATE TABLE [dbo].[tx1]( [f1] [nvarchar](50) , [seq] [int] IDENTITY(1000,1) NOT NULL ) ON [PRIMARY] SELECT * FROM dbo.tx1 ORDER BY seq DESC go f1 seq zz 1003 uu 1002 kk 1001 yy 1000 create view vx1 as SELECT top 100 percent * FROM dbo.tx1 ORDER BY seq DESC go select * from vx1 yy 1000 kk 1001 uu 1002 zz 1003 The problem is one of misunderstanding. A view is a table, and a table is an unordered set. The sort by is used to resolve the top clause only. SQL Server returns rows in whatever order is best for it. If require rows ordered in the output the only way to do this is with an ORDER BY clause on the final SQL Statement. A few other threads: ...Show All

• .NET Development listen port

  hi please help me. I have a question about ports & sockets . I am trying to write a program that cans listen to the port 80/8080 and deagnose pdf or zip files from other files(html,...). then recive this files from port . I know how resice the file by c#.net but I do not know how deagnose files type . thanks. If you're reading the file over the TCP (i presume) port then you will have to read the first few bytes to determine the file type. That is pretty simple: for instance, the every PDF file starts with the byte stream: %PDF-<version number> where <version number is something like 1.3 or 1.5. Zip files start with the byte stream: PK Hope this helps. ...Show All

• SharePoint Products and Technologies Adding users

  Hi, I created a top level website using wss 3.0 Now I added two groups "Users" and "Admin" I'm adding the users from ADS.....problem I'm facing is that now I want to add a user in both the groups.....when I do this I have to first select a group and then add the user and then select second group and again add the same user to this group.... Cant I assign multiple groups at a single place for a user.... Thanks MK I find it easier to set up groups in Active Directory, where you can in fact add a user to multiple groups in a single dialog. You can then add each AD group as the single member of the corresponding SharePoint group to achieve what you seem to wa ...Show All

• Visual Studio 2008 (Pre-release) General queries about DLinq

  Hi, I have read a bit of documentation about DLinq. I find it a very interesting prospect. However, I have a few doubts regarding DLinq. Here is the first set of doubts (They are not categorized. They are just random). We wish to use DLinq in our project. What are the major risks you forsee with respect to the early adoption of DLinq What are the major steps we should take to minimise the risk because of early adoption Why isnt there a feature to map a property with a different name than the column it is being mapped to Are composite keys supported I have a requirement where two columns should not be direct properties of my business entity and instead should be part of another component which is a propert ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ok guya i'm a newby and i need orentation

  Well i have sometime on the way of convert me to a game programmer; but i live in southamerica chile. and the things are really difficult to archieve this. Well i decide to do this i need to learn c# and the Api Xna. Well i have one problem i don't have the tools to do that. I need some orientation where to start. I think the first think is to learn c#. Someone can tell where can start thnks for your atention. And me apologies for my bad english mmmm i don’t care if the book is in english is a litte more slow if the book waas in spanish but no it a mojor problem. Bur i don’t want a book only of the lenaguage c#, i want a book tha cover analisys and design of clases and programs and the best practices and recomenden also. ...Show All

• Visual Studio 2008 (Pre-release) cannot able to open new xaml browser project

  hi i hv laptop of Hp Pavillion dv6000..... AMD turion 64 bit processor ,,,, 1 gb RAM,,,,,,,, 40 GB HDD .....running with windows xp 2. i had install .net framework 3.0 but whenever i m going open xaml browser application it gives me warning that " the system can not find specified file "..... then what to do ......... If you're seeing this error when you try to create a new XBAP project in VS2005+VS Extensions for WPF, can you try uninstalling VS Extensions for WPF, then re-installing it ( http://msdn2.microsoft.com/en-us/vstudio/aa700831.aspx ) If you're seeing this error when you activate the app (say, by double-clicking in .xbap or navigating to its URL), then as Lester ...Show All

• Windows Forms Tab Contol Help...

  I posted this in another part of the forums and didnt get much replies about my first question so i will past the first half of my question here. Hi everyone, some of you have helped me with opening a new form NewEvent neform = new NewEvent(); neform.Show(); which i understand just fine but i was wondering how do i open up and new form with the tab control on it, and make it so that when it open it will open straight to that tab instead of click on the tab for example say you have 2 tabs "tab1=Meeting, tab2= Things to do". and then you go to File>New>Meeting or File>New>Things to do, and it will go straight to that tab, Hi, You have to add a property to the Ne ...Show All

• SQL Server How to pass parent package parameters to a package executed by SQL Server Job Agent

  Hi, I'd like to know if there's a way to pass parent package parameters to a package executed by SQL Server Job Agent It appears that sp_start_job doesn't have any variable that could accomodate this. Hope to hear your ideas. Hi Jon, The only ways I know to get parameters into a package executed by SQL Agent are: Package configurations. Custom parameter value storage - I like to use a database for this. Personally, I almost always use 2. Hope this helps, Andy ...Show All

• .NET Development Exception: DataTable internal index is corrupted: '5'. on ...

  Hi, I have a problem with bindingsource component in framework 2.0. I have a combobox bound to a bindingsource which is also bound to a dataset with 2 related tables and a datagridview bound to the same bindingsource. What I want to do is : When the selectedindex property of my combobox changes, the corresponding cell value must be changed in the datagridview. But although the value in bindingsource changes, datagridview does not display the new value. That value is displayed after I move the mouse over that cell and make it invalidate its region manually. Another error I caught is the one that you can see as the subject of my post. I do not know why i have that message when I try to change the property of ((DataRowView)mybindi ...Show All

• SQL Server SQL 2000 Report services incomplete export to excel

  I have a report that I am trying to export to excel.   The export seems to work but the data in the spread sheet is incomplete.   The document map is completely exported but the work sheets are not.   The links in the document map stop being links after the first occurrence of the lowest level detail.   All the data is visible in Report services and all the data exports to PDF.   There are 5 levels and 124 pages in the report in the report.   I have other reports on the same server that are larger (7 levels and 512 pages) and they work just fine.   They export to excel with no problem.   Any ideas or input would be very appreciated.   Ayla ...Show All

• Windows Forms Radiobutton in Datagridview control

  Hi, I am new to winform apps. Can anyone give direction/inputs or sample code to display radiobutton in datagridview control.I appreciate ur help. sk Check this link: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/winf_radiobutton.asp ...Show All

• SQL Server Designing Custom Reports

  Hello !! Im'using Reporting Services SP2 on SQL Server 2000 SP3a. I work with Visual Studio 2003. I have some questions concerning the capability of Reporting Services : 1. Is it possible to use some Javascript in the expression. For example in the action "Jump to URL" I want to open a pop-up with information from the database. I found the following examples : =void(window.open('" & Globals!ReportServerUrl & " /ReportName&rs:Command=Render&rs:Format=Html4.0&Parameter1=" & Fields!Field1.Value & "','_blank'))" =window.open('" http://www.msn.com"','_blank' ) =void(window.open('http://www.msn.com','_blank'))" But I'm not sure that's avalaible for SQL s ...Show All

• Visual Basic Convert dataset into an array

  Having trouble finding code to convert a simple dataset into a VB 2005 array. The dataset (result of a SQL query) returns a single table with three columns. Would like to read the table into a multi-dimensional array which I can then manipulate outside of the dataset. Any help would be appreciated. pseudo code: For x As Integer = 0 To ds . Tables (0). Rows . Count -1 MyArray ( x , 0) = ds . Tables (0). Rows ( x )(0) MyArray ( x , 1) = ds . Tables (0). Rows ( x )(1) MyArray ( x , 2) = ds . Tables (0). Rows ( x )(2) Next ...Show All

• SQL Server difficulty in getting result.

  hi all i am working on sql reporting 2005. i have 3 reports say A, B ,C i want to display sum of values in column of A & sum of values in column of B in report C How can i do this plz help me. ...Show All

• SQL Server vertically merge cells containing duplicate data

  Hi,   I am constructing a report with the Report Designer in which I want to create a form of visual grouping by hiding duplicate data.   My data is this:   foo 2006-01-01 12 foo 2006-01-01 32 foo 2006-02-02 345 bar 2006-01-02 1534 bar 2006-03-03 345 bar 2006-03-03 234     This is how I can do it with hiding duplicate data:   foo 2006-01-01 12 32 2006-02-02 345 bar 2006-01-02 1534 2006-03-03 345 234     And this is how I want it to be:   foo 2006-01-01 12 32 2 ...Show All