- Design a from as follows
- Place two labels, two text boxes and two buttons
using System. Data .oledb;
code in GD
Static oledbConnection con = new oledbConnection (“User id = Scoot; Password = tiger; Provider = ms data.1*”);
Oledb command cmd = new oledbcommand (“Select * from EMP, con”);
Oledb Data Reader . dr;//abstrsct
Code for Button 1_click
{
Con. open ();
Message Box. Show (“Connection is ok”);
If (con. State = = connection State. closed)
{
Con. open ();
Dr = cmd. Execute Reader ();
Message Box. Show (“Con. Server version”);
// column Names
Label 1.Text = dr. Get Name (0);
Label 1.Text = dr. Get Name (1);
}
Else
Message Box. Show (“Connection is already opened”);
Code for Button2 _click
{
If (dr. Read () = = true)
{
textBox1. Text = dr [0] . To String ();
textBox1. Text = dr [1] . To String ();
}
Else
Message Box. Show (“No more Records”);
Data Reader EX 2
Developing a Dynamic From With Sql Server data base over Managed connection
Project
EMP à25 columns
Deptà8
Bonusà4
- Open windows Forms Application Project
- Open a Text box and two buttons as shown
Using System. Data. Sqlclient;
Code for GD
Sqlconnection con = new Sqlconnection (“User id = Sa; Password =; database = northwind; Server = local host”);
Sql command cmd = new sql command ();
Sql Data Reader dr;
Label[] L;
Text Box [] T;
Int x = 50;
Int [] n = new int []
Code for Button 1_click
con. open ();
String q = “Select * from ” + text Box1 .Text;
One space must be given
cmd. Command Text = q;
cmd. connection = con;
dr = cmd. Execute Reader ();
Message Box .Show (dr. Field count + “”);
L = new Label [dr. Field Count];
T = new Text Box [dr. Field Count];
//add the controls in to form
For (int I =0; I < dr. Field Count ; I ++)
{
L [i] = new Label ();
L[i] .Text = dr. Get Name (i);
L[i] . Location = new Point (100, x);
This .Controls. Add (L [i]);
T [i] = new Text Box ();
T [i] . Location = new Point (200,x);
This. Controls . Add ( T [i]);
X= x + 30;
}//for
Code for Button 2_clikc DR [0] DR [1]
{ ENO EN SAL
If (dr. Read () = = true) 101 Ravi 5000
{ T [0] Text = DR [0]. To String ();
For (int I = 0; I <dr. Field Count ; I++)
T [i] .Text = dr [i]. To. String ();
}
Else
Message Box. Show (“No more Records”);
OBS :-
When connection is closed , then all associated data readers will be closed automatically.
Data Reader works only when connection model is active (open)
Data Reader are connection oriented.
If no. of clients are more in the network . then Data base efficiency will decreases.