How to write parameter method in VB.NET?

[joggi]

I am new in VB.NET. I need to write connection to database, but the name of database, server, username and password are in INI file. How to write this?
Second, I need to write one parameter method "Select *from Table....." where Table is parameter, so I can use this method for all my tables.
Can anybody help me with this?
Thank you in advance

 

[rjoubert]

First, INI files are a thing of the past. Since you're using .NET now, you should use the app.config file to store such information. Here's a MS support article on using the app.config...

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q313405

Second, you can create a public method to select from any table...

Public Sub SelectAllFromTable (TableName as String)

   Dim strSQL as String

   strSQL = "SELECT * FROM " & TableName

   ...
End Sub

And for Database interaction, look into some tutorials on ADO.NET. Here's a good starting point for you...

http://www.akadia.com/services/dotnet_update_form.html

Good Luck!