|
Build a dll you import into all your projects.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
As CG said, create a class project, put all your utility snippets in there and reference it from every project.
The only problem with this is my util never stays the same for long enough to create a DLL. Housekeeping this DLL can be a major job, otherwise it just continues to grow. I moved from VB to C# last year and had to rewrite all my utilities and DAL, one of the best excercises I have ever done, shrank by 40%.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I've never managed to create a DLL that I could "references". I have managed to create DLL's which I could use by explicitly importing them at run-time (hardcoding the path to the DLL) but that seemed really incredibly icky. I'm using a mix of VS2005 and VBex2005; I'd probably just use VS except that I have VS set to one color scheme and VBex to another; if I could set different projects to different color schemes, I'd probably just standardize on VS, but I've asked repeatedly how to do such a thing and never gotten any response.
To be sure, the DLL's I've created have been in straight C rather than C# or VB, but I'm still wondering what step I'm missing.
Otherwise, I wonder if there are any good utilities which can take some source files and aggregate all the stuff that matches, flagging anything that doesn't. Merge all identifiers within a module or namespace that have identical definitions; for classes without control definitions, merge everything but fields. For control definitions, prompt the user for what to do about mismatches. Do any such handy tools exist?
Also, you say you go in and clean up your multi-purpose project periodically. How do you ensure that nothing breaks when you do that?
|
|
|
|
|
i am wondering if you are over thinking it. Grab everything that you think other apps would benefit and just move them into a class-library project (dll). All the name spaces that you have created (if any) still exist. You might need to add references to system libraries that natually come with a windows application (drawing/window.forms/etc). In your windows app, reference the new dll and import the new dll in your form or whereever else you need it. Same code that worked in one project now works spanning another project with the benefits of intellisense, etc(lose that at run-time load assembly).
Nothing breaks --> to verify all projects are compatiable with the changes made in your new shared dll, just create a "master" solution and add all projects in there. make your changes and then compile the master solution and if successful...you know at least syntax wise all is compatible...
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
Yup - do what Larson said, this really is a simple excercise.
I have no idea what VBex is so I can't comment on it but VS C#/VB allows you to simple make a class library project, compile it and reference it in other projects.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I am using following code to populate dataTable and then updating Access Table. I am getting error "OleDbException was unhandled" "Syntax error in INSERT INTO statement.
Any help would be appreciated.
Thanks,
Aman
<br />
Private Sub dataGridAccess()<br />
<br />
Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AccessFile<br />
Dim myConnection As OleDbConnection = New OleDbConnection<br />
myConnection.ConnectionString = connString<br />
myConnection.Open()<br />
<br />
<br />
Dim myTable As String = "RealTimeWQActual"<br />
Dim myCmd As String = "Select * from " & myTable & " ORDER BY sdate"<br />
' create a data adapter <br />
Dim da As OleDbDataAdapter<br />
Try<br />
da = New OleDbDataAdapter(myCmd, myConnection)<br />
Catch ex As Exception ' Catch the error.<br />
MsgBox(ex.ToString) ' Show friendly error message.<br />
End Try<br />
<br />
MsgBox(myTable & " " & myCmd)<br />
''Dim dr As New OleDbDataReader<br />
' Create command builder<br />
Dim CB As OleDbCommandBuilder = New OleDbCommandBuilder(da)<br />
' create a new dataset <br />
Dim ds As DataSet = New DataSet<br />
' fill dataset <br />
da.Fill(ds, myTable)<br />
' Insert code to populate the DataTable with rows.<br />
' Set the DataSource and DataMember of the DataGrid control.<br />
DataGrid1.SetDataBinding(ds, myTable)<br />
<br />
Dim dt As DataTable = ds.Tables(myTable)<br />
Dim rrows = dt.Rows.Count<br />
MsgBox("rrows= " & rrows)<br />
<br />
' NewRow to create a DataRow.<br />
Dim row As DataRow<br />
row = dt.NewRow()<br />
<br />
' Then add the new row to the collection.<br />
row("SDATE") = "1"<br />
row("STIME") = "1"<br />
row("Parameter") = "1"<br />
row("Value") = "1"<br />
row("d1") = "1"<br />
row("d2") = "1"<br />
<br />
dt.Rows.Add(row)<br />
'**** error comes at the next step ***<br />
da.Update(ds, myTable)<br />
'**** Program runs without the previous step and dataTable shows the added row<br />
myConnection.Close()<br />
<br />
<br />
End Sub<br />
|
|
|
|
|
I am guessing you need to provide the adapter with an insert statement ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Here I used ACE.OLEDB.12.0. for office 2007-Access [accdb] But I want you to use Jet.Oledb for office 2003-Access [mdb]
Dim Ithuva As String = "Samples To Aman"
con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\sample1.accdb;Persist Security Info=False")
con.Open()
Dim CmdTxt As String = "Insert into address (city) values ('" & Ithuva & "')"
Dim cmd As OleDbCommand = New OleDbCommand(CmdTxt, con)
cmd.ExecuteNonQuery()
con.Close()
|
|
|
|
|
Do you have any primary keys defined for the underlying table?
If you don't OleDbCommandBuilder will not work.
|
|
|
|
|
I am trying to find a program in Visual Basic that will list all open windows on a computer. I am trying to activate a window based on it's title bar. I've looked up EnumWindows and GetWindow for examples but I am running into problems with the code I find (it doesn't work). I'd like to find some code that does. I have a intranet website that shows customer info and i'd like to activate a window based on the number they called. I want to call this program with a variable that will bring a window to the forefront based on that variable. Any help you provide would be most appreciated.
Thanks for all the help
NewbieDave
|
|
|
|
|
I don't know that you can enumerate windows on a client, from the server.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
You cannot enumerate windows on a client machine from a web server.
|
|
|
|
|
I did note he was saying it was on an intranet, that's why I assumed he may not be totally insane. But, even then, I'm pretty sure he can't do it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
We just installed the Cisco Unified communications system and we can have a web display that shows customer info based on thier phone number. I'd like the end user to have a dual monitor setup so that the customer info shows up on one screen (web display) and on the other would be a windows program for entering info about the customer. So it sounds like I'd have to have my program resident on the users computer, pass the program the customer info then populate the web display from the program while it also enumerates the correct program. Does that sound possible?
Thanks for all the help
NewbieDave
|
|
|
|
|
It sounds like you want to not use the web at all, and just write a program that runs over the internet.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi all,
I have a datagridview on a form. I have a subroutine called LoadReloadProcs that has this line in it
Me.dgvProcs.Columns(0).Width = Me.dgvProcs.Width * 0.75
This is the line where the error's happening. I'm getting an objectdisposed error.
Funny thing is, it'll run through this routine twice without reporting an error. It only reports the error when I come back from running a report. Also, if I put a breakpoint right there and use the immediate window to check the value of the width (i.e., ? dgvProcs.Columns(0).Width) the system tells me that it is 100. But if I try to assign a value to the width (i.e., in the immediate window dgvProcs.Columns(0).Width = 435) the system throws the object disposed error.
Why would I be able to request information of an object that is disposed? I shouldn't be able to, right? Or if it is not disposed, which being able to query the value of something suggests, why can't I assign a value to that property?
This has me really confused.
I've put the code for the procedure below... I don't see anything in there that helps me understand, but I figured one of y'all might. Also, I've searched for "dgvProcs.dispose" and just for ".dispose" and didn't find any relevant to dgvProcs.
Private Sub LoadReloadProcList(ByVal strsql As String)
Try
'Me.Controls.Remove(dgvProcs)
Dim daMyList = New SqlCeDataAdapter(strsql, myDB.cn)
Dim dsMyList = New DataSet
daMyList.Fill(dsMyList)
Dim myBinding As New BindingSource
myBinding.DataSource = dsMyList
Me.dgvProcs.DataSource = myBinding
Me.dgvProcs.DataMember = "Table"
Me.dgvProcs.Columns(0).HeaderText = "Name"
Me.dgvProcs.Columns(0).Width = Me.dgvProcs.Width * 0.75
Me.dgvProcs.Columns(1).HeaderText = "Barcode"
Me.dgvProcs.Columns(1).Width = Me.dgvProcs.Width * 0.15
Me.Controls.Add(dgvProcs)
Catch ex As Exception
#If DEBUG Then
MsgBox(ex.Message)
#Else
MsgBox("There was a problem gathering information on your previous procedures. If this problem persists please contact your distributor.")
#End If
End Try
End Sub
Thanks in advance for any help you can give.
Denise "Hypermommy" Duggan
|
|
|
|
|
You have a DataGridView on your form that YOU called dgvProcs. So, obviously searching the Internet for a name that you made up is going to be pointless.
The error message says that you destroyed the dgvProcs object and now you're trying to use it. The line that you commented out in your code snippet would do that if it wasn't commented out before. Me.Controls.Remove(dgvProcs) would detroy the dgvProcs object.
|
|
|
|
|
I'm not so confused that I searched the internet for dgvProcs. I searched the code. Sorry I didn't make that clearer... I guess I just figured it was obvious.
And yes, if that line weren't commented out I can see that it would do it. But that line's been commented out the whole time and I'm still getting the error. It's really wierd.
Denise "Hypermommy" Duggan
|
|
|
|
|
No, there could be no more references holding on to it.
The other thing, that i didn't see earlier, is possibly the columns being wiped out and rebuilt after the data bind.
And, of course, the possibility of having to Clean the project, then rebuild.
|
|
|
|
|
Clean the project and rebuild? I'm afraid I don't understand. There's still a lot of tools in Visual Studio that I'm learning... is "clean" one of them?
I do appreciate the assistance, believe me!
I ended up finding a workaround... I noticed that if I clicked OK on the messagebox that informed me of the error, the system went on ahead and built everything and all looked and acted okay. So what I did was just put a separate catch block in there to catch just the object disposed exception and swallow it up and ignore it. That done, everything appears to work fine. Of course, the "solution" makes me a bit nervous as ignoring exceptions is probably not the safest thing to do.....
But maybe it gives a clue to one of you gurus that says what's going on... 'cause this is still too weird to me.
Denise "Hypermommy" Duggan
|
|
|
|
|
Hi Dave,
Dave Kreskowiak wrote: Me.Controls.Remove(dgvProcs) would detroy the dgvProcs object
I'm not with you here. Who would be doing the Dispose?
Are you saying ControlCollection.Remove(x) actively calls x.Dispose()?
(I can't see that in the doc)
or x being removed becomes collectible? from the code dgvProcs is a class member, so this reference is still alive.
Couldn't the problem be that by setting a new DataSource the Columns[] collection got lost?
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hello everyone,
I have a UserControl, I inserted inside a MenuStrip and a Panel.
This UserControl must be a Panel, when do I upload controls, inserted controls, must be entered panel I inserted in the usercontrol. 
Sorry for my poor English, I hope my problem is clear.
Thank you 
|
|
|
|
|
eusta wrote: I hope my problem is clear.
Not in the slightest. I have no idea what you're trying to say.
|
|
|
|
|
|
No, it's not... I still have no idea what your on about.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
