Larry Baker's Q&A profile

• SQL Server What is faster: DataReader or DataSet or something else?

  Hi, I need to read 250,000 records and show this information. I am using DataReader and it takes 8 seconds. I need to raise it to 0.8 seconds atleast. What is faster: DataReader or DataSet or something else Thank's Alexei DataReader is much faster than DataSet. Actually DataSet is populated using DataReader object. I guess in your case the bottleneck is in the amount of data you transfer to client application. Try to reduce the row size you send to the client (don't select columns unless they are required). Another way is to show only portions of data as the user typically doesn't need to have the whole data list available. ...Show All

• SQL Server How do I force new databases to be created on another drive on same server?

  I successfuly installed SQL Server 2005 Enterprise Edition today (on the first shot!) but can't figure out how to force new databases, etc to be created on another drive on the server. SQL installed on the c: drive (I had no choice!) but it is a very small partition. I need to install Sharepoint Portal 2003 next (on a different server) and want to make sure everything goes on the other drive. Help me, please!! Thanks :-) As far as I can remember Sharepoint let you choose the destination of the data files. Anyway the default data directory can be changed in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Micr ...Show All

• Visual Studio 2008 (Pre-release) silent install

  I need to deploy just the indigo components with our product. I have grabbed the indigo.exe from the winfxsetup.exe. Is it possible to run indigo.exe silently The command line help states to use "/Q" for silent, but this does not work. I have been able to extract the .msi and associated files from the .exe and run it silently by calling the .msi directly, but i would prefer to distribute the single exe and call it silently, directly. Can anyone help Thank you! Daren I can't provide a firm date at this point when the guidance will be made avaiable, though I expect it will be well enough ahead of RTM to give our c ...Show All

• .NET Development 64 Bit Local Debugger on Whidbey FINAL

  Will the local debugger on VS.NET 2005 FINAL RELEASE be able to debug 64 Bit apps Remote debugger sucks a little bit. Thx in advance Martin  Jochen -- You are actually still using the remote debugging infrastructure under the hood even though you are remote debugging to the same machine. This is because VS is a 32-bit application in Whidbey. However, as you have noted, they do a good job of hiding it and in my debugging using VS it seems to work pretty well. The major omission being no edit and continue on 64-bit projects is however a CLR limitation. Most applications however correctly run as agnostic code, in which case if ...Show All

• Visual Basic Threading not working as expected (using a COM class in a BackgroundWorker)

  Hi, I've written a COM server class (KCAMSERVERLib.Camera) to remotelly control digital cameras from the computer through a USB cable. I'm now in the process of writing a simple GUI for it, and I've chosen VB2005 for that purpose. Some actions, like "Shoot()"ing a picture, take some time so I added a BackgroundWorker object to my VB project to run them in a separate thread. The problem is that the GUI still freezes during shooting, like it all was run in the same thread. I post here a simple test that shows this behaviour: Public Class Form1 Dim Camera As New KCAMSERVERLib.Camera Private Sub Form1_Load(ByVal sender As Sy ...Show All

• .NET Development Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

  It is my understanding that when using a TableAdapter and selecting the proper options, Insert, Delete and Update statements are generated. The Update statement should work just using the following: myTableAdapter.Update(changes); Where changes is the DataSet containing the modified data. This logic works great for one of the tables in the DB but not for another. Learning this new stuff is Confusing at best - Frustrating at worst. Help appreciated, Michael Check the Update, Insert, Delete command of the myTableAdapter, and check the query statement of all of them. TableAdapters are created for only ...Show All

• Visual C# aligning check

  Problem: a table with 2 columns: a columns of label and a column of textbox. Now in the second column i'm adding a checkbox. Problem: how to align it to textboxes The check has a little border that you can see when you check it. Isn't possible to enable it Thx You can set the CheckBox.CheckAlign property to align the check mark on the control. ...Show All

