Dynamic Function using MySql and VB.Net

Question

I have one function -

Public Function GetDataTable(ByVal Query As String) As DataTable

Dim dtConnection As New OdbcConnection(ConfigurationManager.ConnectionStrings("DBConnection").ToString)

dtConnection.Open()

Dim dtTable As New DataTable

Dim da As OdbcDataAdapter

da = New OdbcDataAdapter(Query, dtConnection)

da.Fill(dtTable)

da.Dispose()

dtConnection.Close()

Return dtTable

End Function

i am using this funtion in my code behind file like this -

QryStr = "select * from table where UName='" & txtUserName.Text & "'and pwd='" & txtPassword.Text & "'"

dtUsers = DBClass.GetDataTable(QryStr)

so where ever i want to fetch data from database, i am using this function but here statically i am passing query.

i want to pass stored procedure in place of query so how will i create function with parameters so that i will use that function anywhere in application?

rachayita jaiswal · Answer

Hi thanks for reply but this we can use in which case where i know the table name and number of parameters but i want to create a function where for n number of parameters we will use same function?

Kunal Vaishya · Answer

Hi  One more way You can call your function by like this string query = select * from dbo.Function1(12);;

Kunal Vaishya · Answer

Hi  You can call your function by like this string query = select * from dbo.Function1(@pa1@par2);; cmd.Parametes.Add(@par1 SqlDbType.Int).Value = 2); cmd.Parametes.Add(@par2 SqlDbType.Int).Value = 1;