|
Assuming the forms you want to search are currently open, then you can use the Application.OpenForms collection[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Some are opened, some are not
|
|
|
|
|
I'm not quiet sure if I understood the question in the right way.
I suggest :
You iterate through the Application.OpenForms-collection to get the Forms of your Project.
This collection return you a Form. Inside each Form you iterate through the Form.Controls-collection and look for your control.
modified 23-Jun-15 4:40am.
|
|
|
|
|
How can i use freeze Pane for first row in excel by vb.net using EPPlus.dll for excel.
|
|
|
|
|
From the ExcelWorksheet object, access the View property. On the returned ExcelWorksheetView object, call the FreezePanes(row, column) method, passing in the row and column of the first cell which is not frozen.
For example, to freeze the first row, you would need to pass in 2 to the row parameter:
sheet.View.FreezePanes(2, 1)
One of the samples on the site demonstrates this:
https://epplus.codeplex.com/SourceControl/latest#SampleApp/Sample6.cs[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks it's work 
|
|
|
|
|
how i can get data to text box and i replace to my list view like transaction on POS thanks pleasehelp us
|
|
|
|
|
Not a good question at all.
We have no idea what you mean by "get data to textbox". It could be as simple as MyTextBox.Text = "something" but we have no idea what your actual problem is.
As for the rest of your "question", it doesn't make any sense at all. More detail is going to be needed to figure out what you're trying to do.
|
|
|
|
|
Currently I'm using VB6 and Crystal Report 10 as my report Designer.
I can connect VB6 and Crystal report and view the report from access database.
My challenge is, I want to filter the report and view a specific data, for example, I want to view Employees that were employed between a specified date range (eg between 01/03/2014 - 31/12/2014)
And also a specific employee (by Name) Date of employment
from access database.
How can I do this ....?
Please Help.
|
|
|
|
|
You need to apply a filter to the Crystal Report - this book chapter[^] will point you in the right direction
|
|
|
|
|
Hello !
From vb.net , how can I detect if a database with a specific name exist or no in SQL server ?
Thank you !
|
|
|
|
|
SELECT * FROM sys.databases
|
|
|
|
|
Hi
I am relatively quite new to programming.
I am working in my job with configuration of applications which are database driven (oracle)
THere are times where we need to automate the excel reports etc from the database. There i need to understand how to code automate the excel reports using visual basic.
Can someone recommed a good book which covers everything to advanced.
REgads
|
|
|
|
|
Don't know why someone down voted this question, countered!
What you need is VSTO, visual studio for office, this search [^] may help with resources.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello !
In a vb.net project , I have a lot's of images that are imported into Project Resources.
Thinking that these may increase the size of the exe file , is there any possibility to move in a separate file outside the main .exe ?? ( Or I'm wrong with this idea ?)
Thank you !
|
|
|
|
|
If you are going to separate them from your executable, I'd recommend to put them into a resource-file, in a separate assembly.
The end-result would be the same as when you added them to the executable, with the minor diffrence of the overhead of an extra assembly. You'd need to load the thing to access the resources. If they are application-resources that are often used, then they'd be needed anyway. The size won't change, whether they are in a separate file or in the executable.
I do recommend using resource-files; and do use the generated and type-safe access that visual studio provides. Not only does it structure resources, it also makes internationalization easier, since your resources can vary by culture, defaulting to, well, the default culture of your design.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
So , do you think is better do this or not ?
and if yes , where can i read some more information ?
Thank you !
|
|
|
|
|
satc wrote: So , do you think is better do this or not ?
I don't think, I provide you with options - you think about what fits you best 
Adding it to an external resource only makes sense if you don't require it each time the application runs. If it is required, then it is part of the application footprint and will end up in memory, with or without overhead.
satc wrote: where can i read some more information ?
Resources in Desktop Apps (MSDN)[^]
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
As I've said in my first post , this resource contains a lot's of images that are used on different forms or reports.
But of course , not all forms are open every time when the program run.
|
|
|
|
|
A form can have its own resources; in fact, when you create a form in Visual Studio, it will also create a resource-file for that specific form.
If you are using the same image in multiple forms, then it would be preferable to have them in a single place, and not duplicated over all the resource-files.
Since we're talking about a few kilobytes worth of text and pictures, I'd say that the memory-footprint is negligible.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello !
I have a vb.net that use Entity Framework and SQL server database.
On your opinion , is there any way to mimic the role of Windows's Recycle Bin on this application ?
so anything I can do with file on recycle bin , I want to do with records in database ( I mean Delete , Restore , empty recycle bin...).
If yes , what would be the best way ?
Thank you !
|
|
|
|
|
That's relatively easy: You would have to have a field like "Deleted" in every entity which gets set to true when the user deletes an entity first. In all your queries you add a condition "where Deleted=false" unless the user explicitly wants to see the deleted entities. And eventually a user can "empty the recycle bin" where you actually delete the entities which have Deleted=true with the EF method ObjectContext.DeleteObject(entity) (or with direct SQL). Alternatively to "Deleted" being a boolean field you could make it a nullable DateTime field like "DeletedDate" where null means that it's not deleted and otherwise the date of deletion.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Hello !
It seems very easy reading your explanation.
But I don't understand very well the "Empty Recycle bin" idea.
Could you write some code to illustrate this ( I mean , the model may have 100 entities. How can I delete all the object from all entities that have "Deleted=True".
( I'm using DBContext with Database First ).
Thank you !
|
|
|
|
|
There's no way to delete all entities (with "Deleted=true") regardless of their type with a single "command" (unless you create a stored procedure for that in which case the "trouble" would just be moved there).
Options:
1) Via the context (pseudo code):
entities1 = context.Entity1.Where(e => e.Deleted).ToList()
foreach(entity in entities1)
context.DeleteObject(entity)
context.SaveChanges()
Not beautiful because of code repetition.
2) Via the context with reflection:
find all entity types in the context
foreach found entity type
dynamically build a query like above (1) and run the query
foreach found entity
context.DeleteObject(entity)
context.SaveChanges()
No code repetition but considerably more effort.
3) Via direct SQL:
You would have to have a list of all table names in the database (could be obtained via the information schema).
foreach(tableName in tableNames)
context.DataBase.ExecuteSqlCommand("DELETE FROM " + tableName + " WHERE Deleted = True")
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Use your tools to generate code. You have SQL, it can generate a statement.
It sounds as if you are using Sql Server; that means you can query which tables exist in your database. That means you can write a SQL-query that constructs a SQL statement for each entity.
SELECT 'DELETE FROM ' + [TableName] + ' WHERE Deleted = 1' FROM SYS.TABLES Copy and paste the result into Sql Server Management Studio, wrap it in a transaction, and execute*.
*) might wanna check the syntax, did not verify it in a IDE.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
