RoxanaT's Q&A profile

• SQL Server Rollup

  Hi, I have a table in a particular order which I ned to maintain.when I say select a,b, from tab group by a,b,c with rollup the order of the output is changed.How can I avoid this. thanks, ssm ...Show All

• .NET Development Unwanted promotion using TransactionScope

  Hi, I wanted to test System.Transaction and using TransactionScope. So I wrote a little factory class which has very basic CRUD functionality. One of it's methods is CreateName: public static Name CreateName( string nameValue) {     using ( SqlConnection connection = new SqlConnection( Properties. Settings .Default.TestDB))     {        return Crea ...Show All

• .NET Development Code runs but database doesn't update

  All, I'm new to ADO.NET (used to work in ADO and am really struggling with the concept!)... I've got a web form, which has a dataset and connection attached with 2 text fields that I want to use to add a new record to a table. The code runs fine, but the database does not get updated... the db is Access. Here's the code - I know I'm doing something stupidly wrong, but I can't work it out! Thanks in advance. Dim strPN As String Dim s ...Show All

• Software Development for Windows Vista File organization in Windows Explorer

  I don't know about all of you people, but I find the fact that the Windows Explorer in Vista doesn't make the difference between folders and compressed files when sorting files by name extremely irritating. Per example, my downloads folder is filled with ZIP files and I also have folders in which I put files of different categories, such as Games, Software, Windows, Drivers, etc. In XP, those folders are always at the top of the Explorer's wi ...Show All

• SQL Server Reference Dimension causing long processing times

  I have a reference dimension that is linked to a regular dimension that is linked to the fact table. For some reason, when I process the database with some small sample data, it take about 5 minutes to process, where it should take 10 seconds. I am using a reference dimension because it is a child-parent hierarchy, and I don't think I can merge it into the regular dimension. My work-around is to just include the link to this reference dimension ...Show All

• Visual Studio Express Editions how to import Bookmarks favorites file to treeview

  hi i'm export my favorites links from internet explorer as html file now i want to import this ( html ) file to tree view on my form i can read form this file and get folder name and URL but i cann't make it as tree it's now in on level only i want to read from this file and make tree view in many level can you help me if you want to explanation pls tell me   ok, just put folders inside each other and when you exporting ...Show All

• Visual C# dataset table row into an arraylist

  How to put a list of rows from dataset table into an array I tried with this code but it doesn't help. ArrayList arrayList = new ArrayList(); foreach (DataRow dr in db.dataSetUsers.Tables["Functions"].Rows) { arrayList.Add (dr["Name"]); } Hi, Simplest option..Just call a Select on the DataTable with a blank string for filter. DataRow []arrDataRow = null ; arrDataRow = db.dataSetUsers.Tables["Functi ...Show All

• Visual C# C# Generic Constraint Improve Way?

  C++ template use constraint by signature,It's very flexible to programmer but complex for complier, and at most time programmer can not get clear error message from complier if error occur. C# generic use constraint by type,complier is relaxed, but it is very limited and even sometime tedious to programmer. Is there a way to get merits of both (NOTE: I think the all-important purpose of develope tools is to let programmer relax, not the compli ...Show All

• Windows Forms Treeview Problem

  Hi, I want to prevent the user from cliking the nodes in treeview up to child node's document loaded completely. any one help me out. Thank you iam finding the selection changed. i have child nodes which contains html documents.if i click on the child nodes one by one it will display the particular document. if i click continuously on child nodes the selection is moving but it does not fetch the corresponding document. t ...Show All

• Visual Studio Express Editions How can I have program "follow" user from workstatation to workstation.

  I'm developing an application be used in a networked, multi-workstation, multi-user environment. I'd like a user to be able to move from one computer to another, and have the application resume where (s)he left off.on the other machine. Eg. 1. User at order desk pulls up record for customer ordering a part. 2. User locks the session, and travels several hundred feet to find the part in the warehouse. 3. User finds the nearest a ...Show All

• Visual Basic Creating a "Flashcard" program 4 kids

  Hi all, I am taking beginning VB in college and I am creating window apps rite now, I would like to do a side project. The side project would help my kid on math, what it is is a math "Flash card" type program , what im trying to do is have program create random numbers like " 4 x 4 = " or " 10 + 5" that type of thing, I have looked thru my text book "Programming in Visual Basic .Net" ( its VB 2003.net vers that I am using) and only example they ...Show All

• SQL Server SSIS Package Configurations Stored in SQL Server Table

  I have two SSIS projects each with different packages. I have setup the packages with configurations stored in a SQL Server table in MSDB. When I create the configuration on the second project it overwrites all of the first projects configurations. Is there a way to to get two different project configurations stored in the same SQL Server table Any help would be greatly appreciated. Thanks! If the package is up ...Show All

• Visual C# Threading

  Hi all, I have a code with a lock function called synchronize. This function synchronize data with a remote server. The function lock all the application untill it gets a reply from the server. Some time the server is busy of down and the reply takes a lot of time and my application is stucked. How can solve the problem using threading or another solution. Please help. Best regards... You don't want to implement ...Show All

• Architecture A good second book about architecture

  Hello I have finished "pro scalable application in .net 2.0" which was nice. Now I want to read another book about architecture. What do you recomend I think Domain-Driven Design: Tackling Complexity in the Heart of Software is a good option, do you know another Thanks. DDD is a good book - however it deals with a certain narrow aspect of architecture. I would recommend reading "Software Architecture in Practice&qu ...Show All

• SQL Server SSIS Package failing to disconnect?

  I am building a package that will be used to transfer data from Access 2000 to SQL 2005. For development purposes, the first thing I do is search for my SQL database. If it is there, I drop and recreate it. If I run the package once, it runs fine, . After that, I get the message that the database is in use and can not be deleted. I do not have Mgmt Studio open, so the only thing that could have a connection is the BI Studio. The only way I can s ...Show All