Search:

Thanks for clearing that up guys.

Hi guys, I'm trying to connect to a SQL server using windows authentication but keep getting "Login failed for user xxx ". I should point out that the user I'm logged into the machine with is not the...

hey mate, not sure if I'm doing something wrong, but I'm getting the below message appear.

Overload resolution failed because no accessible 'join' is most specific for these arguments.

Hi guys, I need to do some string manipulation but not really sure how to go about it.

I have a string that is read from a database that typically looks like the below:
Windows Server 2003,...

Cool thanks guys.

Hi guys, how would I go about counting the number of characters in a string after say, character number 7?

For example, if my string is ABCDEFGHIJKLMNOP

I want to count the number of characters...

Thanks mate, but where would I place that code?

Hi guys, I am trying to use a variable for the path to my database but am not having much luck with the syntax.

So I open my datasource and click on "Edit dataset with designer". I select the...

It was set to "system.string". I changed it to "System.DateTime" and now it sorts correctly! Thank you so much jmcilhinney! And to everyone that offered help.

Hey tech, that code I posed is attached to a button I was playing around with. I do not format or do anything with the data itself. As I said, I added a datasource, pointed it to my access DB and...

I don't have anything that deals with "sorting" - it's set to automatic. I click the header and it sorts....

If it read the cell values as dates instead of strings, then I would expect that to...

The table columns within the DB are configured as data type: Date/Time. If I open the database I can sort those columns by "newest to oldest" or "oldest to newest" and it sorts correctly.

Hey mate, I am not adding columns programmatically, the columns, and data are directly bound to the database. I effectively added a datasource, pointed it to my access DB and then dragged it to my...

Hey guys, I have a datagrid which is bound to an access database. The database and datagrid has 4 columns.

The third and fourth columns contain dates. All the values are taken directly from the...

OK, so setting the AutoSizeColumnsMode to "fill" does the trick.

Hey guys, I have a datagrid with 5 columns. All columns are resizable except the last one. The problem I'm having is that when you shrink one of the columns it drags the last column away from the...

Thanks mate, that worked. Also clears things up for my understanding.

Hey guys, I've got a datagrid which has 9 columns and typically contains anywhere between 10 to 50 rows. The last column is a checkbox which allows the user to tag that row for later use.

What I'd...

Hi guys, is there a way to get a list of installed Windows updates on a remote machine?

The below powershell code does the trick but don't know if there's a way to do this within VB?
...

Hi guys, I have a datagrid with 5 columns, the last column is an unbound image column. I'd like to show an animated gif in this column but it seems that the standard imagecolumn doesnt handle...

OK, so I got it going using the below code - might be helpful for someone out there....


Using ts As TaskService = New TaskService
' Create a new task definition and assign...

Hi guys, is there a way to launch the Task Scheduler "Create Task" window and have some of the fields pre-populated?

So I'd like to be able to have a button that says "Schedule Job", which then...

By refresh I mean rebinding the datasource.

As for my problem, I managed to sort it out using a try catch (maybe not the best or most elegant, but does the job)

And for the scroll position I...

Hi guys, I have a datagrid which starts off blank and slowly gets populated as processes execute. It also refreshes every 5 seconds using the timer.

The problem I have is, after it refreshes it...

Thanks mate, works perfectly!

Hi guys, I have an unbound datagrid with 3 columns; Name, Location and checkbox.

What I'd like to do is prevent the checkbox from being checked if the value in the "Location" cell (of the same...

For anyone else that may be interested, the below code allows you to do it.


Dim tokenHandle As IntPtr
Dim userName As String = "username"
Dim password As String = "password"
...

Hi guys, I'm trying to read a value in the registry from a remote computer. The problem is that I need to pass alternate credentials from my own, and have no idea how to do that.

The below code...

Yep, correct. A message stating that "John" already exists would be great.

Name is their first name (ie. John, Mark...).

Which list are you referring to? DG1 or DG2? I can add the same name multiple times - but this is what I want to prevent. Once I add the names to DG2,...

Hi, DG1 has 4 columns; name, surname, location and checkbox. DG2 only has 1 column; name.

I mark checkboxes against the names I'm interested in and the above code copies only the first column...

Hi guys, I have 2 datagridviews, the first is bound to a DB and the second is unbound.

I use the below code to add the rows with a checkbox from DG1 to DG2, however I need to prevent it from...

How embarrassing, you're right, the last row was blank! Oops, but thanks!

OK, so using the below code I avoid the primary key issue (not sure why it works now as I tried it before, maybe had a typo somewhere). Anyway, I'm still getting that last empty row. How can I fix...

Yep, that is the reason I'm getting that error. If I remove the primary key from that table it works, but the ID numbers have duplicate values and it seems it's also copied the last empty row of...

OK, so I made some progress and got the records from table1 into table2. However, I'm now getting an error when I run it a second time. And I think it has to do with the automatic ID column.

How...

Hi guys, I have an access database with 2 tables. Both tables have the same fields, except that table1 gets wiped every time the program starts.

So I need to have all the records from table1 added...

Leary, thanks for the timer tick event hint, that might do the trick. Will give it a try.

Paul, FileSystemWatcher sounds promising too. Thanks for the suggestion.

Hi guys, I'm still quite new to VB and programming in general so need some help.

I have a datagridview which is bound to an access DB. The access DB is updated by another program and I'd like to...

Perfect! Thanks for all your help Kevin!