|
hi,
modified 28-Nov-12 9:06am.
|
|
|
|
|
Some video's from MSDN[^] might shed some light on this.
Enjoy
I are troll
|
|
|
|
|
Sounds to me like you should buy a book on SQL and read it.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
|
I would suggest if this is a class, you have textbooks. If it's a paid job, then you reap what you sow. Don't take jobs you have no idea how to do.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi all... Beena while since my last post but here goes...
I am busy with a report application and I need to add a Image Dynamicaly to the report. The image location should be stored in the app.config file and should be picked up automaticaly by the report when generated. Does anybody have an idea how to do this. I searched the net but didn't come across any articles that explans how to do this.
Thanks in advance
Steve
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
What report-engine are you using? It may be that the report-engine doesn't expect the location in the app.config file.
I are troll
|
|
|
|
|
Normal rdlc files (Reporting Services)
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
Instead of getting the report to read the app.config, try passing the location as a parameter
I are troll
|
|
|
|
|
What do you mean. Pass the location as a parameter and set it in the App from the app.config?
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
Read the location (in your app) on startup from the app.config, and pass the location as a parameter
I are troll
|
|
|
|
|
Thats what I ment thanks
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
I'm developing a client-server,(VB.Net/SQL Server) Incident Management system with up to 8 users. Each User is performing actions that generate entries in a single log table in the DB. I want each user to have a common view of all log entries, regardless of the source, updating whenever a new entry is inserted in the log. The display will be a listbox or grid control. How do I get the control automatically updated? Do I need A Broker service and async application on the client to get messages? I have seen suggestions of using managed code. I hope someone has tried this before and might suggest a way to do this.
|
|
|
|
|
Meaning that there is a table in your database, and you want the screen to automatically update when the table in your database changes?
A simple method would be to add a datetime-stamp to each record you insert, and doing a SELECT MAX(lastwritedate) every minute or so. That would give you the date/time that the last record was modified
I are troll
|
|
|
|
|
Thanks for the reply Eddy.
I was looking for something more "real time". The system is for a volunteer fire station HQ controlling 7 brigades. When incidents start there could be 20 or more log entries a minute as appliances are paged, go mobile and get directions for approach, etc. Each of those activities come from a different operator and I'm hoping that all operators see all entries as they are inserted in the log table. The log entries do have a datetime stamp. I was looking for a method: row inserted into the log table, vb control gets the entry and displays it at the bottom of a scrolling list as near as possible in "real time".
Thanks again for your quick reply.
|
|
|
|
|
Look into SQL Server Notification Services. It does exactly what you're describing.
|
|
|
|
|
|
mates,
how to convert date to integer in vb.net. I searched already in google
and test it. Convert.Int32 is not what i want.
When i code it in
VB6/VBA:
Dim m_lDate As Long
m_lDate = Date
m_lDate = DateAdd("m", -1, m_lDate)
This will work.
But it VB.NET:
Dim mDate As Integer
m_lDate = Date
mDate = DateAdd("m", 1, mDate)
Got an error:
Value of type 'Date' cannot be converted to 'Integer'
How to do that in VB.NET?
Thanks in advance
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
What do you want the int to be tho ? Would the property that returns a value in Ticks do what you need ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Christian Graus wrote: What do you want the int to be tho ?
I need it to my function that will add date, month, and year when i press
+/- button.
Here's what i did in vba.
Function ScrollDate(FNAME As String, CTname As Control, vskip)
Dim CTLN As Date
CTLN = CTname
CTLN = CTLN + vskip
CTname = CTLN
DoCmd.RepaintObject A_FORM, FNAME
End Function
So everytime i will click +/- button, i will call ScrollDate
Perfectly working in vba.
But in vb.net. I don't know what to do?
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
YOu mean, add two dates together ? How does this relate to having the date in a form as a single int ? What I don't get it, what format do you want, specifically, or don't you care, so long as it represents a date as an int ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Christian Graus wrote: what format do you want, specifically, or don't you care, so long as it represents a date as an int ?
yes, i don't care the format, as long as i get the int value from date value.
Example in vb6/vba:
myDate as Long
myDate = Date (2009/03/23)
so therefore myDate = 39896 (long)-->i need this in vb.net
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
OK, so ANY int value will do ? So the Ticks property I suggested you use, in my first reply, will work just fine ? DateTime.Now.Ticks
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
how to connect msaccess database in dotnet
|
|
|
|
|
a) By searching google and following the thousands of examples.
b) By reading the help manuals
c) By searching this site, i doubt you are the first to ask!
|
|
|
|