How to bring the Ms-Access DB record to a DropdownList?

[Praveen 123]

the following code is for connecting a DropdownList with a Ms-access record but its not working.....Pleas help me Dim DBConnection As System.Data.OleDb.OleDbConnection Dim DBCommand As System.Data.OleDb.OleDbCommand Dim DBReader As System.Data.OleDb.OleDbDataReader Dim SQLString As String Dim DataSet1 As System.Data.DataSet If Not Page.IsPostBack Then DBConnection = New System.Data.OleDb.OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\All Users\Documents\Attendance\BTA_ DB_Design\BTAS.mdb") DBConnection.Open() DBCommand = New OleDb.OleDbCommand("SELECT Employee_ID FROM Attendance_Details", DBConnection) OleDbDataAdapter1.SelectCommand = DBCommand OleDbDataAdapter1.Fill(DataSet1, "Attendance_Details") DropDownList1.DataSource = DataSet1.Tables("Attendance_Details") DropDownList1.DataValueField = "Employee_ID" DropDownList1.DataBind() DBReader.Close() DBConnection.Close() Error:-Value cannot be null. Parameter name: dataSet

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[krishnakumark]

Initialize data set before filling it ... like .. DataSet1 = New DataSet OleDbDataAdapter1.Fill(DataSet1, "Attendance_Details") also remove DBReader.Close() .. because you have not used it at alll...

Kk

[Praveen 123]

sir after the specified modification the following line of error is appearing. 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.NullReferenceException: Object reference not set to an instance of an object. Source of error::: ----------------------------------- DBConnection.Open() Line 39: DBCommand = New OleDb.OleDbCommand("SELECT Employee_ID FROM Attendance_Details", DBConnection) Error line:-Line 40: OleDbDataAdapter1.SelectCommand = DBCommand Line 41: DataSet1 = New DataSet Line 42: OleDbDataAdapter1.Fill(DataSet1, "Attendance_Details") -- modified at 23:39 Wednesday 31st January, 2007

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[krishnakumark]

Hi it should look similer to this.. i tried here.. its working fine...did you remove the statement DBReader.Close() ????? Dim DBConnection As System.Data.OleDb.OleDbConnection Dim DBCommand As System.Data.OleDb.OleDbCommand Dim DBReader As System.Data.OleDb.OleDbDataReader Dim SQLString As String Dim DataSet1 As System.Data.DataSet If Not Page.IsPostBack Then DBConnection = New System.Data.OleDb.OleDbConnection( _ "put your connection string here") DBConnection.Open() DBCommand = New OleDb.OleDbCommand("select email from users", DBConnection) OleDbDataAdapter1.SelectCommand = DBCommand DataSet1 = New DataSet OleDbDataAdapter1.Fill(DataSet1, "Attendance_Details") DropDownList1.DataSource = DataSet1.Tables("Attendance_Details") DropDownList1.DataValueField = "email" DropDownList1.DataBind() DBConnection.Close() End If

Kk

[Praveen 123]

yes, Its working sir.the problem was with my database...The problem was when i am working with a database in a user permission account i cant access the DB.When i changed the location of the DB to some other system directory, it works.Any way thanks for u'r asistance. Regards

Praveen.K System Engineer Graviton Technologies Pvt.Ltd