Member Avatar for sai_kishor5

hi,

I am a beginner of visual basic programming. I know form designing and can write the source code also.But i would like to know how can i store my data in the project or programming.Means how to create and use databases in VB. Please give me the reply as soon as possible.

From
Sai Kishore

  • 5 Contributors
  • 6 Replies
  • 125 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by steve585

Dani AI

Generated

asked how to create and use databases in VB. The exact path depends on which Visual Basic is being used: legacy VB6 typically uses ADO + OLE DB/ODBC drivers, while modern VB.NET uses ADO.NET providers (SqlClient, OleDb, Odbc) or third‑party providers (SQLite, MySQL). Other forum suggestions (for example recommending learning and noting a bought sample project can save time) are both valid—sample projects help fast understanding, but learning the basic workflow prevents fragile copy/paste solutions.

A minimal practical workflow

  • Pick a database engine (Access or SQLite for single‑file desktop apps; SQL Server Express for multiuser; MySQL/Postgres for server apps).
  • Create the database and tables with the engine’s management tool (Access, SSMS, SQLiteStudio, MySQL Workbench).
  • Choose the provider (SqlClient for SQL Server, OleDb for Access, etc.) and a correct connection string (see ConnectionStrings.com).
  • Use parameterized commands, transactions for multi-step updates, and proper disposal of connections (Using blocks in VB.NET).
  • For UI apps, prefer data binding (DataSet/DataTable or BindingSource + DataGridView) for faster development.

Example (VB.NET, SqlClient) — open, query safely and dispose:

Dim cs As String = "Server=.\SQLEXPRESS;Database=MyDb;Integrated Security=True;"
Using cn As New System.Data.SqlClient.SqlConnection(cs)
    cn.Open()
    Using cmd As New System.Data.SqlClient.SqlCommand("SELECT Name, Age FROM People WHERE Id = @id", cn)
        cmd.Parameters.AddWithValue("@id", 1)
        Using rdr As System.Data.SqlClient.SqlDataReader = cmd.ExecuteReader()
            If rdr.Read() Then
                Dim name As String = rdr.GetString(0)
                Dim age As Integer = rdr.GetInt32(1)
            End If
        End Using
    End Using
End Using

Troubleshooting and cautions

  • Mismatched drivers (32‑bit vs 64‑bit) and missing OLEDB providers are common blockers.
  • File permissions and file locking matter for file-based DBs (Access/SQLite). Ensure the app has write access.
  • Always use parameters to avoid SQL injection. Store connection strings in a config file for deployment.
    Further reading: Microsoft’s ADO.NET overview is a reliable reference ().

Recommended Answers

All 6 Replies

Member Avatar for debasisdas

That is quiet simple but too vast to expalin over here. Please follow a good book for the same. You also find a lot of related topic / code here by using the search utility in this forum itself.

Member Avatar for choudhuryshouvi

check out this sample project.

DeleteAll.zip (14.4 KB)
Member Avatar for RonR

I had this same question several years ago.

I went to "" and posted a project that simply had the code required to open a DB which also included a database.

all i had to do was to use it like a "Rosetta Stone"

as i recall i paid less than $100.00.

Member Avatar for debasisdas

I trhink it is better to learn by youself than paying to anyone fo these simple things.

Member Avatar for RonR

I agree, it is better to learn independantly but in my case it was a "time" issue. I needed
the info quick.

Member Avatar for steve585

Do you have this line in your code

Printer.KillDoc

sorry wrong post

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.