Search results for query: *

fillSchema is called before you call fill. What it does is get info like the primarykey. Use VS help and read up on it. ---- Gerry Roston gerry@pairofdocs.net

try: Dim ds As DataSet Dim da As New SqlDataAdapter("Select * from foo", cn) da.FillSchema(ds, SchemaType.Mapped, "Table") da.Fill(ds, "Table") ---- Gerry Roston gerry@pairofdocs.net

Where is Seq defined as the primary key? In the database? If so, did you first do a FillSchema or set the column to be the primarykey column? ---- Gerry Roston gerry@pairofdocs.net

Can you please post some code. I have code that does what you are trying to do and it works reliably. ---- Gerry Roston gerry@pairofdocs.net

The problem is that when a byte array is returned, its value is seen as <byte array., thus they all look the same! I do not remember my solution - I either created another column and used an integer as the key or I converted the byte array to a string and used it. Either way, the answer is not...

Great idea... But it didn't work. Something is major league screwed up. Not worth spending any more time on this - I'll solve the problem by pushing data from computer2->computer1 instead of pulling it. Thanks for your help. ---- Gerry Roston gerry@pairofdocs.net

wolluf, Thank you for pointing this out. Unfortunately, something strange is going on... When logged into computer1 using my user account, control userpasswords2 showed four passwords - 2 passport, one for my laptop and one for a server I am building. However, none for the other workstation...

I have two computers on my home network. At some point in time, I logged onto computer2 from computer1 using username1. Being lazy, I told the system to remember the username and password. Now, I want to log onto computer2 from computer1 using username2. What the heck should I do to get the...

It turns out that this is a bug in MS Word. If you have a table with an empty cell, you cannot use 'Select all <x> instances> to select those paragraphs. Instead, you must to a 'Replace All', finding the paragraph format you want and repalcing it with some other style. ---- Gerry Roston...

I am working on a document that I did not create. In the 'Styles and Formatting', I have selected to show only 'Formatting in use'. To update a document's formatting, I typically right-click on the format that I want to change, choose 'Select all <x> intances', then click the format to which I...

As usual, LV was right on target. Just one small fix: 'runat=server' needs to be added to the two <asp:button...> lines. ---- Gerry Roston gerry@pairofdocs.net

My guardian programmer comes through again! Thanks! ---- Gerry Roston gerry@pairofdocs.net

LV, I haven't forgotten about you - I just got pulled into 17 other things. I also realized a fundamental error with my approach - I was updating the underlying DB without giving the user the chnace to cancel. So, I am fixing this, having all changes be applied to a dataset object until the...

The solution was to delete the IDE device (in device manager) and reboot twice. ---- Gerry Roston gerry@pairofdocs.net

One answer, which may not be considered 'elegant' is to use dynamic SQL. This method seems to be working well for me. Another possibility, if the value beign checked is numeric, is to use an AND or OR in the SQL statement. For example, if SuperUser = 0x8 PowerUser = 0x4 JoeUser = 0x2 VirusUser...

Can't quite wrap my head around this one... Given a datagrid, based on an underlying DataTable, that has two Button Columns and several bound columns: <Columns> <asp:ButtonColumn Text=&quot;Edit&quot; ButtonType=&quot;PushButton&quot; CommandName=&quot;Edit&quot;></asp:ButtonColumn>...

Paszt, Thanks for the assistance. The answer was not exactly as you specified - in ASP.NET, the call Me.CreateGraphics doesn't get you anywhere as a Page object does not suport this method. What worked for me was: Dim objBitmap As Bitmap = New Bitmap(1000, 1000) Dim g As Graphics =...

I am putting together a new computer. After installing XP (and third party device drivers), all of my devices were present. In particular, both my CDRW and DVD/WR drives were present in the device manager. After installing all of the Windows updates, the DVD/RW drive is no longer in the device...

Sorry - small error in post - All of the methods I have seen for calculating string width depend on the Graphics.MeasureString method exposed by the PaintEventArgs parameter of a form or control's Paint event. ---- Gerry Roston gerry@pairofdocs.net

In my application, I get a string of data from a user. I need to determine the length of the string, because if it is longer than some predetermined length, I need to insert a carriage return so that it fits inside a fixed width box on a PDF form. All of the methods I have seen for calculating...