Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 3rd, 2006, 06:34 AM
Authorized User
 
Join Date: Mar 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error when filling DataAdaptor.FIll

 Hi All,

I have a code like here below.
When I run it, I get an eeror message : "No value given for one or more required parameters."
at the line 12 (with bold & undeline)

My code :
---------------
1 Private Sub OpenFile()
2 Dim conJarig as New OleDb.OleDbConnection
3 Dim bulan As Integer = Now.Month
4 Dim sqlString As String
5 conJarig.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
6 & "Data Source =C:\Inetpub\wwwroot\Juliando\DataFile\verjaardagen .mdb;" _
7 & "USER ID = Admin; Password =;"
8 sqlString = "SELECT naam, geslacht, MONTH(geboortedatum) AS maan " & _
9 "FROM jarig WHERE maan = '" & bulan & "' ORDER BY maan"
10 Dim jad As New OleDb.OleDbDataAdapter(sqlString, conJarig)
11 Dim ds As DataSet = New DataSet
12 jad.Fill(ds, "jarig")
13
14 davJarig.Table = dasJarig.Tables(0)
15 If Not IsPostBack Then
16 Session("rij") = 0
17 Session("sort") = "geboortedatum"
18 End If
19 davJarig.Sort = Session("sort")
20 End Sub
-----------------

What's wrong with my code ?
Can anybody correct it, please ?

Rgds,
Juliando






Similar Threads
Thread Thread Starter Forum Replies Last Post
Divide by Zero Error [this.Adapter.Fill(dataTable) miamikk ASP.NET 1.x and 2.0 Application Design 0 October 30th, 2006 04:26 PM
Functionality of dataadaptor haribala.raj General .NET 1 September 13th, 2005 01:01 PM
Data Filling error after Relation melvik ADO.NET 2 December 29th, 2004 06:19 PM
Cant fill datagrid with dataset (databinding error Tsjelle Pro VB.NET 2002/2003 1 April 5th, 2004 12:36 PM
filling of dataset abhimca_1 ADO.NET 2 August 5th, 2003 03:05 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.