how find recored from the database
Answers were Sorted based on User's Feedback
Answer / venky
Dear friend my answer is relating to csharp.net....SQLSERVER Database.
TO get records from database
1) our Application have to Connect with database.
SQlconnection cn=new sqlconnectio(@"server=.\SQLEXPRESS;Database=mydatabase;Integrated Security=SSPI");
cn.open();
2) we have to prepare COMMAND object Which encapsulate a sql statement and connection obj.
SQLCommand cmd=new Sqlcommand("select * from table1",cn);
then we call following method to get records
SqlDataReader rdr= cmd.ExecuteReader(CommandBehavior.CloseConnection);
int f_cnt= rdr.FieldCount;
Type t= rdr.GetFieldType(1);
while(rdr.Read())
{
int cou = rdr.FieldCount;
for(int i1=0;i1<cou;i1++)
{
string s2 = rdr.GetValue(i1).ToString();
ans = ans + " " + s2+" ";
}
i++;
ans = ans + "\n";
}
MessageBox.Show(ans);
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is difference between winforms and windows forms?
how barcode create in the report
How to redirect a user to new page in ASP.NET without making a round-trip to the browser?
What are the forms of database?
Where is system windows forms dll?
Is it possible to set a shortcut key for label?
How to create a set up in vb.net for desktop application please say steps with examples?
What is the use of play() playlooping() functions?
How many navigational features are provided by visual studio.net ide?
What are window based applications?
how to create a set up in vb.net for desktop application please say me steps with examples
which property of menu cannot be set at run time?