Lynette2's Q&A profile

• SQL Server Expanding All SubQuery Nodes In Reports

  Hi Everybody, I've got a report that builds out top level data and adds the plus symbol (+) for collapse/expand next to each of the rows for me to display a detail level tied to that record. The problem is when we do an export or print, it only applies to the top level instead of all of the detailed information. Is there a way to automatically expand all tree-nodes in a report for these subqueries Thanks in advance. Best Regards, Justin Thanks again for your quick reply - this forum is a life saver! I've got the visibility dialog up, but I'm not sure how to change it to 'Expand All'. Currently the Visibility radio button is set to 'Visible'. Is there an expression, or something els ...Show All

• SQL Server Software architecture

  The Sql Server 2005 Architecture is often described on Microsoft homepage and whitepapers and so on, but I didn't find an illustration or figure that describes the components and their dependencies. Has someone a good link for me SQL Server architecture refers to the internal components/features that make up the SQL Server product. I don't believe we have a single illustration or figure that represents the entire SQL Server architecture. You might start by looking at the architecture topics under this Books Online link: http://msdn2.microsoft.com/en-us/library/ms191135.aspx . Regards, Gail ...Show All

• SQL Server Easy way for users to add new members or measures?

  Hi I am wondering if there is an easy way for users to add new members or measures if the office dimension had a new office or if the user wanted to create a new calc I write enabled a dimension, but it had no effect in the BIDS or in Excel. I see the menu options change when browsing the write-enabled dimension in the BIDS, but "create sibling" and "create child" are disabled. I have full permissions and the criteria for those options to be enabled when writeback is enabled is met. But even if write enabling was working, does it update the source data From the books online, it seems like it would update dimension source data, but not measures or data points. which brings me to another question. Where do you en ...Show All

• Visual C# Shutdown.exe problems

  Process shutdown = new Process(); shutdown.StartInfo.FileName = "C:/WINDOWS/System32/Shutdown.exe"; shutdown.StartInfo.Arguments = "-s -f -t 20 -m \\deruu"; shutdown.Start(); I can get it to log me out using argument -l only, but with that I only get a "Frozen" cmd window titled "Shutdown.exe" and nothing happens. try this: Process shutdown = new Process("shutdown"); shutdown.StartInfo.WorkingDirectory = Environment.GetFolder(Environment.SpecialFolder.System); shutdown.StartInfo.Arguments = "/s /f /t 20 /m \\deruu"; shutdown.Start(); you may want to try to take out the /f switch just in case and see what happens, it could be the fact t ...Show All

• SQL Server Is there anything like rowid, rownum like in MySql and Oracle??

  Hi, i am new to SQL Server. I want to write a query where in i want to delete duplicate rows from a table keeping the master copy. If it is MySQL or Oracle we can write that using built in rownum or rowid. How to do that task in SQL Server 2005. Is there anything like rowid, rownum in SQL Server If not suggest me a way to do that ...aazad not exactally , but u can make use of 'TOP' or row_number() function.. select top 1 from table 1 order by column1 u can use top intelligently to get top/bottom nth row... given u have somethin to orderby ...Show All

• Visual Studio Express Editions Found new report tool for dot.net ... hope this helps again :-D

  well i found one more tool of interest.. times time it seams its high quality report tool... i found it at http://www.dotnetjunkies.com/ ... here is direct link.. now i have to try it with vb express :-D ... if someone tryes befor me (i'll be in position to try it in 10 hours or so... when i get home...) pleas post it here :-D this is direct link to the tool http://www.perpetuumsoft.com/Product.aspx lang=en&pid=21&tid=express ...Show All

• .NET Development Dataset Current Row Position

  I am programatically creating a dataset with a table and need to know the current row number I am on before doing something else so I can get back to it. I have no controls bound to this dataset/table and would prefer to do everything in program. In the old days of recordsets I just used to get the bookmark of the current record and then go back to that bookmark. I have searched and can't find how to do this and I know it is probably really simple. Thanks You may want to look at DataRowCollection.IndexOf(Datarow row) which is new for .NET 2.0. Given any row you can get it's position in the Rows collection by using myRow.Table.Rows.IndexOf(myRow). Asuming RowCollection hasn't been modfied via Ins ...Show All

