Ron Gliane's Q&A profile

• Visual C# StreamReader and File Position

  I'm processing large binary files. These are PCL files, and I'm looking for page boundaries. I want to store the position of each Form Feed, which in PCL is decimal 12, hex 0C. However, that byte can also exist as part of a raster or other binary structure. So I loop through the file, and when I find a "12", I read ahead 14 bytes to compare them to a known string. If I get a match, I know the 12 was a real Form Feed, and I store it's position in an ArrayList. This works fine using a FileStream object and its ReadByte() method and .Position property. The problem is it is very slow. I'd like to use a StreamReader to take advantage of buffering ...Show All

• SQL Server Data Flow limitation?

  I have a unique situation where I need to process 40 mb (100,000 rows) worth of data from a flat file and order the data by a key and place it in SQL server table. My problem is that SSIS data flow processes data in batches defined by BufferSize and BufferMaxRows and I cannot seem to process 40 mb worth of data ALL AT Once. Ie. My flat file has data that is in fixed width. First column includes id such as AA, BB, CC. These rows are not orded in the flat file. So I use Conditional Split to order the rows, however, since SSIS buffer is not large enough to process all the rows at once, it takes first 10,000 rows orders them, then next ...Show All

• Visual Studio Tools for Office Implement Drag & Drop from taskpane to Excel/Word

  Is possible to implement Drag&Drop from a control in action pane in a cell of Excel or Word Thnks ...Show All

• SQL Server Sql Server 2005 -- Select permission denied

  We have a web app that accesses Sql Server 2000 using windows authentication. We recently installed SQL Server 2005 on a new server and are in the process of porting the data from SS2000 over to 2005. I expected some problems, but I've run into something that seems like it should be relatively simple to solve, yet I have been banging my head against the wall for a couple of days.  After changing the connection string in web.config of the web app to point to the new SQL Server 2005 database, I keep getting ... SELECT permission denied on object 'tUser', database 'GDoc', schema 'dbo'. &n ...Show All

• Visual C# How do you change the value of an already created cookie?

  Below is the code I'm currently using on my login page to save the username and password. I'm going to later encrypt it but for now I'm simply setting it.  HttpCookie UNcookie = new HttpCookie("TheUsername",txtUsername.Text); UNcookie.Expires = DateTime.Now.AddYears(1); HttpCookie PWcookie = new HttpCookie("ThePassword",txtpass.Value); PWcookie.Expires = DateTime.Now.AddYears(1); Response.SetCookie(UNcookie); Response.SetCookie(PWcookie); The code works great the first time I run it. If I go back to the page I am presented with the information that was saved.  If a new user logs in on the same machine and acct, the ...Show All

• SQL Server Continued DTS support with what SQL Server Version/Edition

  We currently have access to another department's SQL server.  However they are taking that server offline within a few months, and we will need to migrate our data and DTS packages to a new solution before then.  We have about 30 databases and 20 somewhat simple DTS packages, but only a few users need access.  Funding is very tight. SQL 2005's support of DTS is somewhat of a mystery to me.  Docs state with 2000 Enterprise client tools installed + Express edition, that I can run DTS packages on Express edition.  But the docs do not state the procedure for doing so, and I cannot register the Express server in t ...Show All

• Visual Studio VSS with Visual Studio .NET 2003 Professional

  I have got Visual Studio .NET 2003 Professional, but the Source Control is not activated. What is the best way to get VSS installed, and am I licensed Hi Richard, VSS 6.0d does not come with VS .NET 2003 Professional. It is only included in VS Enterprise editions, on a separate CD. If you want to use VSS with VS Professional edition, you'll have to buy VSS Standalone product. Alin ...Show All

• Visual Studio Express Editions Trying to connect VB.net Express to SQL server express

  I'm having a problem connecting a vb.net express program to sql server express. I'm connecting using the Data Source Configuration wizard. This is what I know, In vb.net express edition, you have to connect to a local SQL Server. Second you have to use the Windows Authenication option inorder to connect to a mdf file. And last that User Instance=False. However I'm still getting the error "Unable to open the physical file "C:\Test.mdf" Operating system error 32: "32(The process cannot access the file because it is being used by antoher process."). In SQL server I create a login using the same signon name as ...Show All

