"Ok remember that you require the creation of a connection object inorder to access the SQL Database. The basics for the connection string (the means of creating this connection object) is;


Imports System.Data.SqlClient
...
Dim oSQLConn As SqlConnection = New SqlConnection()
....

"

The updated heading to all ASP.Net Page Code Behinds (still using VB.Net):

Help with Code Tags

(Toggle Plain Text)

  '   |||||   This is the Connections Object for an SQL DB
  Dim MyConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
  

' ||||| This is the Connections Object for an SQL DB Dim MyConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("strConn"))

The updated heading to all ASP.Net Page Code Behinds (still using VB.Net):

Help with Code Tags

(Toggle Plain Text)

  Imports System.Web.Security '   |||||   Required Class for Authentication
  Imports System.Data '   |||||   DB Accessing Import
  Imports System.Data.SqlClient
  Imports System.Configuration	'   ||||||  Required for Web.Config appSettings |||||
  

Imports System.Web.Security ' ||||| Required Class for Authentication Imports System.Data ' ||||| DB Accessing Import Imports System.Data.SqlClient Imports System.Configuration ' |||||| Required for Web.Config appSettings |||||

New Web.Config (partial code only, not the whole file)

Help with Code Tags

(Toggle Plain Text)

  <?xml version="1.0" encoding="utf-8"?> <configuration>  <!-- ||||| Application Settings ||||| -->  
   <appSettings> 
   <add key="strConn" value="Provider=SQLOLEDB;Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI;"/>  
  </appSettings> 
  <system.web>
  ...
  

<?xml version="1.0" encoding="utf-8"?> <configuration> <!-- ||||| Application Settings ||||| --> <appSettings> <add key="strConn" value="Provider=SQLOLEDB;Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI;"/> </appSettings> <system.web> ...

The SQL Server .NET Data Provider allows you to connect to a Microsoft SQL Server 7.0 or 2000 database. For Microsoft SQL Server 6.5 or earlier, use the OLE DB .NET Data Provider with the "SQL Server OLE DB Provider" (SQLOLEDB).

Note: The SQL Server .NET Data Provider knows which data provider it is. Hence the "provider=" part of the connection string is not needed.

I'm using SQLServer 7.0

My strConnection in web.config
<appSettings>
<add key="connString" value="server=myDBServer;uid=myid;pwd=myPass;database=myDB" />
</appSettings>

For SQL, I common out the Access thing, and use the syntax for SQL as you suggested:

' First is the Connection Object for an Access DB
' Dim MyConn As OleDbConnection = New OleDbConnection(ConfigurationSettings.AppSettings("connString"))

' This is the Connections Object for an SQL DB
SqlConnection(ConfigurationSettings.AppSettings("connString"))

and I got the error here saying that SqlConnection was not declared.
I thought the import we need for SQLServer is Imports System.Data.SqlClient
not Imports System.Data.OleDb

I just try to create my own member.db and run the sp_ValidateUser which can return 1 but the asp.net just always pass to the

Catch ex As Exception
lblMessage.Text = "Error Connecting to Database!"

when it reach the below statement
objReader = MyCmd.ExecuteReader(CommandBehavior.CloseConnection)

Please help....

Thanks for your help and being so patient with me. This is my very first attempt to work with .net so please excuse me for my dumb question. I'm still having a hard time to convert your code to work with SQL Server. Thanks.

FormsAuthentication.RedirectFromLoginPage(txtUserName.Text, False) ' ||||| default.aspx Page!

hi in your code u make a function but whats it s parameters plz mail me so i do it
i m new in asp.net