Click here to Skip to main content
16,006,709 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Filling a database from an existing vb.net form Pin
Christian Graus15-Sep-05 14:25
protectorChristian Graus15-Sep-05 14:25 
AnswerRe: Filling a database from an existing vb.net form Pin
Briga15-Sep-05 22:55
Briga15-Sep-05 22:55 
Questionvb.net Pin
Anonymous15-Sep-05 8:32
Anonymous15-Sep-05 8:32 
AnswerRe: vb.net Pin
Steve Pullan15-Sep-05 14:19
Steve Pullan15-Sep-05 14:19 
QuestionPlease Help Pin
Member 1208285415-Sep-05 8:09
Member 1208285415-Sep-05 8:09 
AnswerRe: Please Help Pin
Christian Graus15-Sep-05 11:50
protectorChristian Graus15-Sep-05 11:50 
QuestionDataTable/DataAdapter Public - Pros and Cons Pin
dptalt15-Sep-05 3:06
dptalt15-Sep-05 3:06 
AnswerRe: DataTable/DataAdapter Public - Pros and Cons Pin
Christian Graus15-Sep-05 11:55
protectorChristian Graus15-Sep-05 11:55 
dptalt wrote:
Use the DataAdapter wizard and have separate DataTables and DataAdapters for each form in the project.

This way is crap. I take it this means you're not even implimenting a middle tier ?

dptalt wrote:
Define public DataTables and DataAdapters in a module so that these objects are available to all forms.

Yes, what should happen is that you have a seperate module that handles data access, and returns the required data to the middle tier. That way, your data layer is seperate from the rest of the app.

That Microsoft provides DataAdapters at all is a travesty, IMO. Assuming you're using a real database, you should write your database code as stored procedures, and your data layer should call those procs and return the result. Putting SQL generation in the hand of a wizard, and passing SQL statements like select and update to the data layer from the application layer is just crap, unless the apps your writing are just for fun, or at least will run on one machine with a local database. It's still not the right way to architect things tho.



Christian Graus - Microsoft MVP - C++
GeneralRe: DataTable/DataAdapter Public - Pros and Cons Pin
dptalt16-Sep-05 2:05
dptalt16-Sep-05 2:05 
QuestionUpdate Problem Pin
mcgann15-Sep-05 2:51
mcgann15-Sep-05 2:51 
AnswerRe: Update Problem Pin
Christian Graus15-Sep-05 11:56
protectorChristian Graus15-Sep-05 11:56 
QuestionBarCode Pin
albCode14-Sep-05 21:40
albCode14-Sep-05 21:40 
AnswerRe: BarCode Pin
risepop15-Sep-05 0:33
risepop15-Sep-05 0:33 
QuestionConnecting to internet through code Pin
ciacia14-Sep-05 21:30
ciacia14-Sep-05 21:30 
AnswerRe: Connecting to internet through code Pin
LeenaSo14-Sep-05 22:13
LeenaSo14-Sep-05 22:13 
AnswerRe: Connecting to internet through code Pin
enjoycrack15-Sep-05 0:25
enjoycrack15-Sep-05 0:25 
QuestionForm Loading.. Pin
icowa14-Sep-05 21:15
icowa14-Sep-05 21:15 
AnswerRe: Form Loading.. Pin
enjoycrack15-Sep-05 0:38
enjoycrack15-Sep-05 0:38 
AnswerRe: Form Loading.. Pin
Briga15-Sep-05 23:02
Briga15-Sep-05 23:02 
GeneralRe: Form Loading.. Pin
icowa17-Sep-05 2:18
icowa17-Sep-05 2:18 
GeneralRe: Form Loading.. Pin
Briga18-Sep-05 21:57
Briga18-Sep-05 21:57 
GeneralRe: Form Loading.. Pin
icowa19-Sep-05 16:26
icowa19-Sep-05 16:26 
GeneralRe: Form Loading.. Pin
Briga19-Sep-05 21:53
Briga19-Sep-05 21:53 
QuestionSimple Problem Pin
tatchung14-Sep-05 20:59
tatchung14-Sep-05 20:59 
AnswerRe: Simple Problem Pin
ciacia14-Sep-05 21:42
ciacia14-Sep-05 21:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.