• Software Development for Windows Vista Making Persistent State Machine WorkFlows

  Hi I am a beginner in the Workflow foundation. I have made a workflow using state machine workflow. Can any one pls help me to make the workflow persistent. I need to store these values into the DB and then retrive it when the app user logs back into the application any help would be highly appreciated thanks in advance Bala Hi Bala, There are samples regarding using Out Of Box SQL for Workflow persistence and Custom file persistence. If you have installed Windows Workflow Foundation you will have to run the sql scripts for OOB SQL which should be located at - C:\Windows\Winfx\v ...Show All

• .NET Development How to get column names from a dbf table

  Dear all, I am a newbie in this field.Can someone tell me how should I get the column names of a DBF table . Plz help me in this regard Anil Dhiman Here's some VB code to do it: Imports System Imports System.Data Imports System.Data.OleDb Module Module1 Sub Main() Try '-- Download and install the latest VFP OLE DB data provider from '-- http://msdn.microsoft.com/vfox-pro/downloads/updates/ Dim conn1 As New OleDbConnection( _ "Provider=VFPOLEDB.1;Data Source=C:\;") conn1.Open() '-- Lets create some data to work with Dim cmd1 As New OleDbCommand( _ "Create Table Te ...Show All

• Visual Studio Logon Failed for runtime oracle connection for Crystal Report - VS 2003.

  I'm getting a Logon Failed message when trying to view a web page with a crystal report embedded..   The error is: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. I'm connected to an Oracle 9.x database to design the report using MSDAORA provider, Data Source U50DAMC_LINDA (as defined in my tnsnames file) I've attempted to add the login details to the report as shown below. ReportDocument rpmWorkloadDoc = new ReportDocument(); string reportPath = Server.MapPath("tctoRPMWorkloadReport.rpt"); rpmWorkloadDoc.Load(reportPath); rpmReportViewer.ReportSource = rpmWorkloadDoc; // Declare required variab ...Show All

• Windows Forms ArrayList troubles

  Broadview : when i edit a value within my arraylist, the value does not stay changed, it behaves almost as if it were changed only within a certain scope. I have two structures :     Structure materials         Dim name As String         Dim id As String         Dim amt As Short      ...Show All

• SQL Server Is there a seperate forum for PTS9?

  Dear Anyone, Can anyone please direct us to forums that discusses the new PTS9. We've encountered some problems with it and we would like to confirm if its maybe a limitation or a bug. Anyone Thanks, Joseph Is this is about Analysis Services 2005 OLEDB provider (aka PTS9) Feel free to post your questions here. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights ...Show All

• Visual Studio Express Editions Slow screen redraw

  I am in inexperienced programmer who has an application that displays many (50-60) controls on a form. The application is a production planning system, that requires many controls displayed on screen (1 for each job qued on individual machines) Whenever the form is re-draw, it is painfully slow, I have set the doublebuffer ControlStyles etc, but are unable to fix the issue. This issue is running on a P4 2.8GHZ / 500MB PC. Can anyone assist I have attached an example of my problem (not my actual application, but the samle gives the same issue). The sample simply displays many controls onto a form. When you force a redraw ie ALT ...Show All

• Smart Device Development Transparent Shapes?

  I'm trying to make the shapes I draw on top of picture semitransparent. Here's what I've got: //create rectangle Rectangle rect = new Rectangle (0, 0, this .pictureBox1.Width, this .pictureBox1.Height); //draw ellipse e.Graphics.FillEllipse( new SolidBrush ( Color .FromArgb(50,255,255,255)),rect); ***I get the following error: Error 2 No overload for method 'FromArgb' takes '4' arguments. Does the function not work for Windows Moble Please help. Pete M This particular overload is not available on NETCF. You could use another one, e.g.: Color .FromArgb((A << 24 ...Show All