|
Dim s As New System.Web.Mail.MailAttachment("Insert path to file here in form of a string")
.Attachments.Add(s)
--> adding a attachment to the message
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
thanks very mch.. i 'll update u the result.
"I am burning...the only thing rest in me is you..."
|
|
|
|
|
In VBA environment I have 2 Tabs Inv and Att. When I click on Checkbox in Inv and then click on the next tab which is Att and go back to Inv tab from Att the CheckBoxes in the Inv tab disappear.
So, my question is what should I change in the settings inorder for CheckBoxes in the Inv tab not to disappear?? I tried Hide Selection as False and tried MultiSelect as true but it does not work.
|
|
|
|
|
You have two tabs in what?? Access, Excel, Word, something else??? Is this a tab control?? What are these checkboxes sitting on??
There are no settings to change. There is something your code is doing to cause this or you're expecting functionality that isn't there by default.
|
|
|
|
|
I built a database driven application, when i tried to publish this by building my own setup project and what not, when i install and run the program i get errors saying it can't link to the database etc. Does anyone know why or, what's the proper procedure for publishing database driven apps, do i need to include the database in the setup file?
|
|
|
|
|
you need not to include the database file in the set-up project,but you have to install the database in the machine where the application is running.......moreover if its a client-server application then install the database in the server......
and finally check for the connection string whether it is pointing to the right database in the right machine or not......
Tirtha
Do not go where the path may lead, go instead where there is no path and leave a trail.
Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
|
|
|
|
|
ok. how do i install the database and what not and set the connection string correctly?
|
|
|
|
|
First, you have to say which database you're using. Sql Server, MySQL, Access?? Then you have to tell us what deployment method you're using. Is it ClickOnce, or a Setup and Deployment project, creating an .MSI installation, or something else??
|
|
|
|
|
Ok i'm doing a setup deployment project using an SQL database.
|
|
|
|
|
There's nothing to deploy. You can either build the connection string at deployment time using custom actions, or, a more flexible option, is you have this is a setting in your application and you create a new connection string using a template, filling in the server name.
|
|
|
|
|
ok...you make it sound simple, but maybe i should clarify. I am really just getting the hang of database stuff so i don't know exactly how to do what you are telling me. As far as i know the connection string is in a setting, i just don't know how to set it properly to the computer it gets installed on, i figure i do it on form load, but how exactly would i go about it.
Here is the default connection string in settings:
Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PasswordManager.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
Do you think you could be so kind as to explain it all to me please. Please if you could explain what i have to change and how.
|
|
|
|
|
If you're installing SQLExpress, then all you need to do is put the .MDF file in the same folder as your executable, under the Program Files folder. The |DataDirectory| path of the connection string is automatically replaced with the path your .EXE was launched from. You don't have to do anything else to your installation. Nor do you have to do anything in your application or the connection string.
So, if your .EXE is launched from "C:\Program Files\MyCompany\MyApplication\app.exe", the |DataDirectory| replacement will get "C:\Program Files\MyCompany\MyApplication". This results in a connection string that looks like:
Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\MyCompany\MyApplication\PasswordManager.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True
|
|
|
|
|
i'm beginning to sound dumber and dumber here, but how do i put the database in the folder, through the deployment project or programmatically?
|
|
|
|
|
The deployment project. Right-click the Application Folder in the File System, pick Add, then Project Output. In the dialog that shows up, click on Content, then OK. Rebuild the solution.
|
|
|
|
|
Its all working now, thanks a heap for your help, i've learnt some valuable information. Thanks again.
P.S. I must say, as cynical as you sometimes seem, you are one of the most effective helpers on here and well and truly deserving of the MVP.
|
|
|
|
|
I tend to add a bunch of sarcasm to what I say, though I do get short with people who don't bother to help themselves. I'm definitely not saying that you're one of them.
|
|
|
|
|
Have a program in VB.Net 2003 that retrieves data from an access database. Now i have a project to do that must use Web Services Standards SOAP or WSDL etc. With the VB.Net 2003 and access database on either the client or server and then by the use of Web Services on the either client or server with different language Java,PHP,PERL,PYTHON etc retrieve the information from the VB.net forms that has retrieved the information from the access database by the easiest means possible. I was thinking of Java. But i am open to any ideas please.
|
|
|
|
|
Hi Kendo17
You are Explaining many things at the same time.le tme try to Understand this. Do you want Consume webservice from a Windows Application?,
Do you want to Access the data from the Webservice using your VB Presentation layer?
Take this simple road
Create your Data Access Layer,Business Layer and Presentation Layer. Query your data from a Form through a BLL, and a BLL will Query from DAL and a DAL will Query from an Actual Database.
i have an Article for that, but what you need to know that in your case
DAL will be your Webservice.
http://www.codeproject.com/useritems/N-Tier_Application.asp[^]
Thanks
Vuyiswa Maseko,
Wise Sayings are too Deep for a fool to understand, and when important matters are being discussed, they are not invited.
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Your question doesn't make any sense and is very confusing. I have no idea what you're trying to do, what you have written already, or even what the point of this Web Service is.
|
|
|
|
|
Sorry about the confusion Dave was just in a hurry last night. Thanks for your patience.
I must create a distributed application. It may serve any purpose, as long it is works. Small an complete is better than large and not complete work.
At the very least, it must provide a Web Service, and it must consume the same Web Service. The Web Service must be implemented using generally accepted Web Service standards, such as SOAP, WSDL, etc.
The portion of the application that provides the Web Service must be implemented using a different language, tool set, platform and/or development environment from the portion of the application that consumes the Web Service. For example, i might implement the Web Service in VB.NET, and the Web Service consumer (i.e., client) in PHP. I may not implement both in C#, or both in Java, or both in PHP. Furthermore, developing both under the .NET platform, though using different languages (such as C# and Visual Basic), is not acceptable. I must use significantly different platforms.
Some examples:
• Create a parallel computation application employing one or more Web services to solve a problem, such as determine a sequence of large prime numbers, decrypt a string, or use brute-force to guess a password.
• Create a Web service to act as a front-end for a SQL database, which will respond to arbitrary SQL queries.
|
|
|
|
|
OK. That straightens out the requirements parameters of the assignment. So what's the problem?
|
|
|
|
|
Just enquiring to see what is the best way to go about this and get a professional opinion. If possible some hints to where to start. I am going to try some tutorials online asap and got some books here as well. I am looking for info on the easiest way to set this up on my own of course.
|
|
|
|
|
Pick something for the Web Service to do, like a converter between metric and english units. Then pick a platform and language to write it in. Write the service.
Pick another language and platform to write a consumer app in that calls the Web Service. Write that.
Test, fix, rinse and repeat.
Other than that, I have no idea what you're asking. Where to start on what?? Writing the web service?? Or the consumer app?? Is it the language and/or platforms you don't know anything about?? How about starting with what the languages and platforms you DO know. Those would be ...??
|
|
|
|
|
I have done a little VB.net 2003 front end which retrieves data from access database back end some SQL, i know of JAVA, C# etc but never used them. But looks as if i am going to have to start.
I may employ third-party libraries or source code as part of your application, but the essential functionality – especially the Web Service, above – must be my own creation. Any third-party libraries or source code you use must be credited in comments within your source code, and in the report
|
|
|
|
|
OK. Then start with VB.NET writing the Web Service. Create a simple one first that just takes a number as an argument and returns the same number back.
You don't need a client app to write a web service. When you execute the service, it'll start up it's own web page you can use to test the service.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
