|
You are able to verify in your code if the person has rights . If the person is an admin, you execute a different sql statment, if he/she is just a user also just execute a different sql statement and so on...
Therefore, First you should check the credentials of a user and then execute a different statment. I think this is the easiet way to do it. Also You can perform pesimistic or optimistic record lockings as well when you initialize a table which will prevent an user not to perform some certain tasks in the specific table.
I hope that helps. 
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Sir/Madam,
Can i programically find out the no of users that have made the account on my operating system in vb.net 2005
I can find out the name of the user who started the thread.
By
System.Environment.Username
Thanks and regards
Pankaj Garg
|
|
|
|
|
Are you asking how to find out how many people are logged in on a machine?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sir/Madam,
can i programically create the dsn in vb.net 2005 .I want to connect my Window application to Microsoft access database.Presently , I connect to the database my manually creating the dsn.
Please help.
Thanks and regards
Pankaj
|
|
|
|
|
You don't even need a DSN. All you need to do is build the connection string in your code. You can find the format of various connection string for Access, and just about any other database, at http://www.connectionstrings.com[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
open file dialog box selected path in message box
|
|
|
|
|
messagebox.show(openfiledialog.selectedpath.tostring)
Posted by The ANZAC
|
|
|
|
|
Hey everyone,
I am just playing round with a Visual Basic.net application. I would like to be able to do the following two things and was wondering if you could provide some guidance:
1. Terminate A running Process.
I was wondering if you could help me by giving me examples of terminating a process. The process I want to terminate is explore.exe.
2. Sending an email
I would also like to send an email based on the input received. Do you have any resources on doing this?
Thanks,
Brad
Brad
Australian
- Me on "Public interest"
If you actually read this let me know.
|
|
|
|
|
Process:
The System.diagnostics.process class provides a framework for interacting with processes. To kill a process, use the following.
System.Diagnostics.Process.Kill("explore.exe")
Email:
To use email functions you will want to deal with the system.net. To send an email is quite simple.
Dim m As New MailMessage(From, To, Subject, Body)<br />
Dim a As New Attachment(a file to attach)<br />
Dim c As New SmtpClient<br />
m.Attachments.Add(a)<br />
c.Host = name of the server (your internet provider)'eg mail@bigpond.com<br />
Try<br />
c.Send(m)<br />
MessageBox.Show("Mail Sent Successfully!", "Success!", MessageBoxButtons.OK)<br />
Me.Close()<br />
Catch ex As Exception<br />
MessageBox.Show("Mail could not be sent!", "Failed!", MessageBoxButtons.OK)<br />
End Try
Posted by The ANZAC
|
|
|
|
|
I am using the same method .But i am getting the error
Failure sanding mail.
My machine is on network(I mean i can access the surf the internet on my machine).Still getting the fatal error.
|
|
|
|
|
It's considered VERY rude to hyjack someone else's thread. You've already asked your question and got an answer on your own thread.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks mate, that is really useful.
I am just trying to get the process part to work and it seems to be giving all kinds of crazy errors. Would you mind posting a small example of it in use?
Brad
Australian
- Christian Graus on "Best books for VBscript"
A big thick one, so you can whack yourself on the head with it.
|
|
|
|
|
The example he gave for killing a process wont work.
This will, but mind you it's a quick and dirty example:
Private Sub KillProcessByName(ByVal processName As String)
For Each p As Process In Process.GetProcessesByName(processName)
p.CloseMainWindow()
' If that doesn't work you can use:
' p.Kill()
Next
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
what are the steps i have to follow inorder to scan a barcode from a product?
if i have a hand-held barcode scanner, what are the coding i have to do?
thanks
|
|
|
|
|
It shouldn't take much code to scan a barcode. Today's barcode scanners do all the processing of the barcode and are simply an input device no different than a keyboard.
If you have your scanner hooked up, move focus to a text box on your form and scan a barcode. The textual representation of that barcode should appear in the textbox.
Hope this helps.
|
|
|
|
|
Sir/Madam,
Please tell me DLL name for using Outlook Express (for Messaging) in VB.Net 2003
Thanks and regards
Pankaj
|
|
|
|
|
You don't. Under .NET 1.1, what you're looking for is under the System.Web.Mail[^] namespace. This will send messages using CDOSYS.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sir/Madam,
I was trying a project in vb.net.I don't have all the initial requirements.I wanted to design my database.Now my question is database designing is based on form designing or the requirement phase.
Thanks and regards
Pankaj garg
|
|
|
|
|
amaneet wrote: Now my question is database designing is based on form designing
No. Do not base the design of the database on the design of the forms.
Most tables represent entities in the system (people, products, orders, customers, employees, etc.) Start with identifying the main entities. Then go around again and see what sort of relationship they have with each other. Perhaps you'll discover more entities you didn't think about before.
Take a look at sample databases (such as Northwind or AdventureWorks) to see how they fit together - It might give you some ideas.
However, if this is the first time you have tried to design a database, the best approach, in my opinion, is to get someone to mentor you through the process. Someone who has read and understood the requirements. Someone who can explain why certain design descisions were made and what the benefits and disadvantages were.
|
|
|
|
|
|
Sir/Madam,
Can i programically find out the IP address of my machine in vb.net 2005
Thanks and regards
Pankaj
|
|
|
|
|
Yes. How you do depends on what IP address you want. You can get the local IP address used by the computer by examining the network card(s). This is a rather common question, you should be able to search for it in the forum.
If you are behind a firewall or router and want the external IP address, you have to send a request to a server outside the local network that returns the IP address to you.
---
single minded; short sighted; long gone;
|
|
|
|
|
Sir,
Can u please provide the code to get the ip address of my machine programically in vb.net 2005
Thanks and Regards
Pankaj
|
|
|
|
|
A little haiku in the morning:
Few simple words
In search engine I type
Instant gratification
Have a look at this article:
The Code Project: How To Get IP Address Of A Machine[^]
The code is in C#, but it has what you need.
---
single minded; short sighted; long gone;
|
|
|
|
|
Thank You Sir.It is working very fine.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
