Identifying empty Active Directory attributes
Tue, 12 Feb 2008 16:32:08 -0000
Hi
I am trying to extract user data from Active Directory and locate it in an
offline Access database for reporting. The problem I have is when I came
acrsoss an object where an attribute is empty.
I tried to trap this with an isDBnull call (as below) but this does not
work - is it possible to identify null ...
|
a really basic question, that has me stumped!!!
Mon, 11 Feb 2008 08:11:44 -0000
Hi,
I am use to working against SQL Server databases, but now am trying to
connect to a basic Access 2007 accdb I have my my local dev machine.
I know I have not kept up with the latest technologies, but there seems to
be a few to many ways to connect, OLEDB, ADO, ADO.net, RDO etc...
What I want to kno ...
|
How do I view my data?
Sun, 10 Feb 2008 14:25:10 -0000
Hi
I have the following code to dump data from an AD search into a datatable.
This all appears to work fine, but my question is, how can I actually SEE
the data that is being placed in the rows? I can't seem to be able to figure
that bit out!
Thanks!
JB
' CREATE DATA TABLE AND COLUMNS
...
|
Repeating a stored procedure
Sat, 9 Feb 2008 12:11:01 -0000
Hi all
Still trying to get my head around VB.Net/ADO.Net and have a question.
I can't work out how to 'process' a stored procedure multiple times.
In other words, in VB6/ADO I would do something like:
For i = 1 to 10
rs.Open "usp_Stored_Procedure '" & i & "'"
....process the results
rs ...
|
Our new website
Fri, 8 Feb 2008 15:15:21 -0800
This website is for artist, freelancers, programmers, writers, translators. All who is looking for work.
If you are a skilled professional use page "Add profile" to create your profile.
Also this website is for those who is looking for skilled professional.
If you are looking for a professional use page "Pr ...
|
Dataset
Fri, 8 Feb 2008 12:52:45 -0500
Hi!! I am having issues retrieving a dataset and populating it into a
GridView in Visual Studio.
Below I posted the code.
I am getting a pilot ID from a Combo box and then storing it in the variable
id and then using it on a second query where I retrieve a Dataset based on
the SQL query and it should populat ...
|
Excel Automation
Tue, 5 Feb 2008 08:54:46 -0000
Hi
Try as I might, I am finding it very difficult to obtain some Excel
automation examples using VB Express (2008).
Does anyone know any good resources that will help?
Many thanks
Shane Clark
...
|
|
|
if database table changes
Mon, 4 Feb 2008 11:31:37 -0800 (PST)
hello all, thanks for reading.
i am trying to find a better way to keep track of changes in a ms sql
database table.
we have a ticketing system in the office, and a small app was written
to display a count of all outstanding tickets.
this is achieved by sending a "select count(rowName) from tableName"
qu ...
|
Manipulating data from table....
Mon, 4 Feb 2008 14:51:58 -0000
Hi
Firstly, let me just say that I am almost a complete VB newbie and that I've
been given a project by the 'powers that be' that I have no idea how to
complete but I'd really like to give it a go.
I need to extract data from a table (I can do this easily enough) but I need
to store it somewhere and then ...
|
insert a lot of data from tableadapter (vb2005)
Mon, 4 Feb 2008 11:46:27 +0100
I have to insert a lot of rows from a tableadapter to a sql table.
The operation is slow because table adptert send a single insert command for
each row.
Is there any way to have it with only one batch command? Or a faster
solution?
Thank you
Alessandro
...
|
