What is the best way to call a DLL on a client PC from an ASP page?
I have asp.net page that need to call function in dll installed on client machine because this function access resources related to client. how I can do this?
what i want to do is to execute a url ("To send a text message to client") on client registration but without showing that url page, in short executing url without displaying any page or url to the client.
View 8 RepliesI have an ASP.NET site on Windows Server 2008 (with is domain controller) and IIS7. The site is in a Pool which identidy is "ApplicationPoolIdentity"
I need to allow the user on my site to execute Schtasks.exe whith some arguments. but this doesn't work whithout error message.
I am sure it because user right, I won't to change the ApplicationPoolIdentity to "LocalService" or "NetworkService".
I try to launch Schtasks.exe whith code like this :
[Code]....
what is the best way to allow asp.net application to execute EXE on server with the minium right. ?
Is it possible to execute two or more client side functions with a single button click? (I have written 3 functions in my .aspx page and need to validate on client side)
send me sample code with 3 client side functions using single button click.
i am not sure if my design have flaw but would like to know what others have to say, i am in a situation where i am trying to acheive two things in one click.
using : asp.net web form
i have a web form with few textbox and a gridview control and a button.
if i click on the button i am executing two things
1) asynchronously get data from server to client (working great) and able to display the data in the textboxes.
2) same click i want to bind the gridview.
[Code]....
recap:
1) jquery script execute asynchronously to get data from server to client and display in the textboxes
2) server side code to bind the gridview.
PROBLEM:
if i have onClientClick="return LoadDataById(); then it executes ONLY ajax code and does not execute server side but if have onClientClick="LoadDataById(); then it executes client and server but textbox value wipeout. (the textbox value popuplate through ajax)
Basically I want to get some javascript to be sent back to the client and executed from a postback inside an UpdatePanel. Furthermore this is inside of a reusable WebControl. I've tried
this.Page.ClientScript.RegisterStartupScript and this.Page.ClientScript.RegisterClientScriptBlock but Firebug shows that those scripts aren't sent back in the postback's response.
I also tried straight up writing a <script> tag inside the control's main div in the Render method, which does get sent back but isn't executed. I got a hacky solution working, but ideally looking for a cleaner solution. The hack is to add a 1x1 pixel img with width/height set to 0 and use that for an onload event to execute the script and that works, but it seems like there has to be a cleaner way to do this.
I have a web app that needs to do two things at the same time. After a user clicks a button on the site, a javascript function needs to execute and while thats working I need the server side code for the button click to execute without waiting on the client side to finish.
To be more specific, the client side function takes about 23 seconds to complete, and while that is running the server side code promts the user for printing a document. So I need the javascript to run "in the background".
I am a bit confused about these two sequence of events or processes happening in conjunction to each other. Does the page handler executes first or does the somepage.aspx get execute first or do they happen simultaneously?
View 2 RepliesWhen a button/link is clicked, I want this URL to be called followed by the execution of the following statements. The ASP.Net page is in C# btw.
Function A
statement A
call abc.apsx
statement B
abc.aspx is a silent page, doesn't display anything on the page but creates an output.txt file. So when abc.aspx is called, output.txt file is created and Statement B is executed seamlessly.
I'm trying to understand how to execute AJAX animation on an asp button that has to execute code on Postback. In other words, I have button with code behind that needs to be excuted, but at the same time want to be able to have one of animation extenders be applied to it. I understand that I need to use the BeginRequest Event, I'm just not sure how, or which javascript commands to use to call the ajax animation so the postback will still occur.
View 5 RepliesI am looking through a sql stored procedure which I might need to update in the near future. Basically the stored procedure is about 20 lines long. The stored procedure first builds a query
and stores it in a variable named "@Sql". And then for the last two lines of the stored procedure it appears that the big sql statement stored in "@Sql" is executed by using the "EXEC" command. See below. What is confusing though is that the query appears to be exectuted twice? Why was the query written in this way. Don't both lines do the same thing? Why is it being done twice? Could this possibly be a mistake on the
part of the person who wrote the query. Below are the two lines I am talking about?
EXEC sp_executesql @sql
EXEC (@sql)
I have ASP code in asp page. I want to run the the asp code (preferable) from my asp.net page using vb.net or execute the asp page from my asp.net page using vb.net on page load_event.
View 4 RepliesI am creating a feature which will allow users to import data of excel sheet to database.First, data will be imported from excel sheet and will be displayed in a tabular format.User performs a mapping porcess for database fields and click Submit button.Then a stored procedure inserts all the data of each row into more than 15 tables.
Above mentioned process might cause an issue if users import more than 1000 records (they are definitely going to do that. Thats why this entire functionality is intended for).Basically, what I would like to do is, Insert all the rows to a single table (Temp table), have a cloumn in a table which will be a flag and initially, will be set to "Pending".Create a page which will be executed when there are less users accessing the system (Specific time),
This page will see if there are records in a temp table with FLAG "Pending". If yes then it will fetch one record from the table and will insert data of first row into all the necessary tables. After first transaction it will wait for some time and will fetch the second record....This will last until the final row of temp table is reached.
I want to execute url but not to redirect to that page.My work should be cout. on the same page.. Eg :When i click on "Send" it should send that data to url bt page has to be same no effect should be their . .
View 3 RepliesCan I execute 2 store procedures in one asp page? I copied my code here, it doesn't give me an error but the second store procedure is not executing.
using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlCommand cmd = new SqlCommand("Sp_createOrder", connection);
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
//input parameters for the 1st stored procedure
cmd.Parameters.AddWithValue("@in_order_class", "WEB");
cmd.Parameters.AddWithValue("@in_owner_code", "OP");
cmd.Parameters.AddWithValue("@in_sales_campaign_code", "DEF");
cmd.Parameters.AddWithValue("@in_cus_key", null);
cmd.Parameters.AddWithValue("@in_lab_key", null);
cmd.Parameters.AddWithValue("@in_invoice_number", null);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
int ChargeFine=0;
//this write the return value on the screen
while (rdr.Read())
{
Label5.Text="<strong>Order Key:</strong> ";
Label1.Text = rdr["ord_key"].ToString();
ChargeFine = Convert.ToInt32(rdr["ord_key"].ToString());
Label6.Text="<strong> Order Invoice Number:</strong>";
Label2.Text = rdr["ord_invoice_number"].ToString();
Label7.Text="<strong> Via Ship Via Code:</strong>";
Label3.Text = rdr["via_ship_via_code"].ToString();
Label8.Text=" <strong> Order Ship After Date:</strong>";
Label4.Text = rdr["ord_ship_after_date"].ToString();
}
//executing the second stored procedure
SqlCommand cmd2 = new SqlCommand("Sp_createitem", connection);
cmd2.CommandType = CommandType.StoredProcedure;
//input parameters
cmd2.Parameters.AddWithValue("@in_ord_key", ChargeFine);
cmd2.Parameters.AddWithValue("@in_long_item_number", "AC00107");
cmd2.Parameters.AddWithValue("@in_quantity_requested", 1);
cmd2.Parameters.AddWithValue("@in_price_override", null);
cmd2.Parameters.AddWithValue("@in_shipment_type", null);
cmd2.Parameters.AddWithValue("@in_size", null);
cmd2.Parameters.AddWithValue("@in_color", null);
cmd2.Parameters.AddWithValue("@in_subscription_issues", null);
cmd2.Parameters.AddWithValue("@in_sub_start_date", "");
cmd2.Parameters.AddWithValue("@in_sub_to_renew", "");
cmd2.Parameters.AddWithValue("@in_lab_key", "");
cmd2.Parameters.AddWithValue("@in_ship_via", "");
cmd2.Parameters.AddWithValue("@in_ship_after_date", "");
cmd2.Parameters.AddWithValue("@in_edi_sku_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_style_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_size_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_color_ID", "");
cmd2.Parameters.AddWithValue("@in_check_item_for_duplicates", "");
connection.Close();
how to execute a asp.net page asynchronously?
So I am displaying a page to the user, but when an event happen, I need to execute another page, without using ajax, but using C# code.
I am using asp.net webforms.
I have a page that calculates some stuff and then displays it to the user. Because the calculation part takes a while I would prefer to have the entire page load with empty data and only after that call the calculation and the display data function.
View 7 RepliesI have the following PerformanceFactsheet.aspx.cs page class
public partial class PerformanceFactsheet : FactsheetBase
protected void Page_Load(object sender, EventArgs e)
// do stuff with the data extracted in FactsheetBase
divPerformance.Controls.Add(this.Data);
where FactsheetBase is defined as
public class FactsheetBase : System.Web.UI.Page
[code]...
I am executing Sql Command of insert
But after it inserts data into table it refreshes page and on refreshing, it is calling my javascript window.onunload event
Can we Execute sql command without refreshing page???
I need to run the HttpContext.Current.Server.Execute method in my ASP.NET application. This application has a WCF operation that does some processing. Currently, I am to do my processing correctly from within my WCF operation. However, I would like to do this asynchronously.
In an error to attempt this asynchronously, I tried running Server.Execute in the DoWork event handler of a BackgroundWorker. Unfortunately, this throws an error that says
"object reference not set to an instance of an object" The HttpContext element is not null. I checked that. It is some property nested in the HttpContext object that appears to be null. However, I have not been able to identify why this won't work. It happens as soon as I move the processing to the BackgroundWorker thread.
My question is, how can I asynchronously execute the Server.Execute method?
I have a dynamic catalogue, where customers select products they are interested in. The manager of the company I am doing this for would like to be able to create an up to date offline catalogue at any given time, to send out to customers who dont have an internet connection. So far its going really well. I am using Server.Execute to get the content for each page, then putting it in static html pages and changing the dynamic links to static html links (ie changing all aspx links to htm). I am able to output all the pages for about us, contact us, home, and the entire catalogue. However, one of the stylesheets which is included in the page based on the URL (if the page is in the administration section then it is not included, otherwise it is) is not being included in the pages when it should be. I have tried outputting the URL but it just returns the URL of the calling page, not the page being called.
View 1 RepliesI have created javascript function as mentioned below to hide/show some control. I am calling this script on dropdown on 'onchange' method. In dropdown first item is "-- Select --". I want to execute it on Page Load function, so by default it will be hidden. I tried to call like this on Page load, but it is not working.
ddlEmpType.Attributes.Add("onchange", "HideDD('-- Select --');");
[Code]....
I am tryign to make the master page code globally do some chaecking before the content page loads. Pageload event in Masterpage is executed after the content page for some strange reason. How do I go about this?
View 10 RepliesI am generating Word docs from a gridview. The Word doc gets sent to the client using a Resposne object. However, I would also like to highlight the row in question and update a file generation log display (another gridview).
All the data fucntions on the server side fire fine, but any visual updates to the current page never hit the client. The Response object seems to take over the entire response.
Is there any way to accomplish both: execute the Response and update the current page?
I need to run a stored procedure from an aspx page but because it takes a long time to complete, it times out at MyDataAdapter.Fill. This sp doesn't return any recordset but the number of records affected would be nice.
Protected Sub BtnProcessDT_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnProcessDT.Click
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyDataAdapter As SqlDataAdapter
MyConnection = New Global.System.Data.SqlClient.SqlConnection
MyConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("RevConnectionString").ConnectionString
MyDataAdapter = New SqlDataAdapter("uspINSERTDT", MyConnection)
MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure
MyDataAdapter.SelectCommand.Parameters.Add(New SqlParameter("@RowCount", SqlDbType.Int, 4))
MyDataAdapter.SelectCommand.Parameters("@RowCount").Direction = ParameterDirection.Output
DS = New DataSet() 'Create a new DataSet to hold the records.
MyDataAdapter.Fill(DS, "RowCount") 'Fill the DataSet with the rows returned.
Basic syntax of the stored procedure.
It SELECTS a single record (at a time) from a table, processes the data and UPDATES four other tables.
ALTER PROCEDURE [dbo_DHT].[uspINSERTDT] (@RowCount INT OUTPUT)
AS
BEGIN
select @RowCount=@@ROWCOUNT
END
Do I need to create a DataSet if all I want to do is capture the number of records? How do I increase the timeout? This is strictly an intranet web application used by one person so performance isn't a big priority. Editing the sp to reduce the amount of time to process isn't practical due to the amount of processing that occurs.
VS2005 Version 8.0.50727.42 (RTM.050727-4200)
.NET framework version 2.0.50727.3603
SQLExpress 2005 9.00.3042.00
