Batch Sql statements are use full for retrieving data from database. ADO .Net supports batch sql statements. It requires less memory and faster because we don't need to take more Command object or DataAdapter object to read data.
NB: Please design your own tables and stored procedures.
Design View :-
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:gridview ID="Gridview1" runat="server"></asp:gridview>
<asp:gridview ID="Gridview2" runat="server"></asp:gridview>
<asp:Button ID="BtnReader" runat="server" Text="Data Reader"
onclick="BtnReader_Click" />
<asp:Button ID="BtnAdapter"
runat="server" Text="Data Adapter" onclick="BtnAdapter_Click" />
<asp:Button ID="BtnStored" runat="server" Text="Stored Procedure"
onclick="BtnStored_Click" />
</div>
</form>
</body>
</html>
C# Code :-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class Default3 : System.Web.UI.Page
{
SqlConnection con;
SqlDataAdapter da;
SqlCommand cmd;
DataSet ds;
SqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["Satya"].ConnectionString);
con.Open();
if (!IsPostBack)
{
}
}
public void satya_DA()
{
da = new SqlDataAdapter("Select * from Rakesh;Select * from Demo", con);
ds = new DataSet();
da.Fill(ds);
Gridview1.DataSource = ds.Tables[0].DefaultView;
Gridview1.DataBind();
Gridview2.DataSource = ds.Tables[1].DefaultView;
Gridview2.DataBind();
}
public void satya_Reader()
{
using (cmd = new SqlCommand("Select * from Rakesh;Select * from Demo", con))
{
using (dr = cmd.ExecuteReader())
{
Gridview1.DataSource = dr;
Gridview1.DataBind();
dr.NextResult();
Gridview2.DataSource = dr;
Gridview2.DataBind();
}
}
}
public void satya_SP()
{
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "exec Select_Employee_Sallary_Qualification exec Select_Employee_Sallary_Qualification1";
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds);
Gridview1.DataSource = ds.Tables[0].DefaultView;
Gridview1.DataBind();
Gridview2.DataSource = ds.Tables[1].DefaultView;
Gridview2.DataBind();
da.Dispose();
con.Close();
}
protected void BtnReader_Click(object sender, EventArgs e)
{
satya_Reader();
}
protected void BtnAdapter_Click(object sender, EventArgs e)
{
satya_DA();
}
protected void BtnStored_Click(object sender, EventArgs e)
{
satya_SP();
}
}
No comments:
Post a Comment