|
Replace Me.Text = name with Me.Text = OpenFileDialog1.FileName.
Actually, you would be better writing this section like this:
Dim fileName As String
If OpenFileDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then
fileName = OpenFileDialog1.FileName
End If
If fileName <> String.Empty Then
rtb1.LoadFile(fileName)
Me.Text = fileName
End If
Don't tell somebody that there was an unknown error just because they clicked Cancel in a dialog box. It is bad form.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi,
I am trying to export a crystal report to excel format in aspx page using vb as the code behind. I have published the crystal report in the BusinessObjects server and loading in the page load event. I can able to load the crystal report using the below code,
<br />
Dim mySessionMgr As SessionMgr = New SessionMgr<br />
Dim myEnterpriseSession As EnterpriseSession = mySessionMgr.Logon(uname,pwd,servername, AuthType)<br />
Dim myEnterpriseService As EnterpriseService = myEnterpriseSession.GetService("InfoStore")<br />
Dim myInfoStore As InfoStore = New InfoStore(myEnterpriseService)<br />
myEnterpriseService = myEnterpriseSession.GetService("PSReportFactory")<br />
Dim psrfObject As Object = myEnterpriseService.Interface<br />
Dim myPSReportFactory As PSReportFactory = CType(psrfObject, PSReportFactory)<br />
Dim queryString As String = "Select SI_ID, SI_NAME, SI_PARENTID From CI_INFOOBJECTS " _& "Where SI_KIND='CrystalReport' and SI_INSTANCE=0 " _<br />
& "And SI_NAME = 'Report1'"<br />
Dim myInfoObjects As InfoObjects = myInfoStore.Query(queryString)<br />
Dim myInfoObject As InfoObject = myInfoObjects(1)<br />
Dim myReportSource As ReportSource = myPSReportFactory.OpenReportSource(myInfoObject.ID)<br />
<br />
Session("my_rptsrc") = myReportSource<br />
CrystalReportViewer1.ReportSource = myReportSource <br />
But the export options is not working for the instance of my report(myReportSource)
<br />
Dim myExportOptions As New CrystalDecisions.Shared.ExportOptions<br />
Dim myDiskFileDestinationOptions As CrystalDecisions.Shared.DiskFileDestinationOptions<br />
Dim myExportFile As String = "Report1.rpt"<br />
myDiskFileDestinationOptions = New CrystalDecisions.Shared.DiskFileDestinationOptions<br />
myDiskFileDestinationOptions.DiskFileName = myExportFile<br />
<br />
myExportOptions = myReportSource.ExportOptions<br />
I need to get the export options as in the above code but i m not able to get that(Export option is not available for the instance).
<br />
With myExportOptions<br />
.DestinationOptions = myDiskFileDestinationOptions<br />
.ExportDestinationType = .ExportDestinationType.DiskFile<br />
.ExportFormatType = .ExportFormatType.Excel<br />
End With<br />
myReportSource.Export()<br />
In the above line also export function is not available for the instance myReportSource.
<br />
Response.ClearContent()<br />
Response.ClearHeaders()<br />
Response.ContentType = "application/ms-xls"<br />
Response.WriteFile(myExportFile)<br />
Response.Flush()<br />
Response.Close()<br />
I need help regarding this....
|
|
|
|
|
i am creting a playlist in vb.net and i need to create a few buttons that select all the items in a list and two further buttons to select the item above and item below. can anyone tell me how i would go about that.
|
|
|
|
|
For listbox:
Select All: It is necessary to switch modes on select all
ListBox1().SelectionMode = SelectionMode.MultiSimple<br />
For i As Integer = 0 To Me.ListBox1.Items.Count - 1<br />
Me.ListBox1.SetSelected(i, True)<br />
Next
Select Previous:
ListBox1().SelectionMode = SelectionMode.One<br />
If Me.ListBox1.SelectedIndex > 0 Then<br />
Me.ListBox1.SelectedIndex = Me.ListBox1.SelectedIndex - 1<br />
End If
Select Next:
ListBox1().SelectionMode = SelectionMode.One<br />
If Me.ListBox1.SelectedIndex < Me.ListBox1.Items.Count - 1 Then<br />
Me.ListBox1.SelectedIndex = Me.ListBox1.SelectedIndex + 1<br />
End If<br />
Posted by The ANZAC
|
|
|
|
|
thanks alot matey thats a great help to my cause. much apreciation
|
|
|
|
|
Hi,
I am generating a report in VB.NET.The report is displayed in a grid format.When i preview the print of the report, i can only see half of the grid columns and so the print contains only few columns. Can any1 tell me how i can view all the columns of the grid in the report.I want the print to have all the columns in the same page.
Thanks,
Riz
|
|
|
|
|
Hi, i m now doing my final year project in designing a web page that provide video conferencing service. this service allowed the user to chat face-to-face by using this video conferencing through Internet n webcam.
 Please, some one else o anyone can provide me the source code solution in Visual Basic.net 2005 in designing this service.
