visual basic.net standard 2003 (ado.net)

ADO

    Sponsored Links

    Next

  • 1. Getting a List of Databases in an SQL Server Instance
    I can use the SqlDataSourceEnumerator to get a list of SQL Server instances. How do I obtain a list of databases in a given SQL Server instance?
  • 2. New to Access
    Any suggestions as to which books(currently half way through Access 2003 Bible) I should be reading if I want to learn Access. Being asked to develop a method to download data from Access to Excel via VBA, have no clue how I should approach this issue yet. Any suggestion is greatly appreciated.
  • 3. ADO coding for web
    I manage a website that makes use of several Access databases to generate dynamic content. I would like to ensure that my code approach does not produce inefficiencies. I use the same code in multiple asp pages to open data connections (that is the same variable names, although the connection could be to a different database). My common code: Set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " DSNtemp=dsntemp & "DBQ=" & server.mappath("/database/kassaa.mdb") conn.mode = 3 ' adModeReadWrite conn.Open DSNtemp Could this present a problem? Thanks in advance. Bob Mullen
  • 4. novice in ADO
    I'm first time here , I say all A good day Can somebody please to learn me if ADO can do an autofill method in a closed workbook ? ... ... to do in a closed workbook the same action like in VBA : Range("B91:B7000").Select Selection.AutoFill Destination:=Range("B91:BB7000"), Type:=xlFillDefault ???This is my first information that I need strongly ! 2.The second thing is to know if ADO can do ClearContents in a closed workbook like in VBA code : Sheets("1").Range("C91:BB22005").ClearContents, but with the workbook not open . Thank you very much ,any sugestion is very helpfull for me .

Re: visual basic.net standard 2003 (ado.net)

Postby William (Bill)Vaughn » Wed, 25 Aug 2004 07:50:24 GMT

I suggest that you look more closely at your database design. I virtually 
all cases when we've seen designs with this many columns it's because the 
database is not normalized. Since an average (albeit wide) normalized 
relational table might have 20 or 30 columns, 100 is excessive.

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"ADO data adapter limit" <ADO data adapter  XXXX@XXXXX.COM > 





Re: visual basic.net standard 2003 (ado.net)

Postby YWRvLm5ldA » Wed, 25 Aug 2004 22:17:03 GMT

Normalizing my database did not answer my question. As to why did Microsoft 
limit to 100 fields on the data adapter wizard, but give the ability for more 
than 100 fields in a single database table. It would take massive coding 
changes to restructure my database. It was working fine in VB6 with DAO. I 
still do not understand this limit. Are there any plans by Microsoft to 
increase the limit. Or is this a bug? Could you clarify further. Thanks.






Re: visual basic.net standard 2003 (ado.net)

Postby William (Bill)Vaughn » Thu, 26 Aug 2004 00:14:20 GMT

I can't speak for Microsoft. Several of their folks lurk here so perhaps 
they can answer you.

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________












Similar Threads:

1.Free Copy of Visual Basic .NET 2003 Standard Edition

2.Visual Basic.net 2003 standard

I am trying to reinstall viusal basic.net 2003 standard but whenever i try, 
it says "insert prerequisite disc" and then it cycles through loading a 
webcam program, and then uninstalling, reinstalling, etc. 
Can anyone help me get past the prerequisite disc?

3.Visual Basic .NET 2003 Standard

I am wanting to get a home edition VB.net software to study for my MCAD
exams. Microsoft has a version called "Visual Basic .NET 2003 Standard"
for about $100 (US). Is this appropriate to have as my software to
practice? I have the four volume MS/MCAD books, but I need the software
to give me real-world practice. Is the $100 OK. I can't afford the
Visual Studio $750.
Please advise... Thanks! Brian
 XXXX@XXXXX.COM 

4.Visual Basic .net 2003 Standard Ed. + Compact Framework

Hi all,

I have Visual Basic .net 2003 standard edition, and I'd like to develop an
application for my ppc.

Can I use vb.net 2003 St.ed. to do it?
If yes, how? where I can find some documents decribing my problem's
solution?

Bye
    Alchol100



5.Visual Basic.net 2003 Standard Add-in project

I'm trying to create an Add-in but New Project/Project Types/Other Projects only displays Database Projects.

What I can't do?

Thanks for your time and assistance.
-- 
Michael Cervantes

6. Visual basic.net Standard 2003 update failure

7. Visual Basic .net standard 2003

8. Visual Basic .net 2003 Standard & SQL Server Problems



Return to ADO

 

Who is online

Users browsing this forum: No registered users and 50 guest