Hello all

I am using microsoft enterprise libraries for the first time, I wrote code to create database object and command, then I execute the command using Executedataset(command Object), I have no problem till this, then I try to get a datatable for the first item, to asign it to the Gridview I have, I got a null referance exception ..

Here is my code:

FileConfigurationSource fileSource = new FileConfigurationSource(@"filesource.config"); DatabaseProviderFactory dbFactory = new DatabaseProviderFactory(fileSource);

Database dbLTC = dbFactory.Create("LTCConnectionString");

DbCommand dbCommand = dbLTC.GetSqlStringCommand("select rin from master where officeid = 107"); try {

GridView1.DataSource = dset.Tables[0];

GridView1.DataBind();

Thanks and best regards

Hi Waleed,
Can you provide with the stack trace of the exception?

Regards,
CodeCanvas

Thanks for reply ...

Here is what I belive is the stack trace of the exception:

at RadMaster.Page_Load(Object sender, EventArgs e) in c:\Waleed Seada\dotNet\WebDev\RADAPP\RadMaster.master.cs:line 40
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hope that helps

Thanks and best regards

Hi Waleed Seada,

The null value is because the ExecuteDataSet evaluated to an empty dataset. So there is no table in the 0 location. Check your query against the database. See if you get results. If not then this is your problem. If it does return records, let me know and i will try to help.

Regards,