tackett's Q&A profile

• .NET Development OleDb database

  Hi, there is a way to retrieve the counter field value of an MS Access database after inserted a record A general insert query like this: Insert Into SAMPLETABLE(Code, Description) VALUES('aaa', 'description aaa') After execute it, I need to known the value of the counter field. In SQL Server is: SELECT @@IDENTITY In MS Access Thanks There is one thing you have to take care of here. You need to take the value of the counter that the spec ...Show All

• Windows Forms Problem with vertical scrollbar in virtual mode

  I encountered a very disturbing error. First the initial situation: The application displays data in a datagridgrid. The amount of this data can vary from 40 to 14000 datasets depending on the users selections. The data itself has to be processed in very specific manners so that I have to use the virtual mode. The height of the rows depends on the data in the row. So there are different heights in the datagrid. The problem: The display of the da ...Show All

• Visual Studio 2008 (Pre-release) Is the pseudo SQL syntax necessary?

  Current LINQ syntax is like this: var upperLowerWords =         from w in words         select new {Upper = w.ToUpper(), Lower = w.ToLower()}         where w.StartsWith("a"); But I think that this is unnecessary breeding of C# with SQL. I believe that combination of methods with lambda calculus would be better: string[] words = { "aPPLE", "B ...Show All

• Visual Basic Process.Start unable to recognize < elemet.

  I'm tring to pass arguments to Process.Start function, but some problem occured. Process.Start("xyz.exe","-a <C:\project\abc.txt") After I execute the above function, it the xyz.exe just hang as it just read until -a, and somehow ignore the "<" element. Is my code correct or this function do not take "<" as part of the input argument Thanks. Lennie This thread is merged and tracked at: http://for ...Show All

• SQL Server Pause between pages when printing RS report

  I am using Report Services on SQL Server 2005. I have a report that gets its data from a single SQL Server stored procedure. One other small table is used, but only to provide a list of values for selecting a parameter value to send to the stored procedure. On the report I use a list control to display multiple records per page. When printing the report (which currently produces over 500 pages - future printings of this report will not be nearly ...Show All

• Visual Studio Team System How to suppress instrumentation of dependent projects?

  I have a solution with several projects: web application, web service, library dlls, etc.  In my case, I have one library dll that I do not want instrumented (I'm only referencing a small portion of the code).  However, it appears that if you choose, via the testrunconfig, to instrument one project output then all dependent libraries are also instrumented, even if they are not checked. I would like code coverage to be pe ...Show All

• Visual Studio 2008 (Pre-release) DLinq Sql Tracing

  Hi, I have been looking through the documentation and cannot identify a convenient way to trace (log) out the sql being run under the covers. I have been looking for an event on the DataContext, but to no avail. What would be a good approach to accomplish this Thanks   Mirko To see the SQL, use the following line. db.Log = Console .Out; I have posted a sample that I used in my PDC demo including the line a ...Show All

• SQL Server Warehousing Data From Multiple Companies: What do I need to learn about?

  Hi All, I know very little about this stuff, can anyone tell me what technologies I need to read up on and issues that I may encounter I created an ASP.net/SQL Reporting Services 2005 Budgeting/Forecasting/Reporting Intranet website for a middle market non-profit client (Financials on Great Plains/SQL Server 2000). The response has been quite favorable and I’m looking to leverage it for other clients. Often my client base is ...Show All

• SQL Server Errors during building project with Deployment utility and configuration file

  I am getting following error when "CreateDeploymentUtility" is set to true and I try building the solution. It tries to copy a file that already exits in \bin\Deployment folder.  I am using Sept. CTP. If I set "CreateDeploymentUtility" to false, there are no errors since it doesn't try copying the file. Any reason why this happens Error 1 System.ApplicationException: Could not copy file "C:\test\Source\ETLProcessing\PackageProje ...Show All

• Visual Studio Local help not available in VS2005 TS RC; please help.

  I am having a (for me) the serious problem that the local help in VS2005 does not display any .NET content. Using VS2005 TS RC1, but the same happend before with VS2005 b2. - only Help on Help and Refactor show up in the index. - dynamic help and F1 help with standard VB code give no results - in Tools, Options, Environment, Help, I have 'try local only' - I cannot use online help, because it's way too slow for me here I suspect that some ...Show All

• Visual C# datasets -- hiding passwords from user's view

  I have a dataset that has 6 columns. Two of these columns contain passwords. I need to use these passwords for FTP purposes, but I would like the user to see only "****" when they run the program. How can I do this ~Lauren I quite don't understant the context. Is the dataset bound to a DataGridView ...Show All

• Visual C# overheads involved with events

  I've tried to search for answers to this question but there are just too many results being returned on google etc that are totally unrelated. I want to know what overheads are involved when an event is fired, I'm currently working on a dynamic TreeGridView (thanks to Mark Rideout for the code on his site, it's helped me get started with this). Each row is related to a service in a service structure in a database, number of services ranges from ...Show All

• Windows Forms Cursor related with color

  I got a problem, i got this expression so far:  if(mousePoint.X == 1 ...  How can i relate the mousePoint.X = 1 with a color in that coordinate.  Like when a color appear in the coordinate 1;1 a messageBox will apear.  I dont know how ...Show All

• Visual Studio Express Editions Is Visual Basic 2005 Express interpreted or compiled?

  I have looked through a lot of literature, but it seems difficult to find a clear answer to this question. I can see that VB generates P-code, which is interpreted and therefore executes much slower than compiled languages, but some literature indicate that it may be possible to compile the P-code and generate a fast executing program. C is a terrible language so I am looking for a good, strong alternative, but in practice it seems that th ...Show All

• Visual C++ Running a program?

  I have built a program on calculating the area of a rectangle as the user inputs the length and width. It works fine, however, my question is. If I want to send it to someone, what files from the whole folder do I need to send (.zip ). Also, how will they be able to run it, without a compiler. I can easily run it from: C:\Documents and Settings\Peter\My Documents\Visual Studio 2005\Projects\optut\debug however, as I've seen other progra ...Show All