|
HI everyone,
I wanted to display the report data in the range of 2 datetimepicker but I am not experience and knowledgeable in ReportViewer.
My situation:
Form1 is a form where user select a range of date between 2 datetimepicker then click the button to show the report in form2.
My query in query builder will be like this:
"Where (Date Between @Param1 AND @Param2)"
If there is better way like able to have selection like select monthly, yearly to display the report is even better.
I would really appreciate it, if someone can give me an example of coding and explanation. So far, I know how to create the report and dataset for it but the parameter part I am really out of Ideas.
|
|
|
|
|
Why my report menu does not have the "Report Parameter" selection expect for "Report Properties","Add Page Header","Add Page Footer","Ruler", and "Grouping"? How to get the Report Parameter out?
|
|
|
|
|
hi
Want to know more about Trace
What used to be
Thank
modified 14-Sep-12 13:20pm.
|
|
|
|
|
alirezamansoori wrote: apples
What kind of apples do you want to know more about? Red apples? Green apples? Yellow apples? Apple the company? What does this have to do with any kind of Visual Basic question?
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
|
alirezamansoori wrote: trace
And what about trace? Are you looking for something like this[^]?
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
They used to be seeds.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
|
That still doesn't help much, but I guess you are looking for something along these lines[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Hi, I'm new in vb.net
What the difference of these codes
for u = 0 to datatable.rows.count - 1
next
for each rows in datatable.rows
next
assuming process code are to parsing data datatable.rows either to search or to print or to calculate.
which one is faster ?
can someone give me some enlighment ?
sorry for bad english.
|
|
|
|
|
One loop is an indexer and the other is an enumator.
Indexers can modify the collection while you're iterating over it while enumators cannot.
Indexers are a little faster than enumerators, but also require you to know more about the size and types the array holds.
|
|
|
|
|
Thank You Dave. It clear my mind.
|
|
|
|
|
Just to add to Dave's comment - The for-loop is faster than the foreach-loop if the array must only be accessed once per iteration. (More Details with Benchmark Test[^]).
|
|
|
|
|
Thank you Pravin for the link. It gives me an understanding.
|
|
|
|
|
My pleasure yuifox... Happy coding
|
|
|
|
|
El segundo código es mas eficiente y rapido.
_______________________
Edward J. Ocando. | Desarrollador | SoyDesarrollador.net
Telefono. +58 (416) 164.34.88 | Edward.Ocando@soydesarrollador.net
|
|
|
|
|
I'm having a problem I can't seem to find the source of in a program I'm developing. The following function parses an XML file to find the names of registry keys and associated values that are linked to the selection of a drop-down box in the UI. The function retrieves keys with no problem. when asking for the values, it always returns 0, and I can't seem to figure out why. Thanks for taking a look and any suggestions/solutions you may come up with.
I've included the source of the function below and a sample of the XML -
Public Function GetCfgOption(ByVal strSetting As String, ByVal intSelectedIndex As Integer, ByVal strDataType As String, Optional ByVal intOptIndex As Integer = 0) As String
Dim xmlSettings As New Xml.XmlDocument
xmlSettings.Load("SrcBench.xml")
Dim nodeSetting As Xml.XmlNode
nodeSetting = xmlSettings.SelectSingleNode("/CONTENT/Settings/" & strSetting & "[Index='" & intSelectedIndex & "']")
Dim nodeOption As Xml.XmlNode
nodeOption = nodeSetting.SelectSingleNode("/CONTENT/Settings/" & strSetting & "/Setting[@Index='" & intOptIndex & "']")
Select Case strDataType
Case "Key"
Return nodeOption.ChildNodes.Item(0).InnerText
Case "Value"
Return nodeOption.ChildNodes.Item(1).InnerText
End Select
Return Nothing
End Function
This function would be called like so:
GetCfgOption("FilterMode", intFilterModeIndex, "Key"<, 0>)
GetCfgOption("FilterMode", intFilterModeIndex, "Value"<, 0>)
GetCfgOption("FilterMode", intFilterModeIndex, "Key", 1)
GetCfgOption("FilterMode", intFilterModeIndex, "Value", 1)
This could be tested using a Console.WriteLine() statement. Calling the function with "Value" always returns "0".
The following is a section of the XML file being accessed:
="1.0"="UTF-8"
<CONTENT>
<Settings>
<FilterMode>
<Index>0</Index>
<Option>Bilinear</Option>
<Setting Index="0">
<Key>mat_forceaniso</Key>
<Value>0</Value>
</Setting>
<Setting Index="1">
<Key>mat_trilinear</Key>
<Value>0</Value>
</Setting>
</FilterMode>
<FilterMode>
<Index>1</Index>
<Option>Trilinear</Option>
<Setting Index="0">
<Key>mat_forceaniso</Key>
<Value>1</Value>
</Setting>
<Setting Index="1">
<Key>mat_trilinear</Key>
<Value>1</Value>
</Setting>
</FilterMode>
<FilterMode>
<Index>2</Index>
<Option>2x Anisotropic</Option>
<Setting Index="0">
<Key>mat_forceaniso</Key>
<Value>2</Value>
</Setting>
<Setting Index="1">
<Key>mat_trilinear</Key>
<Value>0</Value>
</Setting>
</FilterMode>
<FilterMode>
<Index>3</Index>
<Option>4x Anisotropic</Option>
<Setting Index="0">
<Key>mat_forceaniso</Key>
<Value>4</Value>
</Setting>
<Setting Index="1">
<Key>mat_trilinear</Key>
<Value>0</Value>
</Setting>
</FilterMode>
<FilterMode>
<Index>4</Index>
<Option>8x Anisotropic</Option>
<Setting Index="0">
<Key>mat_forceaniso</Key>
<Value>8</Value>
</Setting>
<Setting Index="1">
<Key>mat_trilinear</Key>
<Value>0</Value>
</Setting>
</FilterMode>
<FilterMode>
<Index>5</Index>
<Option>16x Anisotropic</Option>
<Setting Index="0">
<Key>mat_forceaniso</Key>
<Value>16</Value>
</Setting>
<Setting Index="1">
<Key>mat_trilinear</Key>
<Value>0</Value>
</Setting>
</FilterMode>
</Settings>
</CONTENT>
|
|
|
|
|
How can I design web user account and login using Visual basic 8
|
|
|
|
|
|
I have to design a form with LISTBOX,FIELD to display name,CAPITAL CITY and estimeted population of selected country.
Pleas just give me a clue or enlightment!
|
|
|
|
|
So....what part of your homework assignment are you having problems with??
If you don't know how to drag and drop controls on a form in Visual Studio you've got a serious problem that we can't fix.
|
|
|
|
|
How to code the month control or datetimepicker to have month. I don't want to have 2 datetimepicker. Is there a way for user to only choose month then display that months data from 1st to 31st for example?
I have no idea how to do because each month has different days.
|
|
|
|
|
Get the month and year from the user then use the DateTime.DaysInMonth method to get the number of days in that month.
When you have those two things, you can make two DateTime objects using the month and year supplied by the user. Use the 1st of the month to start the date range and the number of days returned by DaysInMonth to create the second date value.
There's your date range. You just supply those two dates to a couple of parameters in your SQL query (PLEASE USE PARAMETERIZED QUERIES AND NOT STRING CONCATINATION!!) to retrieve the data.
If you don't know what a parameterized query is, Google for "VB.NET SQL Parameterized Query".
|
|
|
|
|
Thank you, I might ask too much.....can you provide me some examples or links because I am still new to this.
|
|
|
|
|