I m very appreciate for your helping n thank U very much! 
|
|
|
|
|
|
Hi..
Im not sure if im posting in correct place. if so please tell me..
however i need to assistance with something to do with VB Express 2005 using
MDB back end database. I have just set a password on my MDB DB and now need to let VB express in Database Explorer where I modify the connection what the password is... but after doing so and set the password in the connection
i get a NOT A VALID PASSWORD when executing my app.
Please help
Robbo
|
|
|
|
|
Make sure your connection string is setup correctly. This site is a good reference for that: http://www.connectionstrings.com[^]
If it is correct, make sure your user and password are the correct letter case (if your user/password is all lower case, make sure it is lower case in your connection string too)
Hope this helps.
|
|
|
|
|
Thanks Kschuler.
My connection string is predefined by VB.NET which im asssuming lives in app.config file. i thought it would be simple to add a password to MDB in access and then tell VB what the new password is which is ok.. however when my app executes and a FILL() is executed it return a "OLEDBexception handler not a valid password " error.
please advise what im missing. please remember my connection string is predefined and i've already checked out connectionstring.com website to no avail.
thanks
|
|
|
|
|
I guess I'm confused with the predefined thing. I usually have a constant in my project that holds my connection string and every time I make a connection I set the connection object to it. Like this:
Dim strConnect as String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;"
Dim conn as New System.Data.OleDb.OleDbConnection
conn.ConnectionString = strConnect
Dim cmd as New System.Data.OleDb.OleDbCommand
cmd.Connection = conn
Sorry, I can't help you with the predefined connection.
|
|
|
|
|
Hello,
I can view report with crystal report viewer but I want remote users be able to view and print the report using Internet explorer. In order to do that, I need to export crytal report into html programmaticaly. So that when a user click on a button, the report can be viewed in html format.
How Can I do it using vb.net?
Thank you in advance.
programmer
|
|
|
|
|
I am allowing the users to choose multiple background images for my menustrip and statusstrip. I need to know how to set these back to their original images after they have been changed. The text(fore) colors will also change when each image is changed so these need to be set back to their original color as well. Is their something that just sets all the controls on a forms property to what they were at initial form load???? Anyone that can help me with this would be fantastic and will save me many headaches. Thank you!!!!
-Joey
|
|
|
|
|
check for method of the control for something like 'reset'. if there isn't one then look at the designer to know how at design time the control is set and then copy those lines of code and put them in a reset routine to be able to programmatically reset it back to it's original state.
|
|
|
|
|
Good Idea, thank you very much... It makes me mad I cant think of simple solutions like that yet. maybe someday... again, thank you!
-Joey
|
|
|
|
|
how to set notifyicon.icon during run time with imagelist?
|
|
|
|
|
Dim oBitMap As New Bitmap(ImageList1.Images(0))
NotifyIcon1.Icon = Icon.FromHandle(oBitMap.GetHicon)
|
|
|
|
|
Just wondering if anyone knows how to make a project so that when someone changes the windows color scheme (theme) it does not affect the program. There has got to be a way!!!! Please help me with this... Thank you!!!
|
|
|
|
|
don't use system colors. when you add a form to the project it defaults to the color 'control' of the system tab (tab when you pick a color). these are system colors that react to the color scheme of windows.
-- modified at 15:04 Tuesday 12th December, 2006
|
|
|
|
|
I'm trying to deploy my program but in other computers the reference I have for Microsoft Access is different (it has a different path) so it doesn't run on the other computers. Is there a solution to this problem?
|
|
|
|
|
Place your access database on a global computer (computer everyone can access). Then re-add the data source to your project. Look at the connection string that is created for the new data source and make sure that all the client computers will be able to resolve the address (Computer Name or IP, if IP make sure that the serving computer has the IP statically assigned). Hope this helps. It's kind of a generic answer, if your needing something more specific then post the portion of code that references the database for the application and a description of the networking environment the application will be working in.
|
|
|
|
|
Thank You sooooo much!!! But now I'm trying to run this code withouth
using ADO.Net
AccessTmpDB.DoCmd.TransferText(0, MyImpTableName, MyImpTableName, MyTxtFileName, True, "")
AccessTmpDB.DoCmd.RunSQL(MySQL)
Is that possible??
|
|
|
|
|
Hey everyone,
Im currently workin on a little project for work which is driving me insane! I didnt want it to come to this (asking experts for help) but i feel the project needs some fresh eyes to guide me to a better solution. So let me just outline what im trying to do;
First, we have a large list of customers on our server, approx 1316 customers. Now on our intranet webpage i wish to create a fast way of finding customers using an ASP tree. So consider a list of customer names returned from an SQL query into a large array. I then wish to check the first couple of letters of each customer, and group customers with similiar names together under one branch in the tree.
The Result would look something like this;
Customers
|
|-A
___|-ar
______-arson, pat
______-arson, mick
______-arsen, jon
______...
______...
___|-as
______-asnot, mark
______...
______...
___|-Other A's
______...
______...
|-B
___|-ba
______|-bai
__________-bailey, john
__________-bailey, mark
__________...
__________...
______|-bar
__________-barker, paul
__________-barton, mike
__________...
__________...
___|-br
______-bromich, dave
______-brockurst, mick
______...
______...
___|-Other B's
______...
______...
|-C
___-charles, john
___-chaplin, pat
______-chan, johnny
|-D
___|-da
.
.
.
....
just to explain anything with a | beside it represents a branch which has leaves while anythin with just - represents a leaf which will hold a customer name
One main important thing about this code is that i want it to be very dynamic and one important feature is groups of similar names, being grouped in their own branch. For example the code should read like;
if there are less than X names beginning with 'ar' then group these names under a branch called 'ar'
But if there are more than X names beginning with 'ar' then search again through this group and compare the first 3 letters for similarity.
This idea is shown in the B section, here the code found more than X names with -ba as the first two letters, and so and the code ran again comparing the first three letters, these groups of three letters had less hits than X and so are plotted in their own trees -bai and -bar.
I hope you can follow me now as you read this and it makes some sort of sense!
I want it to be so dynamic that lets say, we enter many customers with names starting with -bai, the program will then scan the first four letters of the name and if this is over X, it will scan the first five letters of each name, if again theres more than X it will move onto scanning 6 letters.
Thats is why i call it 'intelligent sorting' i want it to be so streamlined that you could have 200 -bai customers sorted into 5 or 6 branches, while you may have only 5 -D customers which will only fall under the -D branch!
I've been trying to do this with a simple checkltr = left(myarray(1,k),3) command and lots of array sorting, which works. but when i move onto checking 4 letters and 5 letters the code gets way too big and eventually just becomes inefficient, there has to be a way of doing this with not much code.
Please, please, please if anyone can help it would be great!
NOTE: I DONT NEED HELP WITH THE .ASP TREE, JUST WITH SORTING THE DATA!!
|
|
|
|
|
You can do this in SQL by writing a statement like this:
SELECT * FROM myTable WHERE customerName like 'BAI%'
The % is a wildcard character in SQL. The one thing to watch out for is that SQL it is case sensitive, so to search for all possiblities you'd have to uppercase the customerName first.
Hope this helps.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
