|
what i want to know is from the basics of using crystal reports in vb.net. for example i had installed .net 2003 and should i install the the crystal report for the .net or it is build in into .net. these kinds of things i want to know.
ddd
|
|
|
|
|
tasleem143 wrote: for example i had installed .net 2003 and should i install the the crystal report for the .net or it is build in into .net.
Well I can't really help you there. It's up to you to research which control will work best for you and your project.
These forums are really for specific coding questions. If you just want to learn about Crystal Reports in general, then your best bet is to read some articles and/or read a book. Crystal Reports is by no means a small topic.
|
|
|
|
|
how to insert date in the access using vb.net.
i m using these code it gives exception
Dim str As String = "#" + Now().ToString("d") + "#"
Dim query As String = "insert into Dt(Date, Val) values ('" & str & "' ,3)"
then then olddbcommand and then executenoquery functions
but that code gives exception
String = "insert into Dt(Date, Val) values (' # 12/3/2006 # ' ,3)"
but that code gives exception
String = "insert into Dt(Date, Val) values ('12/3/2006',3)"
tell me how to do that insert date into access database through
vb.net
ddd
|
|
|
|
|
MS Access requires a DateTime SQL string to have US formatting, even when running your app in other countries. You also need to surround it with # symbols.
I recommend that you add a conversion function like this...
Public Function DateTimeToSql(ByVal dtValue As Date) As String
Return dtValue.ToString("\#MM\/dd\/yyyy HH\:mm\:ss\#")
End Function
Then convert the DateTime to a SQL string like this...
Dim query As String
query = "insert into Dt (Date, Val) values (" & _
DateTimeToSql(Date.Now) & " ,3)"
|
|
|
|
|
Oops. I just noticed that you wanted just a date, not a date-time. In that case, use a function like this...
Public Function DateToSql(ByVal dtValue As Date) As String
Return dtValue.ToString("\#MM\/dd\/yyyy\#")
End Function
|
|
|
|
|
Thanks to Christian, but I still have this problem.
I am doing a simple web form in VS 2002 on XP Pro system. IIS is installed.
I un-installed VS and re-installed and still get the same problem.
I tried a test form last night, with 2 labels and 2 link buttons. The labels are color and font formatted and the link buttons are normal. All 4 controls are set in a column, with left alignment, as follows :
Label
Label
Link Button
Link Button
When I go to compile and run the application, the web page shows the controls as follows :
Label Label Link Button Link Button
I know when I was working on a VS 2003 system that this was not happening, and I feel it is just a setting that I have incorrect. Any ideas ? I need to get this done by the weekend.
Derek
|
|
|
|
|
I had a similiar problem too.
Try the following: (assuming the webform is in flow mode)
As a test hit the carriage return at the end of each control so it looks like this.
Label
Label
Link Button
Link Button
When I did that in my webform everything look the way it should when I ran the application. Then I deleted the extra lines and the problem was fixed. Not sure if it will fix your problem but it is worth a try.
|
|
|
|
|
Why on earth would you uninstall VS, when I already explained to you how to solve the problem, and pointed out that the design view sucks ? It still sucks, it's still going to give you these sort of problems, no matter how often you remove and reinstall the IDE.
Derek G wrote: I know when I was working on a VS 2003 system that this was not happening,
Probably you had the controls in a table or something.
Derek G wrote: I need to get this done by the weekend.
Then why not take 3 seconds to follow my advice ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I need a report to automatically drill down on the first group in the report
CrystalReportViewer1.DrillDownOnGroup
but the group is always different
any ideas
1. Out of clutter, find simplicity.
2. From discord, find harmony.
3. In the middle of difficulty lies opportunity.
Albert Einstein
three rules of work
|
|
|
|
|
hay guys...i would ask you something:
i want advice..... i'm conf between 17" LCD Acer and 19" CRT Flatron ViewSonic or LG....
some VB.Net guys could say somethin
Militiaware
Faris Madi
|
|
|
|
|
This has nothing specifically to do with VB.NET - However, my general advice is to go for the largest / highest resolution that you can afford. Also take into account the quality of the display - Your eyes cannot be replaced easily.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
What does this have to do with VB ?
Anyhow, I'd go with the 17", because it's basically 18" compared to a CRT, and unless either of those offers 1600x1280, the extra room on the 19" will be wasted.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i built a class.. and i wanna (after init the components) to wait some action from the user (to rais event)
what i should use to tell my code to wait...?
should i use the thread class?
Militiaware
Faris Madi
|
|
|
|
|
sure it is the best solution
|
|
|
|
|
Nothing at all - your code WILL wait if it's a windows app, that's how windows works.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yep just like Christian says, threads are meant for doing several tasks at once (or make a task and still be able to have input on the form for instance).
daniero
|
|
|
|
|
i understand they way the windows works...
but my program doesn't need a form.....
it's only a NotifyIcon and ContextMenu....
so i've to build it on a class.....
i don't understand what could makes my program to wait the user to do some event like clicking on a menu item?
what you think..if you could help me?;)
Militiaware
Faris Madi
|
|
|
|
|
Where does the context menu appear ? I assume this is a task bar icon ? If so, your app is still a forms app, it has a message pump and responds to UI events.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
My NotifyIcon appears nearby the clock..
now the Notifyicon.contextmenu = contextmenu1
Notifyicon.icon= icon
now all that exit in a class1.vb and it has a sub main to make the pgm startwith.
actully the code executed from the begining to the end of the code then the application end (close)
and it doesn't wait the user like the form do.....
Militiaware
Faris Madi
|
|
|
|
|
militiaware wrote: My NotifyIcon appears nearby the clock..
As I thought. So, you have an app with a message loop, even if there's no visible form.
militiaware wrote: actully the code executed from the begining to the end of the code then the application end (close)
and it doesn't wait the user like the form do.....
So you've got the wrong sort of project to start with. You need to do a forms app, I believe. I can't imagine what else it would be. Did you find an article on apps that run in the system tray, or are you working it all out as you go ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i don't think i chosed the wrong sort of project
i'll tell what i did:
i open new windows project.
i deleted the default form "form1"
add new class "as Class1.vb"
in here i create the notifyicon and the context menu and menuItems objects...etc
this class has a sub main....
and that's it..
the that give examples...doesn't give what i want...
these examples works in a default way.... (i.e: drag the notifyIcon to the form....change some properties of it .....etc etc..)
Militiaware
Faris Madi
|
|
|
|
|
Well, you need a form class in order to have a message pump. So, there's your problem. You need to create a form, then hide the form itself and move the icon to the tray. But you need your code in a form class, so that there's a message pump happening.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Actully, this idea crossed my mind...
but what if i don't need to use extra memory of the system larger than what my program need to be run....
in another way: Is there some way to solve the problem without using the form class and its size in the memory...because i don't need a form....
Militiaware
Faris Madi
|
|
|
|
|
militiaware wrote: Is there some way to solve the problem without using the form class and its size in the memory...because i don't need a form....
No. And, the size of a form that is invisible and does nothing is next to 0.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I know how to paint any control's background, like painting Form's background using event Form_Paint.
Now I painted Panel's background through event Panel_Paint, and wanted to save it as picture/image in any format (prefer jpeg). Tell me how can I do this in VB.NET.
Thanx
Iftikhar Ali
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
