<div>
try to use a datareader, before binding the datasource of gridview1,hope the below might might give some hint for you.<br />
<a href="http://www.adefwebserver.com/DotNetNukeHELP/Misc/code/DynamicForms_DynamicForms_DAL.vb.htm" rel="ugc">http://www.adefwebserver.com/DotNetNukeHELP/Misc/code/DynamicForms_DynamicForms_DAL.vb.htm</a>
</div>


try to use a datareader, before binding the datasource of gridview1,hope the below might might give some hint for you.
http://www.adefwebserver.com/DotNetNukeHELP/Misc/code/DynamicForms_DynamicForms_DAL.vb.htm [http://www.adefwebserver.com/DotNetNukeHELP/Misc/code/DynamicForms_DynamicForms_DAL.vb.htm]

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I am using the following code to get the data from database and bind it to gridview.<br />
<br />
dim &nbsp;mySqlString = &quot;Select columname from table where xyz = 1&quot;<br />
Me.Gridview1.DataSource = CType(DataProvider.Instanc<wbr />e().Execut<wbr />eSQL(mySql<wbr />String.ToS<wbr />tring(), myParam), IDataReader)<br />
Me.Gridview1.DataBind()<br />
<br />
How can check if the query returned no rows before binding it to database.<br />
<br />
Thanks<br />
<br />
<br />
<br />

</div>
</div>


Hi 

I am using the following code to get the data from database and bind it to gridview.

dim  mySqlString = "Select columname from table where xyz = 1"
Me.Gridview1.DataSource = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), myParam), IDataReader)
Me.Gridview1.DataBind()

How can check if the query returned no rows before binding it to database.

Thanks





how to check if datasource is empty before binding it to gridview in asp.net

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,