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

...is to use an AND or OR in the SQL statement. For example, if SuperUser = 0x8 PowerUser = 0x4 JoeUser = 0x2 VirusUser = 0x1 One could do SELECT * FROM foo WHERE (@myUserType | 0xe) = 1 To pull all users except VirusUsers. Please accept my apologies for C syntax for the hex numbers... ----...

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...