Click here to Skip to main content
15,940,550 members
Home / Discussions / Database
   

Database

 
AnswerRe: Field ordering in a table Pin
Mycroft Holmes26-Oct-10 3:04
professionalMycroft Holmes26-Oct-10 3:04 
GeneralRe: Field ordering in a table Pin
Gerben Jongerius26-Oct-10 3:41
Gerben Jongerius26-Oct-10 3:41 
QuestionSQL Server Trigger [modified] Pin
Jay Royall25-Oct-10 5:03
Jay Royall25-Oct-10 5:03 
AnswerRe: SQL Server Trigger Pin
Chris Meech25-Oct-10 6:13
Chris Meech25-Oct-10 6:13 
GeneralRe: SQL Server Trigger Pin
Jay Royall25-Oct-10 22:20
Jay Royall25-Oct-10 22:20 
GeneralRe: SQL Server Trigger Pin
Chris Meech26-Oct-10 2:38
Chris Meech26-Oct-10 2:38 
QuestionSimple question from new sql server user ... [modified] Pin
Yanshof25-Oct-10 2:25
Yanshof25-Oct-10 2:25 
AnswerRe: Simple question from new sql server user ... Pin
PIEBALDconsult25-Oct-10 3:34
mvePIEBALDconsult25-Oct-10 3:34 
Yanshof wrote:
dataGridView


Yuck.


If all you're doing is seeing that it can be done, then use a DataAdapter's Fill and Update methods to move data between the Grid and the database. But it only works for very simple data and you will soon find that that technique is not appropriate for real applications.

For one thing, Grids are generally not a proper way to get user input -- can you imagine an eCommerce site where you placed orders by filling in columns in a grid? No, you should define a form for entering and editing data. You can use a Grid with a subset of the data to allow the user to locate the record he wishes to edit, but never edit within a Grid.

For actual applications you will need a Data Access Layer. A layered application makes swapping parts in and out easier. For instance, at some future time you may want the client to access the database via a Web Service -- if your client is too-tightly bound to your database, that will be much more difficult.

"A stitch in time saves nine." Learn to use proper data access techniques now, before you really need them.


Here[^]'s an article I wrote on one of my data access techniques.
GeneralRe: Simple question from new sql server user ... Pin
NeverHeardOfMe25-Oct-10 4:18
NeverHeardOfMe25-Oct-10 4:18 
GeneralRe: Simple question from new sql server user ... Pin
PIEBALDconsult25-Oct-10 9:22
mvePIEBALDconsult25-Oct-10 9:22 
GeneralRe: Simple question from new sql server user ... Pin
Mycroft Holmes26-Oct-10 1:42
professionalMycroft Holmes26-Oct-10 1:42 
GeneralRe: Simple question from new sql server user ... Pin
NeverHeardOfMe26-Oct-10 2:00
NeverHeardOfMe26-Oct-10 2:00 
GeneralRe: Simple question from new sql server user ... Pin
Mycroft Holmes26-Oct-10 2:57
professionalMycroft Holmes26-Oct-10 2:57 
GeneralRe: Simple question from new sql server user ... Pin
PIEBALDconsult26-Oct-10 15:12
mvePIEBALDconsult26-Oct-10 15:12 
QuestionSQL Server 2008 R2: Errrors when sending ISO 8601 timestamp values as parameters to a parametrized insert statement Pin
Per Nilsson24-Oct-10 23:24
Per Nilsson24-Oct-10 23:24 
AnswerRe: SQL Server 2008 R2: Errrors when sending ISO 8601 timestamp values as parameters to a parametrized insert statement Pin
Bernhard Hiller24-Oct-10 23:32
Bernhard Hiller24-Oct-10 23:32 
QuestionDatabase Unit Testing with Visual Studio 2010 Pin
dotman124-Oct-10 16:38
dotman124-Oct-10 16:38 
QuestionModifiable field in sql server 2005 Pin
Zeyad Jalil24-Oct-10 1:55
professionalZeyad Jalil24-Oct-10 1:55 
AnswerRe: Modifiable field in sql server 2005 Pin
Mycroft Holmes24-Oct-10 11:57
professionalMycroft Holmes24-Oct-10 11:57 
GeneralRe: Modifiable field in sql server 2005 Pin
Zeyad Jalil24-Oct-10 21:24
professionalZeyad Jalil24-Oct-10 21:24 
GeneralRe: Modifiable field in sql server 2005 Pin
Mycroft Holmes24-Oct-10 22:00
professionalMycroft Holmes24-Oct-10 22:00 
GeneralRe: Modifiable field in sql server 2005 Pin
Zeyad Jalil24-Oct-10 23:52
professionalZeyad Jalil24-Oct-10 23:52 
GeneralRe: Modifiable field in sql server 2005 Pin
Mycroft Holmes25-Oct-10 0:49
professionalMycroft Holmes25-Oct-10 0:49 
QuestionDetach the Database Pin
future383923-Oct-10 15:35
future383923-Oct-10 15:35 
AnswerRe: Detach the Database Pin
future383923-Oct-10 16:08
future383923-Oct-10 16:08 

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.