Asp .net + store procedure (sql server 2000)

[gigamaxter]

xylvyna: No tienes que complicarte tanto, usa este codigo que es mas facil.

Dim sqlConn As SqlConnection = New SqlConnection(System.Configuration.ConfigurationMa nager.AppSetti ngs("conn") )
Dim sqlCmd As New SqlCommand("CargarGrillaZona", sqlConn)
sqlCmd.Parameters.Add("@cd_zona", SqlDbType.Int).Value = ddlZona.SelectedItem.ToString
Dim sqlDa As New SqlDataAdapter(sqlCmd)
Dim Dt As New DataTable
sqlDa.Fill(Dt)

Bendiciones.