I hve mysql, tel me hw to create table and hw to attache with v.b?

Use GUI MySQL Administrator to create table. Use MyODBC driver to connect with VB

Try it at: http://www.asp.net or http://msdn.microsoft.com Download Visual Web Developer... its good... and useful for ur question..

go to www.abt vb.com or www.www.mysql.com

quite easy go in projects->components->in control toolbox->check microsoft ado datacontrol 6.0[oledb]->click ok->new icon would appear in tool box->drag it to vbs window->set its recordsource,caption and all other prop according to your need if need more information can email me all the best

1. Download and install sqlyog from download.com ...its too easy to create the database by this software... 2. Download ODBC driver from net and put it in ur project....this driver will do the connecting job .... Good luck :D

i can give u my connection string to interface to mysql from vb.net: 'put these 2 lines above your class header to import ODBC Imports System.Data Imports System.Data.Odbc Dim myConnection As New OdbcConnection Dim myDataAdapter As OdbcDataAdapter Dim myDataSet As DataSet Dim myconstring, strSQL, tempstr As String Dim mycommand As New OdbcCommand myconstring = "DRIVER={MySQL ODBC 3.51 Driver};" & _ "SERVER=localhost;" & _ "DATABASE=mydatabase;" & _ "UID=root;" & _ "PASSWORD=;" & _ "OPTION=3;" myConnection.ConnectionString = myconstring mycommand.Connection = myConnection try myconnection.open() strSQL = "Select * from tbltest" mycommand.commandText = strSQL myDataAdapter = New OdbcDataAdapter(strSQL, myConnection) myDataSet = New DataSet myDataAdapter.Fill(myDataSet, "tbltest") Catch ex As Exception response.write(ex.message) End Try myConnection.Close() pretty much straightforward provided you are using mysql odbc driver version 3.51 and your mysql setup and installation is OK, you should be able to pull out the data from mysql by modifying the query statement and the other fields from my code.. best of luck and regards! drop me an email, i can send you many codes about connecting and using mysql as database and vb.net as the front end program. i will be happy to send you my codes as i am doing a company project using vb.net and mysql. :)