Search:

I believe I have finally found a fix for this.

Under Advanced databindings for the checkbox

Me.DataBindings.DefaultDataSourceUpdateMode = DataSourceUpdateMode.OnPropertyChanged

The value was...

This is not a datagridview. It is a dataview.

I have a checkbox that is bound to a dataview.

When I change the value of the checkbox and click a button, that runs through dataview.endedit, then the .update, it's changes are not saved.

I...

Is this an appropriate way to get these changes to save? :) Thanks




Dim i As Integer
For i = 0 To Me.dataview.Table.Rows.Count - 1

If...

I have a textbox bound to a dataview. The changes are saved when I delete from this textbox and I call .EndEdit then .update. However, when I delete from this textbox programmatically by calling...

Here's something crude dude. :)



If (ComboBox1.SelectedIndex + 1) / 2 = CInt((ComboBox1.SelectedIndex + 1) / 2) Then

MsgBox("HI")
End If

You could also create a separate form for your input box.

You'd have more control over what the user enters. Allowing for validation too.



Dim frm As New frmCustomInput
frm.ShowDialog()

And I understand all that, I kind of wish I could see some example(s) of how other people present the problem to their users. Especially as far as a GUI is concerned.

Like, pop a form comparing...

This has been a bit of a dilemma of mine.

There is a chance 2 or more people could be accessing a record at the same time. Although there is only a small chance, every once in awhile I'll have a...

Yeah, I just thought of taking the code from the designer.

The only reason I have to manually create this, is because the table I'm accessing is so large that it was constantly causing my...

I have a very large sql table that I need to build a manual update command for.

In visual studio, when you use a data adapter in the designer to create the update command based off of your select...

It turned out to be a sql data adapter. I don't know exactly why, but once I removed it I wasn't getting the hanging issues.

I'm guessing the table that I'm connecting to is way too large, so...

It doesn't look like it has anything to do with the On Load Events.

I commented out everything in there.

This time I got the Not Responding when I bound a text box to a dataset that were both...

I did try the same scenario in safe mode with the same results. Still hangs.

I will post my results using PerfWatson Monitor

I have just built a new PC and installed Visual Studio 2010 Pro.

This was also a problem on my old machine too, for Visual Studio 2005, and 2010; 2003 did not have these problems.

Everytime I...

Thanks, techgnome. I had searched for an alternative, and this would be why I didn't come up with anything.

Just wanted to make sure I was keeping with the times.

Thanks again!

My company has an app that was originally written in vb.net for .net 1.0. It is using a MS SQL 2008 database to access data.

I'm in the process of overhauling the app completely.

It uses sql...

I think that should work thanks! It feels like a Monday here

Okay, I added a module

Public dsPermissions As New DataSet

On my form:

Private Sub GetPermissions()
If Not GetConnection() Then Exit Sub

In my vb.net winforms application using Visual Studio 2010, I'm trying to work something out and my brain just isn't working today.

I'm rewriting this application to make it more efficient and...

Yep! Thank you!

Yes, this is the solution I was thinking about going with, I created one just like you said for a fax to email server I created, I was just wondering if there was something else that I wasn't...

I've searched google and I haven't found anything on how to find a file when you don't know the name of it.

For example, a file get's FTP'd to me, and I know it's going to be in the format like...

I'm trying to create a batch file to encrypt a txt file with OpenPGP.

I figured out the commands to actually do the encryption but it was always asking me for a passphrase, so I searched online...

None of those results describe where you find the utility so far, only how to use it. I'm through page 3 of google results.

But I'll keep looking.

Thanks

Hmm, no, I don't mean SSIS, we upgraded a couple years ago from 2000, and still have a ton of DTS packages, and haven't upgraded any of them to SSIS.

I recently wiped my computer, installed the...

I don't have DTSRUNUI installed, or at least I can't find it.

I'm running MS Sql Server 2005, but need DTSRUNUI to build command line to run dts packages from a job.

Where can I get DTSRUNUI? ...

I'm new to asp.net and C# really, mostly just done windows apps in VB.net.

Also, trying to move from Crystal Reports to SSRS.

I found some code to render a SSRS report as a pdf. But this is...

Nevermind, don't know how I missed this.


local(i).StartTime

Is there a way to check how long a process has been running? I'm using the below code to check whether these programs are running.

Is there a way to see how long they've been running?

...

Question:

Were your Update, Delete, and Insert queries generating automatically?

Auto-generated statements will only be created if the data source has a primary key.

I'm probably missing...

Perfect..... CBool(e.NewValue) = )

Why is this code having the opposite effect? If It's checked in the checkedlistbox it's not check in my view, if it's not check in my checkedlistbox it is checked in the grid.

EDIT: More...

Wouldn't I have to build my query dynamically too? In which case I wouldn't really have to set up parameters, I could just build my query string as needed.

If a = true then
String =...

Yeah, That sounds right...

The queries are exactly the same.


UPDATE Company
SET CompanyName = @CompanyName, GroupNumber = @GroupNumber, CompanyWebsite = @CompanyWebsite,...

No, I've double and triple checked the spelling.

Catches - "Must declare the scalar variable "@CompanyName"."

Here is more code, I have several of these, it will go through and hit on the...

Yes it meets. It doesn't it remove it though, on executenonquery it says it expects scalar variable "@companyname"

I'm trying to remove a parameter from my Update Adapter, and I can not get it to work.

I found some code on these forums to do it but I can't get it to work. What am I doing wrong?

...

How do I do that? When I got into the Advanced databindings properties, it asks for the default null value but it's a blank string.

So that's what's getting inserted into my database on updates....

Private Sub TextBoxHandlers()

For Each c As Control In Me.Controls
If TypeOf c Is TextBox Then
AddHandler c.DataBindings(0).Parse, AddressOf Textbox_Validate...