|
I want to create reports in vb.net never done it before i am searching on net but just keep coming up with crystal reports, can anybody explain what is the best and easiest for doing reports in vb.net 2003 the reports will consist of review of show from april to april for year to year.
Any hints would be grately appreciated, thank you very much.
|
|
|
|
|
Crystal Reports may well be the easiest way, but there are also free and commercial libraries for rendering reports. There's nothing built into VB itself.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Sir/Madam,
On the form load , I wrote
Application.run(new form1)
and
I got the message that i can't run two messages on the single on single thread
Please help.
Thanks and regards
Pankaj
|
|
|
|
|
amaneet wrote: I got the message that i can't run two messages on the single on single thread
That's correct. But... Why do you want to put Application.Run(...) in a Form's Load handler? You are already running the application.
|
|
|
|
|
Sir,
I read somewhere
Public shared sub functin1()
End Sub
What was the need of using shared keyword.
Public keyword was not enough to make the function shared among
other classs?
Or there is some other utility regarding Shared keyword.
Thanks and regards
Pankaj
|
|
|
|
|
Public and Shared do not mean the same thing.
Public is in a set with Protected, Private and so on. Public means that anything can access it. Protected means that the class and anything derived from it can access it. Private means only the class can access it.
Shared (static in C#) means it is shared amongst all instances of the class. A Shared method does not need any instance of the class to be created. A Shared field on a class means the one value is shared amongs all instances (or even no instances, for an instance is not required) of the class.
|
|
|
|
|
|
Hello
To see the differece with your eyes:
create a class and write to function one with the public and the Other with
shared.
you will find out, to use the first one you must create an instance of the class but to call the second one you dont need.
if you couldn't understand ( with my week English) I'll give you the class.
Good life.
|
|
|
|
|
Have got 1 datagrid displaying the data when the program is run and when i click on a selection in that datagrid it populates another datagrid 2 with the information required, say for instance i have to tables in database 1 shows-this datagrid 1 vb.net,and the other performances this datagrid 2 vb.net.
when i click the datagrid 1 it populates all the performances for that show into the other datagrid showing performance no,date,time,show no but i also need show title to come across but it is in another table shows datagrid 1. any ideas,
|
|
|
|
|
If I understand correctly what you are asking, you can try something like this:
1. populate dataset 1 and bind it to datagrid 1
2. adapt the following code to get the row the user clicked on, and the corresponding cell value:
Private Sub Datagrid1_MouseDown(ByVal sender As Object, ByVal e As MouseEventArgs) Handles Datagrid1.MouseDown<br />
Try<br />
Dim myGrid As DataGrid = CType(sender, DataGrid)<br />
Dim hti As System.Windows.Forms.DataGrid.HitTestInfo<br />
hti = myGrid.HitTest(e.X, e.Y)<br />
Dim message As String = "You clicked "<br />
Select Case hti.Type<br />
Case System.Windows.Forms.DataGrid.HitTestType.None<br />
message &= "the background."<br />
Case System.Windows.Forms.DataGrid.HitTestType.Cell<br />
message &= "cell at row " & hti.Row & ", col " & hti.Column<br />
Case System.Windows.Forms.DataGrid.HitTestType.ColumnHeader<br />
message &= "the column header for column " & hti.Column<br />
Case System.Windows.Forms.DataGrid.HitTestType.RowHeader<br />
message &= "the row header for row " & hti.Row<br />
Case System.Windows.Forms.DataGrid.HitTestType.ColumnResize<br />
message &= "the column resizer for column " & hti.Column<br />
Case System.Windows.Forms.DataGrid.HitTestType.RowResize<br />
message &= "the row resizer for row " & hti.Row<br />
Case System.Windows.Forms.DataGrid.HitTestType.Caption<br />
message &= "the caption"<br />
Case System.Windows.Forms.DataGrid.HitTestType.ParentRows<br />
message &= "the parent row"<br />
MsgBox(message)<br />
End Select<br />
Catch Ex As Exception<br />
MsgBox(Ex.Message)<br />
End Try<br />
End Sub
3. Execute a parametrized query to populate dataset 2 with the data you want to show in datagrid 2, using the cell value obtained in the code above.
4. bind dataset 2 to datagrid 2
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi..
I am having a huge problem with getting the selected index changed property of a drop down list when inside a datagrid..
I have two drop down lists inside the datagrid, toSectDDL and tosubSectDDL. What i want is when the user selects an item from the toSectDDL, the tosubSectDDL should be populated with the related subsections for that particular section only..
I have written the VB code as
Protected Sub toSectDDL_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
Dim row As DataGridItem
For Each row In SectionGrid.Items
Dim toSectDDL As DropDownList = CType(SectionGrid.FindControl("toSectDDL"), DropDownList)
Dim toSubSectDDL As DropDownList = CType(SectionGrid.FindControl("toSubSectDDL"), DropDownList)
If toSectDDL.SelectedValue = 0 Then
toSubSectDDL.Items.Insert(0, New ListItem("None", "0"))
Else
toSubSectDDL.DataSource = Office.GetSubSectionsForSection(toSectDDL.SelectedValue)
toSubSectDDL.DataTextField = "subsection"
toSubSectDDL.DataValueField = "subSecID"
toSubSectDDL.DataBind()
toSubSectDDL.Items.Insert(0, New ListItem("Select", "0"))
End If
Next
End Sub
and set the ASP code as
<asp:templatecolumn headertext="toSection">
<itemtemplate>
<asp:dropdownlist id="toSectDDL" runat="server" cssclass="standardDDL" width="402px" onselectedindexchanged="toSectDDL_SelectedIndexChanged" autopostback="True">
Now i am getting a server error saying
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
veyo.OfficeNameChange.toSectDDL_SelectedIndexChanged(Object sender, EventArgs e) in \\aion\intranetroot$\veyo\updateVEYO\OfficeNameChange.aspx.vb:430
System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e) +108
System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent() +26
System.Web.UI.Page.RaiseChangedEvents() +115
System.Web.UI.Page.ProcessRequestMain() +1099
Can anyone plz help!!!!!!
|
|
|
|
|
"<asp:TemplateColumn HeaderText="toSection"><ItemTemplate><asp:DropDownList id="toSectDDL" runat="server" CssClass="standardDDL" Width="402px" removed="toSectDDL_SelectedIndexChanged" AutoPostBack="True" ></asp:DropDownList></ItemTemplate></asp:TemplateColumn>"
I would first make sure you check the control for "If IsNothing" before doing anything manipulations to it. Also what is "removed="?
Cleako
|
|
|
|
|
Hello,
I want Copy a Folder & its sub Folder From CD Drive to My Documents. How i can do this ? and i also want to create short cut an exe file on Desktop from my Documents. I am using VB.NET 2005.
PLZ Help me.
Thanks & Regards
Form :-
Vikash Yadav
|
|
|
|
|
This may look a bit confusing, but it's it really easy.
Dim Path As String = "D:\"
For Each Directory As String In My.Computer.FileSystem.GetDirectories(Path, FileIO.SearchOption.SearchAllSubDirectories)
Dim DirName As String = Directory
Dim Pos As Integer = DirName.LastIndexOf("\")
DirName = Directory.Remove(0, Pos)
My.Computer.FileSystem.CopyDirectory(Directory, My.Computer.FileSystem.SpecialDirectories.MyDocuments & DirName, True)
Next
For Each File As String In My.Computer.FileSystem.GetFiles(Path, FileIO.SearchOption.SearchTopLevelOnly)
Dim FileName As String = File
Dim Pos As Integer = FileName.LastIndexOf("\")
FileName = File.Remove(0, Pos)
My.Computer.FileSystem.CopyFile(File, My.Computer.FileSystem.SpecialDirectories.MyDocuments & FileName, True)
Next
Hope this helps!
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
|
how to get the color of a pixel of an image in a pictureBox
Regards
Ramy
|
|
|
|
|
picturebox.Image.GetPixel should do it. But, if you really want to do anything with an image, you should draw it yourself, not use a picture box.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
This should do it:
Dim x As Integer = Me.PictureBox1.PointToClient(Windows.Forms.Cursor.Position).X
Dim y As Integer = Me.PictureBox1.PointToClient(Windows.Forms.Cursor.Position).Y
Dim col As Color = Img.GetPixel(x, y)
And please do not double post, at least, not until your post has gone to the next page, it's really annoying and hardly anyone had had a chance to answer your old one.
Posted by The ANZAC
|
|
|
|
|
hi
i have developed crstal report thro' VB. i want to print conditional headings & details
e.g. i have 2 manufacturing plants - Inline,Online
but my report is same for both plant but having 2 different headings & no. of machines in details. i have created such scrap database file according to the requiremets
for online heading is - "Rejection analysis for" - "Online"
for inline - "Rejection analysis for" - "Inline"
M/c no. for online - 1 2 3 4
M/c no. for inline -11 12 13
could it possible using formula field ? if possible the how ?
regads
reply immediate
thanks
|
|
|
|
|
I want format of date like dd/mm/yyyy in vb.net
& how will i get only separate time at that instant
reply immediate if possible
thanks
|
|
|
|
|
msgbox(now.tostring("dd/MM/yyyy"))
msgbox(now.tostring("hh:mm:ss"))
|
|
|
|
|
Hi EveryOne,
Guys I need to deploy a .net2005 project that includes crystal reporting of .net also. I need to know which neccessary files required to be added in .net setup project coz setup project picks only CrystalDecision. CrystalReports. Design.dll. Also guide me one more thing that Is Crystal Report setup for .net 2005 is also required to be run with setup coz another application of VB 6.0 running on same PC that is using Crystal Reports 9.0
Kindly give me any idea regarding these problems.
Regards
Ali Raza
|
|
|
|
|
Hello
how to retrieve the color of a pixel in a image inserted in a picturebox
I know that :
dim img1 as bitmap
(img1.GetPixel(e.Location.X, e.Location.Y).R
but im not able to use it within the Picturebox image
Regards
Ramy
|
|
|
|
|
Get the reference of the image from the control, cast it to Bitmap and use the GetPixel method.
---
single minded; short sighted; long gone;
|
|
|
|
|
Guffa wrote: Get the reference of the image from the control, cast it to Bitmap and use the GetPixel method.
get u give me an example plz
Regards
Ramy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
