Why am I having problems filling my dataset when I select fields of type
varchar(350) from interbase? I can fill the dataset when I select every
other field in the table but I receive and error message that says "object
reference not set to an instance of an object" when I return the varchar
field." The detailed error message is below.
Server Error in '/BIC_WEB_TEST' Application.
--------------------------------------------------------------------------------
Object reference not set to an instance of an object.
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.NullRefe renceException: Object reference not set
to an instance of an object.
Source Error:
Line 42: baseconnection. ConnectionStrin g = ConnectString
Line 43: baseconnection. Open()
Line 44: BICDataAdapter. Fill(BICDataSet , "recruit_report _data")
Line 45: Catch ex As System.Data.Odb c.OdbcException
Line 46: ErrorMessage = ex.Message
Source File: c:\inetpub\wwwr oot\BIC_WEB_Tes t\RecruitReport .aspx.vb Line:
44
Stack Trace:
[NullReferenceEx ception: Object reference not set to an instance of an
object.]
System.Data.Odb c.OdbcDataReade r.GetValue(Int3 2 i, TypeMap typemap)
System.Data.Odb c.OdbcDataReade r.GetValue(Int3 2 i)
System.Data.Odb c.OdbcDataReade r.GetValues(Obj ect[] values)
System.Data.Com mon.SchemaMappi ng.LoadDataRow( Boolean clearDataValues ,
Boolean acceptChanges)
System.Data.Com mon.DbDataAdapt er.FillLoadData Row(SchemaMappi ng mapping)
System.Data.Com mon.DbDataAdapt er.FillFromRead er(Object data, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords,
DataColumn parentChapterCo lumn, Object parentChapterVa lue)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
BIC_WEB_TEST.Re cruitReport.Pag e_Load(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\BIC_WEB_Tes t\RecruitReport .aspx.vb:44
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()
--
Derek V. Taylor
UCI Brain Imaging Center
varchar(350) from interbase? I can fill the dataset when I select every
other field in the table but I receive and error message that says "object
reference not set to an instance of an object" when I return the varchar
field." The detailed error message is below.
Server Error in '/BIC_WEB_TEST' Application.
--------------------------------------------------------------------------------
Object reference not set to an instance of an object.
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.NullRefe renceException: Object reference not set
to an instance of an object.
Source Error:
Line 42: baseconnection. ConnectionStrin g = ConnectString
Line 43: baseconnection. Open()
Line 44: BICDataAdapter. Fill(BICDataSet , "recruit_report _data")
Line 45: Catch ex As System.Data.Odb c.OdbcException
Line 46: ErrorMessage = ex.Message
Source File: c:\inetpub\wwwr oot\BIC_WEB_Tes t\RecruitReport .aspx.vb Line:
44
Stack Trace:
[NullReferenceEx ception: Object reference not set to an instance of an
object.]
System.Data.Odb c.OdbcDataReade r.GetValue(Int3 2 i, TypeMap typemap)
System.Data.Odb c.OdbcDataReade r.GetValue(Int3 2 i)
System.Data.Odb c.OdbcDataReade r.GetValues(Obj ect[] values)
System.Data.Com mon.SchemaMappi ng.LoadDataRow( Boolean clearDataValues ,
Boolean acceptChanges)
System.Data.Com mon.DbDataAdapt er.FillLoadData Row(SchemaMappi ng mapping)
System.Data.Com mon.DbDataAdapt er.FillFromRead er(Object data, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords,
DataColumn parentChapterCo lumn, Object parentChapterVa lue)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
BIC_WEB_TEST.Re cruitReport.Pag e_Load(Object sender, EventArgs e) in
c:\inetpub\wwwr oot\BIC_WEB_Tes t\RecruitReport .aspx.vb:44
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()
--
Derek V. Taylor
UCI Brain Imaging Center