Using sample "Guestbook" module for tutorial on building modules.
Have code that presently works with viewing database information.
But I am in need of adaquete feedback on how to properly INSERT data & UPDATE data within the SQL database.
I am familiar with queries, but have found this to be structured to be a bit different.
Noticed that mySqlString.Insert is a tag, but assuming it needs different "dims" and other tags to work properly.
Sufficient feedback on Inserting and Updating sql data would be appreciated.
Code for viewing data:
Dim mySqlString As New StringBuilder()
mySqlString.Append("SELECT FriendlyName, Description ")
mySqlString.Append("FROM {databaseOwner}{objectQualifier}DesktopModules ")
mySqlString.Append("WHERE Description like '%' + @SearchString + '%' ")
mySqlString.Append("ORDER BY FriendlyName")
Dim myParam As SqlParameter = New SqlParameter("@SearchString", SqlDbType.VarChar, 150)
myParam.Value = SearchString
Me.GridView1.DataSource = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), myParam), IDataReader
Me.GridView1.DataBind()
What would the code, dims, and all necessary tags be for INSERT commands?
What would the code, dims, and all necessary tags be for UPDATE commands?