I want to ask that what happens when I make a database request (using Linq-To-Sql). Active thread is blocked and waits for response, or it is used to process other requests?
Do frameworks like Linq-To-Sql or Linq-To-Entities handle this?
If I use Sleep() method on thread, is that thread blocked or is it used to process other requests?
suppose i have one button and i want that when user click this button and then a method will be called asynchronously.how to do it in asp.net 2.0. please help me with sample code.
View 1 RepliesI need to asychronously call a web service from an ASP.NET application. The aspx does not need the answer from the web service. It's just a simple notification.
I'm using the ...Async() method from web service stub and <%@Page Async="True" %>.
ws.HelloWorldAsync();
My problem: the web page request is waiting for the web service response.
How to solve this problem? How to avoid any resource leak when the web service is down or when there is an overload?
I have MVC application (applies to non MVC as well) where a user is posting in data. I need to take this data, send it off to two seperate end points (one using a WebRequest form POST and one using a Web Service), parse the result, and send the result back to the original user.
The issue at hand is that both end points take about 20-30 seconds to respond (response is a string) which means that I should probably execute these two calls asynchronously. At the same time I want to wait to respond to the original user until I get both results back. I am guessing I might have to use some sort of object lock so the response does not get sent back before the two calls are complete?
Based on the responses I decided to go with async controllers since I am already working with a MVC application.
I am using a third party service for location time(zonal).If I pass latitude and longitude of the location with service URL it returns the time of that location in XML format.But the problem is some of the time this service gets too much slow so because of that my home page gets stuck because its a synchronous call of that service.here my code-
string TimeZoneUrl = "http://ws.geonames.org/timezone?";
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(TimeZoneUrl + "lat=" + latitude + "&lng=" + longitude);
XmlElement root = xmlDoc.DocumentElement;
XmlNodeList nodes = root.SelectNodes("//*");
How can I make this a asynchronous call?
According to the msdn documentation, as you can see on the diagram, a server control's "Data binding events" occurs after all "control changed events". So in the case of a DetailsView control, the ItemInserted event would happen before the database operation?
View 1 RepliesToday my client has asked me to do Data Base Log,that is if any change done like,Insert or Edit or delete that has to be viewable in Log Report,if somebody did even a Small change that also has to be keep track and has to display in Log Report,like the recent activity is so and so and so and so person has done this.
View 1 RepliesI only need one textbox inside gridview and other operational buttons like add , edit , delete in gridview. I just need that these buttons can save the data in datatable like we do :
DataTable dt = new Datatable();
I don't want to save it in database at this stage. CRUD Operations using datatable inside gridview is my aim.
I have several web sequential pages which will modify a record and its child records in the database, called a "project". Such a project is currently passed between pages using its database ID in the URL parameters.
A project has some information specific to itself, and also consists of one or more Tasks, which each have information specific to itself.
Is it faster (alternatively, more maintainable or more easily understood) to hit the database each time I need to query the same project (and its tasks), or should I query the database once (either once for each page or once for all pages and save to Session) and check the saved object rather than the database?
I have a page which is accessible only from Monday to Friday. If i try to open it on Saturday or Sunday it shouldn't.I have a column in my DB naming WorkingDays and iam storing Bitwise value
Monday=1,Tuesday=2,Wednesday=4,Thursday=8....
So the value in my DB is 31 which is equal to Monday to Friday.If i open the page on saturday how should i check?
How should i convert todays day to bitwise value and how should i compare with the DB value.
Does anyone have a tricky tip to simplify my complex String Operations? I receive a string sequenze from database which i have to manipulate on RowDataBound of an GridView, put the String into several controls. The String looks like this:Here goes a introduction string with easy formating options such as {blue}blue text{/blue}
{CONTROL}{ParamsForControl|ParamsForControl}Text for Control 1{/CONTROL}
{CONTROL}{ParamsForControl|ParamsForControl}Text for Control 2{/CONTROL}
{CONTROL}{ParamsForControl|ParamsForControl}Text for Control 3{/CONTROL}
Some Text at the end.My first try was easy because I haven't had an introducing and a ending text, so I split the String at "{CONTROL}" extract the Parameters and replaced "{/CONTROL}" with nothing, works fine...But if i now split at "{CONTROL}" how to handle the text in front of and behind them... I do a lot of string.IndexOf and String.LastIndexOf operations but I hope there is an easier way...Result should be:
Introduction Text = Label
Control = UserControl
Control = UserControl
when i log out, i have this problemwhen i enter the authorized section, its still keep showing me the page, only when i refresh it,it brings me back to login page.for example,i logged in as manager,and then i logged out.when i enter the same authorized managment page it keeps showing me content, but when i refresh it brings me back to the default login page.
View 8 RepliesI'm developing an asp.net web applcition that works with sql server. i'm using Entity model as DAL.I user repository pattern for my business layer, now, i'm going to design UI.this is my business layer code:
[Code]....
I have some questions: becase all of entites need to have CRUD operations, so i want to have a master page with Insert, Edit, Deleter Button and a place holder for entity form, so for each entity i create a form with this master and create textboxes and label in asp:content tag.for this to be done i konw master must have a Interface to do operations. so i wanted to define ISchoolSystemRepository<??> as a property in master page, but i must pass it T which will determined in runtime. so
1.how i do this?
2. is this approach right design
I want to know how can we call a database function from code side. I am developing an application in Asp.net(C#).
View 1 RepliesI have a simple upload page that will upload a file to a server and when the "upload" button is clicked, the file is uploaded to the server and then a bulk insert command is made from the .vb file. I have the database connection in the web.config file but I don't know where to add the ado connection and command structure in the .vb file. I also don't know where to put the bulk insert. I'm assuming that it goes in the .vb file as well. Here is my .vb file as it stands currently
[Code]....
I have a web program that creates a url for a file, where it usually calls
item.Url=downfile+"?fileid="+reader["id"];
which save the item url. Which is called up again when trying to access the file (tho only for half a second)
websiteURL/DownFile.Aspx?fileid=8 what I want to do is to make this not so easily changeable. Now I still need the ID from the database to call that specific file. is there anyway I could do this? or is the best option making my ID field a hash and basically unreadable thus making it hard for anyone to guess the fileid. I have tried reading some Encrypt QueryString documents but they don't seem to be what I am looking for, as the url is saved to the item before any QueryString is called.
I'am refactoring a website administration control panel code, wich is made afcourse in ASp .NET WebForms with C#.
Now I have implemented View, Edit, Delete, New operations on every managerPage.
For example if I have userManager page first I see List with option Show (view).
On details page a have Edit, Delete options on the bottom of page.
Now I want to implement some kind of generic OPERATIONS BAR like this: But I need a way to implement that efficiently. I want to implement it like encapsulated userControl.
I thinking something like IBaseView interface wich is implemented with
specifically page (view).
How to do CRUD in LINQ?
how to perform updation using linq where i have multiple conditions for for single row and updating multiple fields to that row?
i am displaying a gridview from db(SQL2005), which display leave table where employee apply leave and submit to admin. Viewing the leave table in gridview the admin sanction or rejected their leave request, by clicking the check box displays on each gridview rows and click on sanction or rejected button.
here i am sending SMS to the employee number displaying in the gridview (taking the employee phone number and send SMS).. this i have done using bulk SMS services, i have taken the number using the following
if check conditions...
but now what the problem is i have to delete the gridview rows.. i am using the same employee phonenumber to delete the corresponding gridview, but if suppose the single employee applied for two or more leave, the gridview display all leave for the single employee, the admin have sanction only one leave for that employee.. so if he checks the check box and click on OK button.. it have to delete the corresponding row as well as send SMS to the phonenumber of the employee.. Other leaves of the same employee display in the gridview.. i used the following coding
Protected Sub bttnsanction_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bttnsanction.Click
Dim row As GridViewRow
Dim selection As New ArrayList()
For i As Integer = 0 To GridView1.Rows.Count - 1.........
I am using the Sno as primary key in leave table.. where i want to delete the corresponding row which sends SMS to employee number also the delete the row of corresponding Sno.. i have to get the corresponding gridview row sno in the delete store procedure..
I'm working on a web application using VB.NET. In page load event am calling a remote web service which take time to bring the data. During this process none of the other contents on page are shown(render).
I want to call this remote web service asynchronously so that other data of page is displayed and web service data will be displayed when its available.
I need to asynchronously retrieve several resultsets which I store in DataTables and add these DataTables to a DataSet. When the final DataTable is filled and added to the DataSet the page must then continue processing utilizing this DataSet I have figured out how to implement delegates to asynchronously retrieve my DataTables but I'm unclear how to add them to a DataSet in a thread-safe manner. How is this best accomplished? Before processing I know how many DataTables there will be, so what is the best way to track the progress of the asynchronous retrievals and allow the page to continue only after I have all of the data?
View 3 RepliesI need to asynchronously retrieve several resultsets which I store in DataTables and add these DataTables to a DataSet. When the final DataTable is filled and added to the DataSet the page must then continue processing utilizing this DataSet I have figured out how to implement delegates to asynchronously retrieve my DataTables but I'm unclear how to add them to a DataSet in a thread-safe manner. How is this best accomplished? Before processing I know how many DataTables there will be, so what is the best way to track the progress of the asynchronous retrievals and allow the page to continue only after I have all of the data?
View 6 RepliesI have 2 page
1-index.aspx
2-House.aspx
And these are my table in database
1-House_menu Table
Id Name H_name
1 Sofa Furniture
2 Table Furniture
3 Iron Electric
4 Vacuum cleaner Electric
2-House_p Table that save users product information
Id Name H_name Subset Description
1 Couch Furniture House furniture Test1
2 Armchair Furniture House furniture Test2
3 Blender Electric Kitchen Test3
4 Oven Electric Kitchen Test4
I have 1 unorderlist menu in index.aspx
and 1 unorderlist in House.aspx page
I bind unorderlist from database
1-index.aspx
Bind repeater from House_menu Table
<li class="current">
<a href="House.aspx?H_name=all">Furniture</a> <ul>
<asp:Repeater ID="rptMenu" runat="server">
<ItemTemplate>
<li><a href="Houseaspx?H_name=<%#Eval("H_name") %>"><%#Eval("name") %></a> </li>
</ItemTemplate> </asp:Repeater> </ul> </li>
And in House.aspx page i bind repeater from HOuse_p table subset column
<ul> <asp:Repeater ID="rptMenuE" runat="server">
<ItemTemplate>
<li><a href="House.aspx?subset=<%#Eval("subset") %>">
<%#Eval("Subset") %></a> </li>
</ItemTemplate>
</asp:Repeater> </ul>
When users click on menu item in index.aspx menu it go to house.aspx and bind datalist according to H_name column from House_p table
This is code
private void GetCustomersPageWise(int pageIndex) {
{
if (Request.QueryString["H_name"] != "all") {
using (SqlCommand cmd = new SqlCommand("GetCustomersPageWise1", _cn)) {
string BehCode = Request.QueryString["H_name"];
[Code] ....
Now I want when users click on menu item in House.aspx page it bind datalist from House_p table according to Subset column .. How I can do it ?
I have placed Chekc box in Gridview when i select the check box can perform 2 operations simultaniously one is entire recordset is populated into form fileds and second one is can delete the selected record permanently from database table.following code for this fuctionality.
GridviewCode
<asp:GridView ID="GVData" runat="server" Height="75px" Width="76px" CaptionAlign="Top"
Font-Size="Medium" EnableModelValidation="True" [code]....
I am trying to update client side controls asynchronously with information from a service.
The service I am using has a callback delegate that points to the users web page (server side)
I would like to update information on the page that is initiated by another users also consuming the same service. exactly like a chatroom.
I am trying to use an update panel, and call updatepanel.update() (server side) once I recieve the information from the service. basically: how do I partially update control data from the server side so that client side can see it.