You should check your DataReader to see if it "HasRows". The HasRows
property returns true or false. If you don't have rows, you won't get any
items in your combo.
if (OdbcDR.HasRows)
{
while (OdbcDr.Read())
{
..
}
}
else
{
// hey no data!
}
On Mon, Aug 31, 2009 at 3:54 PM, VIKAS GARG <[email protected]>wrote:
>
> while (OdbcDr.Read())
> {
>
> // Getting the data off DataReader in a string...
> string DRData = (string)OdbcDr[0];//Here
> OdbcDr is DataReader's object
>
> //Adding the data to the combobox
> Combo.Items.Add(DRData);
> }
>
> On 9/1/09, AstroDrabb <[email protected]> wrote:
> > Oh, P.S. you need VS Pro or greater to do this.
> >
> > On Mon, Aug 31, 2009 at 2:55 PM, AstroDrabb <[email protected]>
> wrote:
> >
> >> You can debug the stored procedures and SQL. At least in SQL Server
> since
> >> 2000. However SQL Server 2005 moved it out to Visual Studio.
> >>
> >>
> >> As for the original Q, show the code you are using to populate the drop
> >> down.
> >>
> >> On Mon, Aug 31, 2009 at 2:00 PM, Cerebrus <[email protected]> wrote:
> >>
> >>> (I don't know how anyone can debug a database)
>