• Visual Studio Express Editions Less than, greater than, equal to, date.

  Trying to get this to work. I'm trying to prevent saving over a new version of a file. I've tried >=, <=, and =. I'm guessing that I can't compare dates like this. Bryan Dim MyStamp As Date = FileDateTime( "bay.txt" ) If FileDateTime( "bay.txt" ) >= MyStamp Then ' execute code here End If ok sorry i have tried this and it worked fine for me and i were able to compare two dates Module Module1 Sub Main() 'creat a file first Dim mystamp As Date = FileDateTime( "text.txt" ) Console.WriteLine(mystamp) System.Threa ...Show All

• Visual Studio Express Editions I want the registration keys of vb 05 and sql express

  Hi, i am sorry for my bad english, but i hope that you will understand my problem with the registration of this producs i installed vb express and sql server express on my pc... i maked the register product.... i created a personal account with passport and i recived 2 mail from microsoft, the first with the link of confirm product registration, and the second mail with the compliment for the registration thi for both software but i don't have the key! and if i click over help-->Register product... he send me in internet where i can see the home page with the registration confirm.... a frie ...Show All

• Visual Studio Express Editions Blurry image after e.Graphics.ScaleTransform (Zoom)

  (I have already tried e.Graphics.SmoothingMode=Drawing2D.SmoothingMode.None in several places) The program in question uses GIF images that contain certain patterns and shapes and enlarges them during the e.graphics print page event. Using print preview's zoom, it is clear that the patterns and shapes have blurry edges and look slightly lighter in color. Printing looks less than optimum because of this. Looking at the original GIF file in the MS Paint program max zoom, shows crisp edges and darker colors. Here is everything in the program I can think of that relates to the graphics in question: (BTW, all the pen drawing I do afte ...Show All

• Smart Device Development Problem displaying panels in vs2006 vb.net 8.0 ---Bug???

  I am having more strange behavour. I can run a couple of programs with no problems, and then turn around and run another program with some copied code and it behaves different. When I try to display a panel, sometimes it works, and sometimes it does not. The code to display a panel is below, and I set debug on the line paneltoshow.visible = true. After that line runs in debug, the value is False even though the value paneltoshow.left is changed to 0 on the next line... Public Sub ShowPanel( ByVal PanelToShow As Panel) If PanelToShow.Name <> "pnlEnterPass" Then CurrentPanel = PanelToShow End If 'Hide all of the Panels p ...Show All

• Windows Forms Securing a Database Connection String

  Hello.  I am developing a WinForms application that will be deployed using No-Touch deployment.  I am implemeting this via an application stub which uses Assembly.LoadFrom to load the main application.  I want to make sure that no one can read the database connection string.  I don't want to put it in the app.config file beause the file is do ...Show All

• Visual C# IE Browser Helper Object (Plug-in or toolbar)

  Hello All, I have just started to learn Visual C#. Could you kindly let me know if there's an easy way to develop toolbars or plug-ins for Internet Explorer (and, if possible, even for other browser like FireFox, Opera, etc.) in Visual C# Thank you in anticipation, rohit505 HI, In a different thread they gave you a link to an article for an IE toolbar in VB. By reading that article, I discovered that the code was translated from another article in C#. Here is the link for that one: http://www.codeproject.com/csharp/dotnetbandobjects.asp select=1113574&df=100&forumid=3788&noise=1&am ...Show All

• Windows Forms Problem with access database in vb.net

  Hi, Iam doing a vb.net project with ms access database. Iam facing a problem with this piece of code. ---------------------------------------------------------------------------------------  qry = "UPDATE tbl_users SET password='" & txtPwd.Text & "' WHERE user_id=" & gUserId                 Cmd = New OleDb.OleDbCommand(qry, Conn)        ...Show All

• Visual Studio Express Editions VWD activation

  Can anyone give me the url for obtaining an activation key In order to obtain an activation key that is valid for your machine/installation, you need to start the activation process from within the product.  Go to Help -> Activate and select the Register link. ...Show All