|
I added a "Discard Unsaved Changes" button to my form.
I want to loop through all the Bindingsources on my form and do a .CancelEdit() on each one in order to discard the changes. (If this is even the way to do it)
Dim BS as new System.Windows.Forms.BindingSource<br />
<br />
For Each BS in ???????<br />
BS.CancelEdit()<br />
Next
I need to get some sort of a BindingSourceCollection object at the ???'s, how do I do this?
(Visual Studio 2005)
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
There is no seperate BindSources collection on a form. It's a control, just like any other. You have to go through the form's Controls collection and find them.
For Each c As Control in Me.Controls
If TypeOf c Is BindingSource Then
Dim bs As BindingSource = DirectCast(c, BindingSource)
' do whatever you want to the bs object...
End If
Next
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi, Thanks for the help.
Dave Kreskowiak wrote: If TypeOf c Is BindingSource Then
The above line generates a syntax error stating:
Expression Type: 'System.windows.forms.control' can never be of the type 'System.windows.forms.bindingsource'
Any ideas?
you can't forget something you never knew...
"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann
|
|
|
|
|
Whoops! My bad. I made a stupid assuption about BindingSource. It won't work because BindingSource doesn't inherit from Control.
No big deal. When you create your BindingSource objects, add them to your own collection. Then you have them all in one place.
Dim bindList As New List(Of BindingSource)
.
.
.
bindList.Add(BindingSource1)
bindList.Add(BindingSource2)
.
.
.
For Each b As BindingSource In bindList
' do what you need to do to your BindingSources
b.whatever...
Next
End Sub
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I added the line I need from an old .NET 1.1 project Inherits System.ComponentModel.Component so that I can drag the SPs onto the component and have everything typed correctly as well as spelled correctly but it isnt working. Is there a new way to do this in 2.0??
Cleako
|
|
|
|
|
Define "isn't working". The Component class is still there are works the same way it did in previous versions of the Framework.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
When I go to add a new item, both in the App_Code and in the project itself, it isnt showing.
Cleako
|
|
|
|
|
If you add the Inherits Component line to the class header, this adds the default implementation of the IComponent interface to your class. It doesn't automatically make it a control with a design surface.
What are you trying to create with this? A new control? You might want to inherit from Control instead, which automatically includes inheriting from Component. It also provides the default implementation for IDropTarget, among others.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I want to drag and drop stored procedures onto the designer so that I dont have to worry about user error with types and parameter names.
Cleako
|
|
|
|
|
You mean, you want to drag and drop an SP on YOUR COMPONENT and have the SQL code generated for you?
IMHO, the worst way to do it. The best, and easily supported, SQL code is written by hand, not by the designer.
I've never done it with drag and drop, other than to play with it, and I remember quickly abandoning it because it put objects and code crap all over the place in the form code. Precisely where it didn't belong.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Not the SQL code itself I just liked that it laid out the parameters for me that were already present in the pre-written stored procedure. Also, the only thing I used the component class for was for that purpose so it only contained DB calls and I wrote all of the code myself other than the Parameters.Add stuff.
Cleako
|
|
|
|
|
Well, you can try inheriting from Control and see what happens. I, personally, don't like the idea because of the extra crap your class has to deal with that it will never use, just so you can have some code written for you.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Are you saying you dont use wizards?
Im not a big wizard user myself but I do use a couple of the code generating options such as the drag and drop stored procedure. Ive noticed that many places on the net only show you how to do things through wizards.
What would you recommend for the data access class anyway? Ive seen some examples where the data access class just contains the Open and Close connection methods as well as the execute stored procedure methods and all the of the information is passed in from somewhere else. My experience has been to put all of the code the data access class uses cmd.Parameter("Name").Value = "Name" explicitly instead of a generic loop that adds the parameters. What do you think?
Cleako
|
|
|
|
|
cleako wrote: Are you saying you dont use wizards?
Never. I write all my database code by hand. I get far greater control and it's much easier to support.
cleako wrote: Ive noticed that many places on the net only show you how to do things through wizards.
You won't find that here.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I think I'm missing something very simple:
vb.net 2003, windows xp hmmmmmmm code description:
get the next jpeg file in a file listbox
display it in a picturebox i.e. picOther1.Image = Image.FromFile(sPath)
print it
move the file to another directory
next jpeg file...
The problem is I can't move the jpeg file because it's still in use. How can I close the file or disassociate the picturebox image from the file.
I've tried leaving it until all are printed (could be a couple of hundred) but still not able to do it.
Anybody...
Bruce 
|
|
|
|
|
try:
if not isnothing(picother1.image) then
picother1.image.dispose()
picother1.image = nothing
end if
|
|
|
|
|
Don't use FromFile to load the picture. This locks the image file open for the life of the Image object that is created by it. See this[^] KB article for a workaround.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave
thank you, that's just what I needed.
Bruce 
|
|
|
|
|
Hi,
I am running vs 2003 and uploading a user defined excel sheet into an asp.net web form (vb.net code). The sheet consists of 21 records with about 50 columns. The problem is that I have the datagrid on a DIV tag for scrolling. But when you scroll it is painfully slow. Can someone suggest how I can do this so it won't be slow. Thanks.
|
|
|
|
|
A DIV tag tell's me this is an ASP.NET app. You have no control over the scrolling speed of the web browser. ASP.NET code runs exclusively on the server-side, generating HTML for the client. It's up to the client how to render the page image.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Yes it is an asp.net app with vb backend. So there is no way to make this run faster on a machine something. It is an internal application that is running terribly slow on every machine that I have tried including mine.
|
|
|
|
|
liona wrote: So there is no way to make this run faster on a machine something
No. There is nothing you can do in your code to speed the scrolling up. Once the browser has the page, that's it, your ASP.NET code is no longer running.
You said it was 50 columns wide?? Try providing another method of narrowing that down. If there's one thing I hate about web pages, it's scrolling side-to-side to read information on it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have created two files using .Net Setup wizard and they are:
1.)Setup.exe
2.)MyProject.exe
Now which one of these two i should double click to install my .exe file.
|
|
|
|
|
The Setup.EXE will also come with an .MSI file. Both files must be in the same directory for the installation to work. All you do is double-click the Setup.EXE to launch the install.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i created a classLibrary in vb.Net 2005.Now i want to refer this to vb 6.0 for which i have to make .tlb file.
in vb.Net 2003 we create .tlb file very easily, but i dont know how i create it in 2005
if some one have any idea so please help me
its very urgent!
Thanks
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
