What is Data Grid control in Ado.Net
Data Grid Control:-
The window forms datagrid control provide a user interface to ADO.net data set,displaying tabular data and allowing for updates to the data source. when the data grid control is set populated, creating columns and rows based on the shape of the data.the data grid control can be used to display either a single table or the hierarchical relationships between a set of table.Example:-1 In this example ,Iam using "student" database. which has a table "student_detail". take a windaow form application .adata grid view control and write following code.
<% @page language = c# %>
<% @Import name space ="system.data.sqlclient" %>
<% @ Import name space ="system.data" %>
<form id ="f1" runat="server"/>
<asp:datagrid id="gd" runat="server"/>
</form>
<script language ="c#" runat="server">
void page_load(object sender, event args e);
{
sql connection con = new sqlconnection("server=localhost"; database =student; user=aa; password="wintellect");
con.open();
sql dataadapter da= new sqldataadapter("select * from student_details",con);
dataset ds =new dataset();
da.fill(ds,"student_detail");
datagridview1.data source = ds.table["student_detail"];
}</script>
EXAMPLE:-2 data table, dataview, data grid and sort data(ascending and descending order)
<% @page language = c# %>
<% @Import name space ="system.data.sqlclient" %>
<% @ Import name space ="system.data" %>
<form id ="f1" runat="server"/>
<asp:datagrid id="gd" runat="server"/>
</form>
<script language ="c#" runat="server">
void page_load(object sender, event args e);
{
sql connection con = new sqlconnection("server=localhost"; database =student; user=aa; password="wintellect");
con.open();
sql dataadapter da= new sqldataadapter("select * from student",con);
datable dt=new datatable();
da.file(dt);
data view dv=new dataview();
dv.table=dt;
dv.filter rows="marks>10;
dv.sort="roll no.";
dg.data source=dv;
dg.data bind();
}
</script>
EXAMPLE:-3 using sql select query in ado.net.
EXAMPLE:-3 using sql select query in ado.net.
<% @page language = c# %>
<% @Import name space ="system.data.sqlclient" %>
<% @ Import name space ="system.data" %>
<form id ="f1" runat="server"/>
<asp:datagrid id="gd" runat="server"/>
</form>
<script language ="c#" runat="server">
void page_load(object sender, event args e);
{
sql connection con = new sqlconnection("server=localhost"; database =student; user=aa; password="wintellect");
sqlcommand cmd = new sqlcommand("select * from customer"'con);
}
</script>
EXAMPLE :-4 using sql update query in ado.net.
<% @page language = c# %>
<% @Import name space ="system.data.sqlclient" %>
<% @ Import name space ="system.data" %>
<form id ="f1" runat="server"/>
<asp:label id="l1" runat="server" text ="rollno.">
<asp:label id="l1" runat="server" text ="rollno.">
<asp:textbox id="t1" runat="server" >
</br>
<asp:label id="l2" runat="server" text ="name">
<asp:textbox id="t2" runat="server" >
</br>
<asp:label id="l3" runat="server" text ="marks.">
<asp:textbox id="t3" runat="server" >
</br>
<asp:button id="b1" runat="server" text ="update.">
</br>
<asp:label id="l4" runat="server">
<
</form>
<script language ="c#" runat="server">
sql connection con;
sql command cmd
void page_load(object sender, event args e);
{
sql connection con = new sqlconnection("server=localhost"; database =northwind; user=aa; password="wintellect");
con.open();
int r =convert to int32(t1.text);
string n = t2.text;
int m =convert to int32(t3.text);
sqlcommand cmd = new sqlcommand(update student set name="xyz" , marks="5" where rollno.="102",con);
cmd.execute non query();
l4.text="record successfully update";
con.close();
}
</script>
.Net Framework Notes
<% @Import name space ="system.data.sqlclient" %>
<% @ Import name space ="system.data" %>
<form id ="f1" runat="server"/>
<asp:datagrid id="gd" runat="server"/>
</form>
<script language ="c#" runat="server">
void page_load(object sender, event args e);
{
sql connection con = new sqlconnection("server=localhost"; database =student; user=aa; password="wintellect");
sqlcommand cmd = new sqlcommand("select * from customer"'con);
}
</script>
EXAMPLE :-4 using sql update query in ado.net.
<% @page language = c# %>
<% @Import name space ="system.data.sqlclient" %>
<% @ Import name space ="system.data" %>
<form id ="f1" runat="server"/>
<asp:label id="l1" runat="server" text ="rollno.">
<asp:label id="l1" runat="server" text ="rollno.">
<asp:textbox id="t1" runat="server" >
</br>
<asp:label id="l2" runat="server" text ="name">
<asp:textbox id="t2" runat="server" >
</br>
<asp:label id="l3" runat="server" text ="marks.">
<asp:textbox id="t3" runat="server" >
</br>
<asp:button id="b1" runat="server" text ="update.">
</br>
<asp:label id="l4" runat="server">
<
</form>
<script language ="c#" runat="server">
sql connection con;
sql command cmd
void page_load(object sender, event args e);
{
sql connection con = new sqlconnection("server=localhost"; database =northwind; user=aa; password="wintellect");
con.open();
int r =convert to int32(t1.text);
string n = t2.text;
int m =convert to int32(t3.text);
sqlcommand cmd = new sqlcommand(update student set name="xyz" , marks="5" where rollno.="102",con);
cmd.execute non query();
l4.text="record successfully update";
con.close();
}
</script>
.Net Framework Notes
EmoticonEmoticon