Dear Guys,I am learning to use asp.net to design a web site and i am not quite sure if the way i access the data base is appropriate. could you guys give me some comments ?----------------------------------------in web.config , i have a connection string like this, <add name="MyDBConn"
connectionString="Server=.\SQLEXPRESS;Database=DBSys;User Id=WebSiteUser;password= 12345678;"
providerName="System.Data.SqlClient"/> <add name="MyConnString" connectionString="Server=IPAddress;Database=MyDB;User Id=MyUserID;password= Password;" providerName="System.Data.SqlClient"/> ----------------------------------------in aspx code behind file,Protected Sub cmdGo_Click(ByVal sender As Object, ByVal e AsSystem.Web.UI.ImageClickEventArgs) Handles cmdGo.Click dim rDS as Dataset = nothingif DBSQL.checkQuantity( inProductID , rDS ) then'*** Show the quantity if it returns trueelse'*** Redirect to error message endend sub --------------------------------------------------in a VB file called DBSQL.vb Public Class DBSQLpublic shared Function CheckQuantity( byval inProductID as string , byref rDS as dataset ) as booleandim rResult as boolean = false ' Here i will
View Complete Post