Search results for query: *

I have a spreadsheet that I e-mail daily to internal staff. It has a lot of conditional formatting which change the cell background colors. All the colors and formatting have e-mailed fine. This month, I started a new spreadsheet. All coloring looks fine in the workbook, but e-mailing the...

It is set at 85. Here is the script that I got from it: ALTER TABLE [dbo].[DCO_Sessions_P] ADD CONSTRAINT [PK_P_DCO_Sessions] PRIMARY KEY CLUSTERED ( [Operator_ID] ASC, [Sys_Num] ASC, [Logoff_Time] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF...

I am by no means an expert DBA. We have a table with 6 million records. It has 4 indexes. One is a clustered primary key (consisting of 3 columns) and the other 3 are non-clustered on one column each. If I reindex the table, the fragmentation goes down to near zero on all 4 indexes...

All the servers and the workstations are set to Auto.

We have a large number of Windows NT servers. Each server is a separate LAN. If I connect a workstation's CAT5 directly to Server A, it will show up on that server's network quickly. If I do the same with Server B, it takes up to 2 minutes and sometimes will time out. I connected the...

Yes, inverting the colors. I have considered capturing a screenshot and inverting the resulting bitmap. I had hoped the application itself could be inverted so a user could still use it rather than having an image of the application displayed. But this may be my only option. Unless there is...

Hello, This may sound a bit strange, but I am trying to reverse the video of everything on the monitor. Or at least reverse the video of my application. I had hoped there would be a display setting or monitor setting where I could just reverse the video. Setting color properties in code is...

In Visual Basic .NET is it necessary to pay attention to the layout of member variables? I know in C++ the order in which you declare your variable can have an affect on the amount of RAM used. This is because of byte alignment and padding. Example: Dim b As Byte '1 byte Dim i As Int32 '4...

I figured it out. I have some ManualResetEvent variables. One for connecting, one for sending, and one for receiving. When each of these operations completed it would do a Set() to signal the main thread it was done with that part. I wasn't re-initializing these ManualResetEvent variables...

In a socket class I have a method which essentially does this: Declares a new socket Does a BeginConnect to connect to server (waits for connection) Sends data to the server (waits for send to complete) Receives a response from the server (waits for response to complete) Shuts down the socket...

I seem to be having trouble programmatically changing the SelectedIndex of a listbox after a Drag/Drop has completed. I have a source listbox and a target listbox. I click the left mouse button over an item in the source, hold the button down, then drag to the target and release. The code to...

I need to move data from one table to another. The two tables have identical structures. Obviously I can use: INSERT INTO Table 2 SELECT * FROM Table 1 However one column needs to change. Is there a way to plug in this new value during the INSERT INTO statement or am I stuck having to update...

It's ASCII code 0 (zero) which is a null. Even though it is 15 characters, there may fewer than that with any real character in it. I've resorted to iterating over the char array when inserting into the DB and also interating over the char array when reading back from the DB.

Take a look at the System.Version class. It has members Major, Minor, Revision that you are probably looking for.

Yes, I tried iterating through the char array and make a string builder. That worked and I insert it into a database, but then when I read the data back from the database from a different application, I get the same result. When I do a DataReader.GetString, it shows "Example when I hover the...

There are several parts where I use ReadChars. Sometimes it's Int16 afterward. Sometimes Int32. Sometimes another ReadChars.

No the debug window shows: Example However if I hover the mouse over the variable I get: "Example Then when I look at the debug window after closing the app it shows: ExampleThe program '[blah blah]' has exited with code 0 (0x0). Even with writeline it's not doing a CRLF. Maybe I need to add...

It is: 12343254Example

I am currently reading information from a binary file. Whenever I do a ReadChars on the binary reader, I do not get a closing quote. For example (br is the instantiated BinaryReader): Dim tData1 As Int32 = br.ReadInt32 'Works Dim tData2 As String = br.ReadChars(15) 'Get 15 characters tData1...

I figured it out. I needed to create the BinaryReader with the correct encoding... Dim br As New BinaryReader(stream, System.Text.Encoding.ASCII) That gives one byte per char.