Answer Posted / eric
You mean: "How do I get records from a database?"
You have to get the "dotnet driver" of the database (or any
other datasource) you want to access to.
For example:
MySQL: Connector/Net
Access: Microsoft Access Driver
Oracle: Oracle Data Access Components (ODAC)
Afterwards you build a connection string to tell your
programm which driver you want to use and where the
datasource can be found, for example:
public const string DB_CONN_STRING =
"Driver={Microsoft Access Driver (*.mdb)}; "+
"DBQ=D:\\CS\\TestDbReadWrite\\SimpleTest.mdb";
Afterwards you just have to open a connection to the
database using the previously created connection string and
send a query to the database to get the record:
ADOConnection conn = new ADOConnection(DB_CONN_STRING);
conn.Open();
ADODataReader dr;
ADOCommand cmd = new ADOCommand( "SELECT * FROM <table>",
conn );
cmd.Execute(out dr);
while (dr.Read()){
....}
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the synonym of form?
how see report periviwe
Which window displays messages for the status of various features provided in the visual studio .net ide?
Which method grants a lock on a resource?
Which property is used to specify the use of an element in the user interface and reports it to the accessibility aids?
What is the extension of the windows installer file?
Explain the need of z-order method?
What is the difference between desktop application and windows application?
What is difference between winforms and windows forms?
Which method of the messagebox class is used to display a message in the message box?
Explain how many number of events does the timer controls?
Name the method that has to be overridden to change the appearance of the control that is inherited from an existing control.
Name the two main categories of .net components.
Is form action required?
Name the template that is used to create a user-defined component.