|
The easiest way would probably be to have your report set up to accept a parameter. Then in the report file it would suppress a section or display it based on that parameters value. I would suggest that you research crystal report parameters [^]for more details as to how that is done.
I hope this helps.
|
|
|
|
|
Thanks for the hint. I did what you suggested: I added a boolean parameterfield to my report to which I pass true or false from runtime. Depending on this parameterfield the section is suppressed or shown.
Thanks.
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
Hello everyone,
I am new to this forum, and to posting in code forums in general, so i hope i have this in the right place, and i apologize if i don't.
I wrote a VB program that has a function that passes in the date (as an integer such as 28032008) and determines the name of the month (such as March) or the weekday (such as Friday). On my laptop it works great.
Then i tried putting it on another computer and i got the error message:
Conversion from string "28 03 2008" to date is invalid.
At first i thought it might need a .NET update, and after installing all of those, i still had the problem.
And then i realized what was happening - My computer displays the date (today) as 07/04/2008, but on the other computer it is shown as 04/07/2008, so my program and that computer are mixing up the day with the month.
Anyone have an idea how to detect the date format of the local computer so i can have my program adjust accordingly?
Thanks for reading,
Nicholas
|
|
|
|
|
Hi,
you can create a DateTime with known Day/Month/Year (see the constructors) and have it
converted to string in the system's default format (ToString methid), then you can "look"
at the string.
But you probably don't need all this; you can ask the DateTime type to parse a string
according to the system's settings, so it should work for you automatically as long as
the user follows his system's settings.
Of course, you can also override the date format, both in ToString() and in Parse() or TryParse().
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
You are making one of the standard errors nearly all programmers make when starting out, treating date data as a string. ALWAYS store your date data as a date data type NOT a string. If you do this it eliminates this (and quite a few other) issues.
If you must store your date as a string format the string as "dd/MMM/yyyy" this will remove any ambiguity caused by the format and you can reliably convert it into a date data type.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I am dealing with a database that stores the date in an integer format. I was only converting that to string in order to separate the month, day and year portions, and then attempting to convert it to date to get the month name or the weekday.
Thank you both for the replies.
|
|
|
|
|
hi all,
how to create toolbar like google toolbar in browser..in asp.net with vb.net...if any one help me!!!! it's urgent !!!
thanks
nil
|
|
|
|
|
Member 4080684 wrote: how to create toolbar like google toolbar in browser
This requires writing a Browser Helper Object.
Member 4080684 wrote: in asp.net
This cannot be done using ASP.NET. ASP.NET code runs service-side only. What you're looking for, a copy of the Google search component, cannot be written using ASP.NET.
Member 4080684 wrote: it's urgent !!!
The only thing urgent in a forum environment is the need to finish your post before you have to pee.
|
|
|
|
|
thanks all
i want to create toolbar in vb.net like google toolbar
pls help me
nil
|
|
|
|
|
I don't believe that you can, but if you can, then reading the article I link to in my sig would be the right first step to take here.
I suspect you need to use C++ to write an add in for IE, but I could be wrong. I know you'll need to write one for IE and one for FireFox, seperately.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Like Christian said, Google is your first stop. Search for "VB.NET Browser Helper Object" to get started.
|
|
|
|
|
First step is to understand what you're asking. ASP.NET cannot do that, why would you need to do it using a technology that doesn't do what you want ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
i have create database it sell computer hardware.I have table name Stock.inside stock i have set all products and unit price"Product""unitprice".but i do not know how to write code in vb.net.i'm using drag and drop method or use sql to do or stil have another method.can anyone help me.how do i do calculation in vb.net by coding like basic math oty*unitprice=total..thanks
|
|
|
|
|
Add a column to your datatable
dtProducts.Columns.Add("Total", typeof(System.Int32))
then add an expression to that column
dtProducts.Columns[index].Expression("unitsinstock * unitpricefield")
Good luck
|
|
|
|
|
can i know what use of (system.int32)
and dtproduct do i need to declare the "dt" like
is it do like below...
private btncalculate_click(.....)<br />
dim dtproduct as new stocktableadapter<br />
dtProducts.Columns.Add("Total", typeof(System.Int32))<br />
<br />
dtProducts.Columns[index].Expression("unitsinstock * unitpricefield")
thanks for the idea
it good if any can give me full coding..because i'm quite weak i do i declare all the "index",dtproduct,and what is system.int32
thing that i want to count is when click on combo box...it show hardware name and datagridview that will show the price list.then i need count unitprice in vb.net..ouantity is i enter myself.so unitprice*oty=total
modified on Tuesday, April 8, 2008 6:03 AM
|
|
|
|
|
I have a MenuStrip on form on which options are added at runtime.
I am handling the MouseHover event, which fires as expected.
Private Sub systemMenuStrip_MouseHover(ByVal sender As Object, ByVal e As System.EventArgs) Handles systemMenuStrip.MouseHover<br />
Dim oCursorPosition As System.Drawing.Point = Cursor.Position<br />
Dim oMenu As System.Windows.Forms.MenuStrip = DirectCast(sender, System.Windows.Forms.MenuStrip)<br />
Dim oOption As System.Windows.Forms.ToolStripItem = oMenu.GetItemAt(oCursorPosition)<br />
End Sub
The problem I am experiencing is obtain the option that I am currently hovering over. The value of oOption is always Nothing.
Any help appreciated, as always
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Hi,
seems to me Cursor.Position is returning an absolute (i.e. screen related) position,
whereas GetItemAt is likely to work with relative coordinates.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
If you want to know when mouse is over a menu strip item, you may directly add a MouseHover event for ToolStripMenu items.
This will allow you to execute a piece of code when mouse is over any particular menu strip item.
Such as –
---------------
Private Sub FileToolStripMenuItem_MouseHover(ByVal sender As Object, ByVal e As System.EventArgs) Handles FileToolStripMenuItem.MouseHover
MsgBox("Over File Menu")
End Sub
---------------
I hope this helps.
-Ajay.
--------------------------
www.componentone.com
--------------------------
|
|
|
|
|
Hi, I need to get a list of modem available in pc. I would like to create a list (in combobox) where I show all the modem available in my pc.
I am using visual basic .net and i have no idea how to create this list.
Does someone help me?
Thanks in advance!
|
|
|
|
|
Not 100% sure, but I think you need to look at the Windows Management Interface (WMI)
see the System.Management namespace
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
How can I change the type of a member of my datarow? it is coming in as dbNull but I need to change it to a datetime field.
|
|
|
|
|
Your question doesn't make much sense and you're leaving out some critical details. DbNull is a value where DateTime is a data type. You cannot change one for other.
How was your DataSet/DataTable created?? You cannot change just a column in one row in a table to have a different datatype from the rest of the rows in the table. It's all or nothing.
|
|
|
|
|
I am reading data from an excel spreadsheet, some fields are text and others are dates. I then read each line into a datarow in a dataset and then pass them to a method to insert them into an access table. Her is my read from excel code:
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [sheet1$]", MyConnection)
MyCommand.Fill(DtSet, "ExcelFields")
MyConnection.Close()
Dim ir As New DBTier
Dim va As New Validate
Dim dr As DataRow
For Each dr In DtSet.Tables("ExcelFields").Rows()
va.ValidateFeilds(dr)
ir.IncidentReportAdd(dr.ItemArray(0).ToString(), dr.ItemArray(1).ToString(), _
dr.ItemArray(5).ToString(), dr.ItemArray(7).ToString(), dr.ItemArray(2).ToString(), _
dr.ItemArray(8).ToString(), dr.ItemArray(10).ToString(), dr.ItemArray(12).ToString(), _
Date.Parse(dr.ItemArray(13).ToString()), Date.Parse(dr.ItemArray(14).ToString()), _
Date.Parse(dr.ItemArray(15).ToString()), Date.Parse(dr.ItemArray(16).ToString()), _
Date.Parse(dr.ItemArray(18).ToString()), Date.Parse(dr.ItemArray(19).ToString()), _
dr.ItemArray(21).ToString())
Next
I need to be able to check if the date is blank and replace it with 1/1/1900 if it is.
|
|
|
|
|
forgot to say, validate is where i'd like to change the fields value if it's empty.
|
|
|
|
|
OK, so this ValidateFields method is going to have to iterate through each column in the DataRow and check to see if each field is valid. Since a DateTime field cannot be Nothing (null), you can put in any date you want instead.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
