Search results for query: *

I need help with getting just one row of a subtable for each entry in the main table. For example, let's say I have: Applications ============ AppID AppName 1 Open Office 2 Paint.Net 3 Firefox Contacts ======== ConID AppID ContactName 1 1 Bill Forbes 2 1...

I have a database that has a central table called applications, joined in a many to many relationship with three other tables, contacts, vendors, and servers. I.E., an application can be installed on multiple servers, or multiple applications can be installed on one server. The same goes for...

Hi, I screwed up the data in one field in a database, but I had just done a backup prior (ain't THAT dumb!). Anyway, I restored the backup to a RESTOREDB database on the same server, now I want to UPDATE the original table with the restored values for that field, linked by the identity ID...

Hi, I'm using VB.net 2008 and SQL 2008. I've got a SQL data source that works fine, but I need to get the column names from it so that I can fill a drop down. But there's no "table" element in the data source, and nothing else that I can see that would give me the column names. The data...

I found a solution for it. I change the selectcommand on the SQLDataSource to get only the fields that the user selects and rerun the select statement. I changed the definition of the gridview to autogenerate the columns, and took out the pre-defined columns. So after I rerun the select...

That's just the kind of thing I need, but the problem is that in VS 2008, the datasource doesn't appear to expose a tables collection (why the heck not?!?!?) So I need to know how to do it in VS 2008. But seriously, thank you ErnstJan!

All, In VS 2008 I have a gridview attached to a SQL 2008 datasource. It works perfectly, of course. I have an area on the form to let the user select the columns that are shown. I've tried updating the select statement, but when the user removes columns they don't want, the gridview throws...

Hello, We've got a parent and several child domains running Windows 2003 native mode. We have a 2003 enteprise root certificate authority in the parent, is it possible for me to create a subordinate enterprise certificate authority in one of the child domains?

We have a Windows 2003 SP1 server that has been operational for a couple of years. We recently installed Windows Updates on the server, and after it rebooted, it cannot connect on the network. Pinging anything from the server, you get "destination host unreachable". I've verified the IP...

I have Vista home premium running as my primary DVR at home. I also have digital cable with a cable box with a cable card. I want to marry the two of them together, so I can watch my digital cable on my Vista hi-def system. Does anyone know of a cable-card compatible tuner for Vista...

I've joined a 2003 domain with SUSE 10.1, no problem. Just ensure that you use the fully qualified domain name (like microsoft.com) instead of the NetBIOS domain name when you enter the domain name. Make sure you have DNS properly set up. Also, when you're prompted to enter credentials for an...

Hey, I just installed SUSE linux 10.1 on a Dell GX270. THe install went sweetly, but when it came up, the X window system is overscanning the monitor. That is, it is using too high of a resolution and refresh rate, so the monitor can't display it. I can boot to the Failsafe mode and login as...

OK, I found the answer. The class IS working, it's Microsoft's own tool that wasn't reading the value correctly. Damn, the thing works fast!

Hi, I've got the following code, designed to query, stop and start a remote Windows service. It comiles happily, and runs nicely, with the status label changing dutifully as you hit stop or start. The problem is, it doesn't actually touch the remote machine - the status label doesn't reflect...

Okay, now I feel like an IDIOT. I knew about how page load works, and I knew to check for page.ispostback before initializing controls, but I DIDN'T DO IT! Doh!!! Thanks for giving me back my brain cell, LethalPacifier! [2thumbsup]

I've got a form, which has a ton of fields. I am NOT using data binding. I programmatically create a data adapter and load the values into a table, then populate the fields on load. When the user clicks save, I gather the data from the fields and generate an UPDATE command and use a...

Hi, I've got a PC with Media Center 2005. I'm trying to map a drive to C$ on the PC, but I can't. What happens is I get prompted for a password, even if I use "connect with another user name" and supply a valid local username and password on the media center PC. Obviously I can resolve the...

I have the following code, which is part of a project where I need to move the mouse to a specific location when the user performs an action. When I run it, I get: PInvokeStackImbalance was detected A call to PInvoke function 'TestApp1!TestApp1.Form1::mouse_event' has unbalanced the stack...

...initialize the page here Dim DS As New DataSet Dim Con As New SqlConnection("data source=SQLSERVER05;initial catalog=DB02;user id=*;pwd=*") Dim Adap As New SqlDataAdapter("SELECT * FROM ArticleCategories", Con) Con.Open() Try Adap.Fill(DS...

We have hundreds of servers, and we started looking at one due to reported performance problems. We found a high number of TCP connection failures. But we checked about a dozen other servers with no reported performance issues, and they too have high TCP connection failures - at least some of...