Hi!!!

Thanx for the reply...

I have tried that but still getting the same error. The error type mismatch occurs with the parameter @Users_RowID:

"CREATE PROCEDURE for "user_login1" failed because T-SQL and CLR types for parameter "@Users_RowID" do not match."

Public Shared Sub user_login1(ByVal User_UserName As SqlString, ByVal User_Password As SqlString, ByRef Station As SqlString, <Out()> ByVal Users_RowID As SqlInt32, <Out()> ByVal Users_Name As SqlString, <Out()> ByVal Success As SqlBoolean, <Out()> ByVal Default_Message As SqlString)

...

...

...

sqlparam(0) = New SqlParameter("@User_UserName", SqlDbType.VarChar, 50)

sqlparam(1) = New SqlParameter("@User_Password", SqlDbType.VarChar, 50)

sqlparam(2) = New SqlParameter("@Station", SqlDbType.VarChar)

sqlparam(3) = New SqlParameter("@Users_RowID", SqlDbType.Int, 100, ParameterDirection.Output, False, 0, 0, String.Empty, DataRowVersion.Default, 0)

sqlparam(4) = New SqlParameter("@Users_Name", SqlDbType.VarChar, 100, ParameterDirection.Output, False, 0, 0, String.Empty, DataRowVersion.Default, String.Empty)

sqlparam(5) = New SqlParameter("@Success", SqlDbType.Bit, 1, ParameterDirection.Output, False, 0, 0, String.Empty, DataRowVersion.Default, 0)

sqlparam(6) = New SqlParameter("@Default_Message", SqlDbType.VarChar, 200, ParameterDirection.Output, False, 0, 0, String.Empty, DataRowVersion.Default, String.Empty)

sqlparam(0).Value = User_UserName.Value

sqlparam(1).Value = User_Password.Value

sqlparam(2).Value = Station.Value

sqlparam(3).Value = Users_RowID

sqlparam(4).Value = Users_Name.Value

sqlparam(5).Value = Success

sqlparam(6).Value = Default_Message.Value

...

...

...

LoginCommand.Connection = conn

conn.Open()

LoginCommand.ExecuteNonQuery()

Users_RowID = Convert.ToInt32(sqlparam(3).Value)

Users_Name = Convert.ToString(sqlparam(4).Value)

Success = Convert.ToBoolean(sqlparam(5).Value)

Default_Message = Convert.ToString(sqlparam(6).Value)

conn.Close()