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...
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]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.