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);

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()){
....}

What is form record?

0 Answers  

---

What is the synonym of form?

0 Answers  

---

Which template creates a .net compact framework 2.0 forms application for pocket pc 2003 and later?

0 Answers  

---

which property of menu cannot be set at run time?

3 Answers  

---

What is a database form?

0 Answers  

---

Hi, I am implementing one windows form. I am inserting some values into ms access. In that table 5 columns there. But I want to insert three columns only. when I am clicking another button then other two values also insert into that table. please help me

3 Answers   Satyam,

---

how can u split a column header in gridview using C#.net

2 Answers   IBM,

---

Explain how to find the current record position in data control?

0 Answers  

---

What are windows based applications examples?

0 Answers  

---

What is formdata?

0 Answers  

---

Are windows forms still used?

0 Answers  

---

What are the components of gui for windows?

0 Answers  

---