Re: ADO.net: 3 Data Set Questions (Issues)

From: Earl (brikshoe_at_newsgroups.nospam)
Date: 06/26/04 

Date: Sat, 26 Jun 2004 15:13:27 -0500

 IsDbNull and use a DataView for each combo

"Mr. B" <User@NoWhere.com> wrote in message
news:ruird0l5usc5b1pdqb99fns1c5r8g6f4o5@4ax.com...
> I'm updating my current VB.et application. I currently reads about 6
tables
> from an MS Data base. I've created a new MDB file which combines the 6
tables
> into 1 table. I'm doing this because I know I'll speed up my application
> loading time by more than 10 seconds (out of about 20).
>
> I've run across three situations in which I'm stuck at:
>
> Issue One:
>
> If my largest Column has (say) 200 lines, other columns will have less
data
> lines. So say Column 1 has 50 lines of data, column 2 has 200 lines and
> column 3 has 150 lines. Then column 1 and 3 will have lines containing
> nothing (ie null or blank lines).
>
> How to I test for a 'null' in a FOR statement? This is so that I can tell
> when I've hit the end of my data for that column?
>
>
> Issue Two:
>
> For the above, How can I get rid of any blank lines when I bind the
Datasource
> to a ComboBox pull down? Column 3 will have 50 lines of blank. So if I
sort
> a ComboBox, the first 50 lines are blank! :(
>
>
> Issue Three:
>
> I've several ComboBox pulldowns which are bind to the same data set. But
if I
> change one, then the all change! How can I control them independantly?
>
> For example, if I have 6 ComboBoxes. They are all bound to the same Data
> Source, but each one is bound to a different Member of that Data Source.
>
> So say I want to have 1 and 2 related (one changes, so does the other)...
then
> 3 and 4 paired together similar as 1 and 2, and 5 and 6 completely
independant
> from all the others?
>
> Mucho Appreciated!
>
> Bruce

Relevant Pages

  • Re: ADO.net: 3 Data Set Questions (Issues)
    ... > from an MS Data base. ... > I've several ComboBox pulldowns which are bind to the same data set. ... but each one is bound to a different Member of that Data Source. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.net: 3 Data Set Questions (Issues)
    ... > from an MS Data base. ... > I've several ComboBox pulldowns which are bind to the same data set. ... but each one is bound to a different Member of that Data Source. ...
    (microsoft.public.dotnet.general)
  • Re: Simple Threading Problem with WinForm
    ... // The delegate to call the method to set the data source. ... including your update of the status bar. ... Also, if you bind to dsLocal.Tables, the data grid will automatically ... > StatusBar control. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Simple Threading Problem with WinForm
    ... > // The delegate to call the method to set the data source. ... including your update of the status bar. ... > automatically bind to the DefaultView property on that table, ... >> private void mnuGetDocuments_Click ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Simple Threading Problem with WinForm
    ... > // The delegate to call the method to set the data source. ... including your update of the status bar. ... > automatically bind to the DefaultView property on that table, ... >> private void mnuGetDocuments_Click ...
    (microsoft.public.dotnet.languages.csharp)