Check my blog post- http://dotnet.tekyt.info/?p=27

If you still have any doubts, feel free to ask

Maybe you can try something like an automated payroll system?

try this connection string-


Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Hi!

Just verify these-

Do you have the MySQL Connector installed?

Are you sure your connection string is correct?

No luck with port 2525 either, have disabled my firewall too.

Any other troubleshooting steps?

Thanks a lot for your ideas.

I guess I've specifically used this-

http://www.systemwebmail.com/faq/3.8.aspx

The server requires authentication.

I did put valid values in the actual code I used, just did not want to post it here.

Have used a correct smtp server, username, password - sure of that

If I try port 25, I get this message-

System.Web.HttpException: The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available
...

Hi!

This is the code I have for sending mail-



Imports System.Web.Mail

Public Class Form1

Hi!

I have the following code-




Imports System.Data.OleDb
Public Class Form1
Dim x As String = """"

Are you sure you are giving 6 parameters?

Could you paste your SQL Command text again? It appears broken in your previous post.

It can be done using a javascript, just google it and you will get it.

However, you must hope javascript is enabled on your client's browser else it will not work.

Do you know the SQL command to achieve the same?

If so, use a DataReader-



'We have a Data Reader to read the values returned by the SQL Command Execution
'cmd is your SQL command
' I...

Anybody tried it with the ODBC Driver?

Hi all!

I am trying to connect to a remote MySQL database. This database is located on my LAN at the address 192.168.1.2. I am using MySQL Connector/ODBC 3.51 (MyODBC 3.51) for the connection.
...

Maybe this thread should be moved to the databases forum?

Hi all!

I've always used MySQL with my VB.NET applications and I am not too good with MS Office either.

The situation I have now is that in a Word Document, there is a table from which I am...

Here is a much simpler code to generate random passwords. The code is in VB.NET



Public Class Form1

Public Function GenerateRandomPassword(ByVal length As Integer) As String
Dim...

I think he means that the column (i.e. field names) names must be sorted. Not the records

Do you really want your application to do some 'work' ? If so, you can play with loops.

If not, you can use a timer control and code for an event after a defined number of ticks.

Here is the code. You need 2 TextBoxes, 1 Button and 1 ErrorProvider Control on your Login Form. I've used a MySQL database, you may use whatever suits you.



Public Class Login


Dim...

Use another SQL statement. Construct it like this-


Dim strSQL2 As String = "SELECT product_id FROM product where product_name=" & Me.cmbDropDown.SelectedItem

Try this - http://www.connectionstrings.com/

I feel the message box is more intuitive.

You can choose the type of message box, say Critical - when the user sees this (accompanied by the critical system sound) the user knows that an error...

Relax dude!

Post the code here, we will try and figure out the problem.

You need to 'bind' the result of your SQL query to the textbox. This can be done using databindings.

Find the code snippet here- http://dotnet.tekyt.info/?tag=databind

If you want a project that you can finish within a week or less, try to develop an application that can be used in your department to hold attendance and marks.

i.e Attendance Register and Marks...

Alternatively, you can use a Timespan object. I guess this is more elegant-



Public Class Form1
Dim d1, d2 As DateTime
Dim x As TimeSpan

Private Sub Form1_Load(ByVal sender As...

Hi!

This is what I did. I'm writing this @ 14:25 and hence added some hours to simulate your situation. I'm directly taking the datetime but you can do the same from the datetimepicker.



...

I have never tried this, but I guess you can try adding Animated GIF's and play around with the visibility.

I guess the solution to all the problems is the manner in which you have constructed the SQL statement.

You might want to take a look at my blog. In all my VB.NET applications, I have connected to MySQL.



http://dotnet.tekyt.info

You need a Command Builder Object for the Update.

Let us say you got the data on a DataGridView and wish to make changes from the gridview which must be reflected abck into your database. Make a...

try: www.elance.com

I have a 'users' table in which the password is stored using MD5 encryption. (Drupal created this table)


I have my Windows Application in which I have a login window. What I want to do is take...

You can try creating your own Control and define the events and properties as you want them to be.

I guess that will help you as you seem to need multiple 'blinking' buttons.

This is how I did it-




Public Class Form4

Private Sub Form4_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim cn As New...

You are doing this in ASP.NET right?

After Selecting enable Selection, goto Edit Columns from the Smart tag of the GridView.

Under the Selected Fields, you should see the field named 'Select'....

You should use the OR statement in your SQL query.

So your SQL command text should be-



cmd = New OleDbCommand("select * from table1 where MFG='" & Me.ComboBox1.SelectedItem & "' OR MFG='" &...

Hi!

In most of my VB.NET applications, I connect to a MySQL database using a ODBC Connector for MySQL.

In the code snippets posted by fellow members, I saw that OLEDB is also used to connect to...