• Community Chat New Windows Mobile Devices around 2007

  What are the Windows Mobile devices manufacturers (like HTC, Palm, etc.) will be releasing with Windows Mobile 6.0 around second half of 2007 I know it's too early to ask but I felt like asking my question since I have my BlackBerry 7290 for instant messaging, e-mail, etc. (didn't have a credit history) and my contract will expire around July of 2007. I'm an "early-adopter" when it comes to looking forward on what Microsoft has to offer. For me, I'd like to have a laptop-style PDA/SmartPhone with a large screen, but small enough to fit in a pocket. In other words, bigger than Palm Treo 700w/wx and Blackberry, as my thumbs are big and makes me make typos in my Blackberry; plus, it takes a lot of training for typing without look ...Show All

• SQL Server How to insert and split out Parent/Child from string

  Knowing that my @Tab table variable returns data for example like this: ProductID (bigint)   ChildIDs (varchar string of comma delimited IDs) -------------                ------------------------------------------------------ 106731                     105234,105235,105236,105237,105238 107889                     101238, 422635,167236,105237,105974, 230554 108990             &nb ...Show All

• Visual C# preventing SQL Injection in C# code...................

  I am building my first ASP.Net app from scratch and while working on the DAL I came across the problem of SQL Injection. I searched on the web and read different articles but I am still unsure about the answer. My question is should I add db.AddInParameter(dbCommand, "AvatarImageID" , DbType .Int32, avatarImageID); Add in Parameters to my C# code to avoid SQL Injection. What is the best practice. I am unclear if the stored procedure already helps me avoid SQl Injection or if I need the add in parameters in the C# methods to make it work. I need some help. Thanks, Newbie My C# update method in the DAL (still working on the code) private static bool Update( AvatarImageInfo avatarImage) { ...Show All

• Windows Forms Datagridview

  Can anyone correct this line: DataGridViewTextBoxColumn ocol16 = ( DataGridViewTextBoxColumn )dataGridView1.Columns[16]; ocol16 .value = "1"; < this line causes an error> See the class definition , it says that the DataGridViewTextBoxColumn object hosts a collection for cells. You cannot add values for columns , you add values for cells . ...Show All

• .NET Development Disconnected DataReader?

  Hello. I am using a DataReader to query a large database (millions of rows) and perform some upkeep on each row. Our DBA complains my app keeps a connection open and locks the database for a long time, and wants me to save the data internally, close the connection, then issue UPDATE commands. I am reluctant to do this, as the query could potentially return megabytes of data and I only want to access each row in sequence. What is the SQL-Server-friendly .Net way to step through a large query and potentially perform an update on each row Without knowing what is is that you are doing that requires you to update millions of rows by processing them one-by-one in sequence, it is difficult to provide an answer. ...Show All

• Visual Studio 2008 (Pre-release) Alpha blended video

  I have heard that WPF/E will support a new codec called WMV + Alpha. I assumed, therefore, that you could do alpha blended video in WPF. Unfortunately I have looked and looked online to try and find any video format that will run in windows media player which supports an alpha channel. I have some neat greenscreen test videos, that I can get into whatever format I need, but I can't find any. Does this feature, alpha blended video, work in WPF today If so what video format(s) can I use with this feature Is there an experimental codec I can download to at least start building my application Unfortunately, there are currently no plans to support alpha channel video in WPF v1.0. I also don't know of any ava ...Show All

• Windows Forms 3-tier architecture code sample for c#.net

  send me code sample for 3-tier architectrue in c#.net using sql server for insert,delete,update,find,select commands 2.what is meant for pooling If you are still looking for the n-tier architecture tutorial with source code and downloadable demo project, Please go through this article http://dotnetfunda.com/articles/article18.aspx Thanks ...Show All

• Smart Device Development binding

  i have to combo box in the form and there are binding to the same database and when i build it the program tell me they are two binding to the same database wht can i do in it......................... ...Show All