New to VB.NET

Thank you - your coding is very helpful in telling me what I need to do.

In implementing the coding, I notice that the variable types SqlCommand and SqlParameter are not defined. Do I use a Private declaration at the top of the WebForm.aspx page? Could you tell me the syntax for the Private statements?

Also, when I pasted in the "DB string connection" which I got from the connection properties on the form designer, there is a problem with the syntax. The string is as follows:
"Dim Conn As SqlConnection1 = "workstation id="RAY-XP"; packet size=4096;user id=sa;data source=ATLANTIS;persist security info=False;initial catalog=Unison"
The error msg is: "End of statement expexted"

Thanks again for getting me started.

Michael

Cause you have quotes around RAY-XP.. it thinks that the string ends there.. take those out.
As for command and parameter not being defined, you have to add Imports system.data.sqlclient  and Imports system.data to the top of you code behind page. Good luck!
also this should look like  this
  dgYourDG.DataSource = objSPComm.ExecuteReader()
  dgYourDG.Databind() <--- from DB to DG sorry (:

Well, my code has two remaining error msgs which are:
1) SqlConnection1 is not defined
2) DBDate is not a member of System.Data.SqlDbType
What do I need to add to rectify these errors?

Coding for the whole form is currently as follows:


Imports System.data.sqlclient
Imports System.data

Public Class WebForm1

    Inherits System.Web.UI.Page

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here

        Dim Conn As SqlConnection1 = "workstation id=RAY-XP; packet size=4096;user id=sa;data source=ATLANTIS;persist security info=False;initial catalog=Unison"
        Dim objSPComm As New SqlCommand("ContactCount", Conn)
        objSPComm.CommandType = CommandType.StoredProcedure

        Dim CC As SqlParameter = New SqlParameter("@StartDate", SqlDbType.DBDate, 50)
        CC.Direction = ParameterDirection.Input
        objSPComm.Parameters.Add(CC)

        Dim CC1 As SqlParameter = New SqlParameter("@EndDate", SqlDbType.DBDate, 50)
        CC1.Direction = ParameterDirection.Input
        objSPComm.Parameters.Add(CC1)

        Dim CC2 As SqlParameter = New SqlParameter("@Name", SqlDbType.VarChar, 50)
        CC2.Direction = ParameterDirection.Input
        objSPComm.Parameters.Add(CC2)


        Conn.Open()
        dgClaims.DataSource = objSPComm.ExecuteReader()
        dgClaims.DataBind()
        Conn.Close()

    End Sub

End Class

Thanks,
Michael

SqlConnection1 should just be SqlConnection

and

DBDate should be DateTime

I think (:

Thanks for the quick response.
Changing to DateTime fixes error msg. 2) above.

When I change  SqlConnection1 to SqlConnection, the error shifts over to the "workstation id=RAY-XP; packet....." side, stating that "Value of type "string" cannot be converted to 'System.data.sqlclient.SqlConnection' "

I though I had to declare SqlConnection1 somewhere.

What am I missing?
Michael

try this..

Dim strConn as String = "workstation id=RAY-XP; packet size=4096;user id=sa;data source=ATLANTIS;persist security info=False;initial catalog=Unison"
Dim objConn as new sqlConnection(strConn)
Dim objSPComm As New SqlCommand("ContactCount", Conn)

Thank you. Later, I'd like to ask you to explain the coding you gave me. For now though, even though I have no further errors in the coding, I still have a login problem. When I run the application, it fails with the following error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'.

Source Error:

Line 755:        objSPComm.Parameters.Add(CC2)
Line 756:
Line 757:        objConn.Open()
Line 758:        dgClaims.DataSource = objSPComm.ExecuteReader()
Line 759:        dgClaims.DataBind()
 
Source File: c:\inetpub\wwwroot\MotorolaWarrantyClaim\WebForm1.aspx.vb    Line: 757

Stack Trace:

[SqlException: Login failed for user 'sa'.]
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnection.Open()
   MotorolaWarrantyClaim.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\MotorolaWarrantyClaim\WebForm1.aspx.vb:757
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()"

 Any ideas? (BTW, tell me if I am taking up too much of your time)
Michael