How to call the SQL commands asynchronously in ADO.NET version 2.0

How to call the SQL commands asynchronously in ADO.NET
version 2.0

Question Posted / guest

4 Answers
14285 Views
DELL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to call the SQL commands asynchronously in ADO.NET version 2.0..

Answer / jagan

here
executescalar()
executereader()
executenonquery()
these comes with Begin and End
like Beginexecutescalr()
Endexecutescalar()
.......
by using these command we can achieve asynch comm in
ado.net

Is This Answer Correct ?

11 Yes

7 No

How to call the SQL commands asynchronously in ADO.NET version 2.0..

Answer / kiran

This is the sample code which tells asynchronous access

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>

<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection DBCon;
SqlCommand Command = new SqlCommand();
SqlDataReader OrdersReader;
IAsyncResult ASyncResult;

DBCon = new SqlConnection();
DBCon.ConnectionString =
ConfigurationManager.ConnectionStrings
["DSN_NorthWind"].ConnectionString;

Command.CommandText =
"SELECT TOP 5 Customers.CompanyName,
Customers.ContactName, " +
"Orders.OrderID, Orders.OrderDate, " +
"Orders.RequiredDate, Orders.ShippedDate " +
"FROM Orders, Customers " +
"WHERE Orders.CustomerID =
Customers.CustomerID " +
"ORDER BY Customers.CompanyName,
Customers.ContactName";

Command.CommandType = CommandType.Text;
Command.Connection = DBCon;

DBCon.Open();

// Starting the asynchronous processing
ASyncResult = Command.BeginExecuteReader();

// This loop with keep the main thread waiting
until the
// asynchronous process is finished
while (!ASyncResult.IsCompleted)
{
// Sleeping current thread for 10 milliseconds
System.Threading.Thread.Sleep(10);
}

// Retrieving result from the asynchronous process
OrdersReader = Command.EndExecuteReader
(ASyncResult);

// Displaying result on the screen
gvOrders.DataSource = OrdersReader;
gvOrders.DataBind();

// Closing connection
DBCon.Close();
}
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>The Poll Approach</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvOrders" runat="server"
AutoGenerateColumns="False" Width="100%">
<Columns>
<asp:BoundField HeaderText="Company Name"
DataField="CompanyName"></asp:BoundField>
<asp:BoundField HeaderText="Contact Name"
DataField="ContactName"></asp:BoundField>
<asp:BoundField HeaderText="Order Date"
DataField="orderdate"
DataFormatString="{0:d}"></asp:BoundField>
<asp:BoundField HeaderText="Required Date"
DataField="requireddate"
DataFormatString="{0:d}"></asp:BoundField>
<asp:BoundField HeaderText="Shipped Date"
DataField="shippeddate"
DataFormatString="{0:d}"></asp:BoundField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>

Is This Answer Correct ?

3 Yes

1 No

How to call the SQL commands asynchronously in ADO.NET version 2.0..

Answer / sandyni

In the asynchronous method ,the client creates a SqlCommand
object.the client application also sets the async attribute
in the connection string to true. Next, the client invokes
any of the asynchronous methods such as
beginExecuteNonQuery, BeginExecuteReader, or
BeginExecuteXmlReader through the SqlCommand object.

After executing the sql command the asynchronous methods
will close by using
EndExecuteNonquery,EndExecuteScalar,EndExecuteReader.

Is This Answer Correct ?

2 Yes

1 No

How to call the SQL commands asynchronously in ADO.NET version 2.0..

Answer / radheshaym

executescalar()
executereader()
executenonquery()

these comes with Begin and End like Beginexecutescalr()
Endexecutescalar().......

by using these command we can achieve asynch comm in ado.net

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More ADO.NET Interview Questions

How to check if the Dataset has records ?

0 Answers NA,

What is ole2 format?

0 Answers

What are the Features of a dataset

0 Answers BirlaSoft,

What does connection string consists of ?

4 Answers Digital GlobalSoft,

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers Honeywell,

how to add a selected row of a gridview to another gridview without reloading the page??

2 Answers

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers

Which provider is used to connect ms access, oracle, etc…?

0 Answers

Define connection string?

0 Answers

what is data access layer?

2 Answers Honeywell,

What is the difference between OLEDB Provider and SqlClient?

0 Answers

How to check if a datareader is closed or opened? IsClosed()

0 Answers

For more ADO.NET Interview Questions Click Here