|
how can we generate data report in visual basic and hw can we have the print of it
|
|
|
|
|
This can be considered - http://www.vbtutor.net/vb6/lesson40.html[^].
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
|
|
|
|
|
|
I have a task that is being repeated throughout the application many times. My goal is to take those methods and consolidate it into a Global method.
The problem I am running into is that each task uses a different class type.
My thoughts were to create a method, say IncrementLine(), passing in as a parameter an Enum that would tell it what class it is coming from (Rooms or Library for instance).
This is an example of the existing code from one of these methods: (Also this is the exact code I need to change to bring back different classes, instead of RoomData it could be LibraryData - instead of Room it could be Library)
Dim lstRooms As List(Of RoomData) = Room.LoadAllForLibrary(libraryID)
The code for each of my methods that call IncrementLine() have their own classes like RoomData and Room. With the exception of the code above the rest of the method codes are identical.
Without using a bunch of Selects to determine what Class I should use..how can I return the proper class based on the enum passed in?
I was thinking of maybe using a Generic Delegate Class..something like this:
Public Function ReturnClass(Of t)(ByVal _lType As ListType) As t
End Function
based on what enum value they place it would send back the correct class..however, once I created this class I realized I'd still have to do a Select to determine what ListType they provided.
So my question is, how can I change the code above to be dynamic in returning the proper class based on the enum?
Thanks
|
|
|
|
|
sir;
i think that you need to use Type.GetConstructor() to return an instance of the appropriate type.
Good Luck;
Help people,so poeple can help you.
|
|
|
|
|
Another alternative would be using the Activator, as described here[^].
I are Troll 
|
|
|
|
|
Good alternative, Sir. 
100 ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Help people,so poeple can help you.
|
|
|
|
|
I agree great solution, thank you both for the time on this.
|
|
|
|
|
Hi all,
I have a database where the data contains some special chars.
I retrive the data from the dbase (dbf) file with a sql statement and write it into a text file using vb.net.
When I write the text file some of the special characters are not written the same way as in the dbf file, its written as a box.
I'm using:
<br />
Using sw As StreamWriter = New StreamWriter(dbfFile, False, System.Text.Encoding.Default)<br />
while writing to text file.
I'm not sure how to read the exact data from the database.
Is there a special way to do that???
Thanks in advance for anyh suggestion and help.
|
|
|
|
|
if you want to use characters outside the ASCII set, you need either a specific "code page" (not my recommendation) or 16-bit characters (Unicode).
what field type are you using in the database? it should be nvarchar or ntext in most databases for Unicode.
and then better specify Encoding.Unicode explicitly, both when writing to and reading from the database.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
he wrote about dbf (dbase) files ... no nvarchar, only fixed size char fields. in dbf files, the application has to take care of the correct codepage (you can nearly write everything in a dbf char field, except the 0 char).
I cannot remember: What did I before google?
|
|
|
|
|
The linefeed(LF) character is written as a box.
If i have a line feed, i want to ignore it...
ie; ignore only (LF) and not CRLF.
Thanks for any solution.
|
|
|
|
|
You have a solution to this - the ReplaceControlChars sub does this.
It also replaces chars such as tabs (i.e. any control char)
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
The only valid measurement of code quality: WTFs/minute.
|
|
|
|
|
Hello David
Hope you are doing good.
Yes, I know that ReplaceControlChars sub does it, but, its a case where a description contains a LF in between 2 words.
And we found that its an error on the dbf file a line feed should not occur inbetween 2 words in a particular field(column), where as a blank space is allowed inbetween 2 words and once the LF is been removed, the application works fine.
Thanks a lot for the reply.
|
|
|
|
|
hi
how find window lock time and unlock time?
Private Sub Command1_Click()
Shell "rundll32.exe user32.dll,LockWorkStation", vbHide
End Sub
this coding using for locking the windows system.
but i need lock time(ctl+alt+del)
thks
|
|
|
|
|
|
Your code would have to be running on the machine already. Like the other reply stated, you'd have to register for notification of the lock. Windows does not track the lock and unlock times itself, so your code would have to record the times when they happen.
|
|
|
|
|
Hi;
Im using the code wrote by "Dennis Austin" in the link below
A New Task Scheduler Class Library for .NET[^]
Im tring to create new task but I faced an error said : "Object reference not set to an instance of an object".
at line :
t.ApplicationName = "chkdsk.exe";
The whole sub that im using :
//Get a ScheduledTasks object for the local computer.
ScheduledTasks st = new ScheduledTasks();
// Create a task
Task t;
try {
t = st.CreateTask("D checker");
} catch (ArgumentException) {
Console.WriteLine("Task name already exists");
return;
}
t.ApplicationName = "chkdsk.exe";
t.Parameters = "d: /f";
t.Comment = "Checks and fixes errors on D: drive";
t.SetAccountInformation(@"THEDOMAIN\TheUser", "HisPasswd");
t.IdleWaitMinutes = 10;
t.MaxRunTime = new TimeSpan(2, 30, 0);
t.Priority = System.Diagnostics.ProcessPriorityClass.Idle;
t.Triggers.Add(new WeeklyTrigger(6, 30, DaysOfTheWeek.Sunday));
t.Save();
t.Close();
st.Dispose();
Plz help;
|
|
|
|
|
Put your code in Code block
BTW which line throws the error Object reference not set to an instance of an object? Put Trace in code & run & then tell us.
|
|
|
|
|
The error appear at the bellow line :
t.ApplicationName = "chkdsk.exe";
!!!
|
|
|
|
|
You got that error because t is Nothing, or NULL. You're trying to assign a value to a property on an object that's doesn't exist.
Your could is ASSUMING you got a object back from the CreateTask line above it. You have to check to see if you got a valid object back from that line before you start assigning properties.
|
|
|
|
|
Noticed late.
Your code is in C#. This is VB forum. Please ask your question in appropriate forum(C#) always.
BTW wait for this time, Don't post a duplicate one in any other place.
|
|
|
|
|
Yes, my code is in VB.net
but im using C# coz the origin topic by "Dennis Austin" was in C#.
Here is my code: (I indecate the error line by '>>')
Dim st As New ScheduledTasks(PC.Trim)
Dim tsk As Task
tsk = st.CreateTask("ReportTask")
>> tsk.ApplicationName = "Reports_Manager.exe"
tsk.Parameters = txt_Parameters.Text.Trim
tsk.Comment = txt_TaskName.Text.Trim
If rbtn_anotherPC.Checked Then
tsk.SetAccountInformation(txt_UserName.Text.Trim, txt_Password.Text.Trim)
End If
t.IdleWaitMinutes = 10
t.MaxRunTime = New TimeSpan(2, 30, 0)
t.Priority = System.Diagnostics.ProcessPriorityClass.Idle
Dim i() As Integer = {31}
tsk.Triggers.Add(New MonthlyTrigger(10, 30, i, Now.Month))
tsk.Save()
tsk.Close()
st.Dispose()
|
|
|
|
|
Check whether tsk is null or not. If it is null, debug the code for st.CreateTask("ReportTask"), and thus find out why it is null.
|
|
|
|
|
Hi,
I want to close a form when i hit the esc key.
I don't want to have a visible button.
Now a have a button and after another button (OK button) (When I set the visible to false it's not working) and have set tabkey to false.
Is there a beter way
Jan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
