Hi! this is kk. I have been trying to connect to sql db server2000 using asp.net thru stored procedure. but while retreiving the result
parameter from the stored procedure, its given the error:
Syntax error converting the varchar value 'new' to a column of data type int.

Can anybody help me please to solve this problem i've written the follg code. i declared all the vars before page load, and used a fun for connection

Function CONCODE()
        CON = New SqlConnection("Persist Security Info=False;User ID=sa;Initial Catalog=phones4u;Data Source=ANSHULBA")
        Return CON
    End Function


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            QUERY = "pro_to_cheq_logindetails"
            CMD = New SqlCommand(QUERY, CONCODE())
            CON.Open()
            CMD.CommandType = CommandType.StoredProcedure
            CMD.Parameters.Add("@userid", LTrim(RTrim(TextBox1.Text)))
            CMD.Parameters.Add("@pwd", LTrim(RTrim(TextBox2.Text)))
            Dim p1 As SqlParameter
            p1 = CMD.Parameters.Add("@res", SqlDbType.VarChar)
            p1.Size = 3
            p1.Direction = ParameterDirection.Output
            p1.DbType = DbType.String
            CMD.ExecuteNonQuery()
            Dim STR As String
            STR = CMD.Parameters("@res").Value
            CON.Close()
            Label3.Text = STR
        Catch ex As Exception
            Label3.Text = ex.Message
        End Try

    End Sub

"'new' to a column of data type int" I think somewhere inside your stored procedure you are generating this error. Do this: run the procedure from query analyzer and supply it some values and see if you get an error.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Hi Krishna,
I'm new, but this is how I use stored procedures with SQL2K from ASP.
I hope you can get some value from it:

cust_code = Session("Cust_Number")

set conn=server.createobject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.open = "Driver={SQL Server}; server=<Insert a valid server name>; database=<Insert a valid database name>; uid=<Insert a valid username>; password=<Insert a valid password>;"

sqlrs="EXEC dbo.CMS_return_audit_survey_data @cust_number = '" & cust_code & "'"
rs.open sqlrs, conn, 2, 2

Note: replace "<Insert a valid ... >" with your actual values.