Executing A SQL File Or Query Via A Submit Button?
Jan 28, 2010
I'm trying to figure how to on a submit button execute an sql file.
We have a job recruiting application, and for the subsidiaries companies they all have their own database setup for the jobs. At night the application has a consolidator script built in to pull all the jobs posted in those companies and load the posting into the parent companies website job listing. This listing will then point back to the Subsidiary website for the applicant to apply.
The issue with that script is the time it took to execute which is 20hrs to run as a scheduled task. We have created a more efficient script and would like to place a submit button in the admin panel for the HR recruiters to click which will automatically upload their updated job listings to the parent company.
So what would be the proper coding framework to use on the submit form to execute our new consolidator sql script?
View 3 Replies
Similar Messages:
Nov 11, 2010
I'm working on an ASP.NET application. Currently when the user clicks "Save" on an item, we disable the Save button, change its text to "Saving..." and so on. This works fine, because the button causes a postback which results in a new page being loaded, on which the Save button is no longer disabled.
We now want to apply this to other actions: Publish (not much different from Save), Import (again, much like Save, but based on data the user has uploaded in a previous step), Export (downloads an XML file to the user) etc.
Export is causing me problems - the button stays disabled. I think this is because the server sends back an XML file rather than a new web page, and so the browser just displays the same page.
The server-side code is along the lines of
Response.Clear();
Response.BufferOutput = true;
Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + whatever);
[push file contents into Response.OutputStream]
Response.End();
a way of making the server send a fresh page back in the response as well as the XML, thus re-enablnig the button in the same manner that the other pages do, ora way of getting the browser/JS to re-enable the button once the file has been sent.
View 2 Replies
Sep 12, 2013
I am using upload feature in my asp website. So i am using file input type. But this control add a default upload button browse and a textbox where path is shown after selecting file in Internet explorer. I don't want to show browse button etc. So what i did is add a button "Attach a File" and i have written script 'triggerFileUpload' function where i make it to click on upload control.
So now when i click on "Attach a File" button browse for file windows appears and can select file to upload. But when i click on submit button the file upload control becomes reset and file is not uploaded. Error is that on clicking to submit button the file control becomes null. It happens only in internet explorer.
Below is code which can show the problem i am facing in IE.Same problem comes if i use asp:FileUpload control also. (my plan is to hide the file control and show only attach file button to user).
Code:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!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>
<script type="text/javascript">
[Code]...
View 3 Replies
Aug 18, 2015
I have fileupload control on button click event it is uploading file to my folder. its working fine.
i want as the user give the file path using file upload control browse button it uploads the file user does not need to click on button.
View 1 Replies
Apr 28, 2010
I am opening excel file in div using IFRAME. Now i want to save the excel file by submit button , which is available on page
<div>
<iframe src="Test.xls" style="height:300px;width:600px">
</iframe>
</div>
<asp:button runat="server" id="submit" />
How to upload the file using iframe
View 1 Replies
Feb 12, 2010
I have 2 SUBMIT button in a form one is display:hidden and one is display:block if user click on SUBMIT button (display:block) then another SUBMIT button {display:hidden} should also submitted.
View 2 Replies
Jan 4, 2011
In ASP.NET when we have multiple input section with required field validator (Like on header for login with userid & Password is required and second on footer for subscription) when we click on subscription login section's userid required field validator activates and say userid required & i can not submit subscription.
when i submit subscription details login section should not have concern with this. how to avoid this conflicts.
View 2 Replies
May 17, 2010
In C#/Asp.net I have 2 submit button i.e.
btnOk and btn_Submit
Initially I am doing validating form by clicking on btnOK and in btn_Submit I am inserting record into table. I again want to call btn_Ok event in btn_Submit click event for re-checking validation, if it validates properly thne rest of code of btn_submit should work.
View 4 Replies
Apr 20, 2010
I am excuting SQL Query using Nhibernate, here is my code
public ArrayList getDocumentsForApproval(string ReleaseId)
{
string query = string.Format("SELECT distinct doc.Id, doc.Name as Doc, doc.url as url, suser.Name as Author, ds.name, CONVERT(VARCHAR(11), doc.DateEntered, 101) as DateEntered FROM dbo.Documents doc INNER JOIN DevelopmentSteps ds ON doc.TypeId = ds.Id INNER JOIN DocumentTrackingItems dti ON doc.Id = dti.DocumentId INNER JOIN TrackingItems ti ON dti.ItemStepId = ti.Id INNER JOIN dbo.Releases rl ON ti.ReleaseId = rl.BugTrackerName left outer join (select * from users) as suser on doc.AuthorUserid = suser.Id WHERE doc.DateEntered IS NOT NULL AND doc.DateApproved IS NULL AND rl.ID = '{0}'", ReleaseId);
ISession session = NHibernateHelper.GetCurrentSession();
ArrayList document =(ArrayList) session.CreateSQLQuery(query).List();
return document;
}
Exception Details:
NHibernate.QueryException: Return types of SQL query were not specified [SELECT distinct doc.Id, doc.Name as Doc, doc.url as url, suser.Name as Author, ds.name, CONVERT(VARCHAR(11), doc.DateEntered, 101)
View 1 Replies
Oct 27, 2010
I have a button within a TabPanel and i have a button click function written in Jquery that is not executing when i click the button. If i remove the tab panel and container it works, but i would like to use the tab panel/container functionality. See code below:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>
<!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 id="Head1" runat="server">
[code]...
View 5 Replies
Feb 2, 2010
I have an article submission system on my website whereby a user inputs a bunch of information and submits it to the database. After the user presses the "submit" button, apart from submitting the article to the database, I want to also execute another rather large SQL query that inserts additional data into a seperate table.
However since this execution may take a while, I do not want the user to have to wait for the query to be successfully completed before they are forwarded to the "submissionsucess.aspx" page. In other words I would like the larger sql query to take place while the user is still on the website. So I was wondering if there is a way to do the following:
1. User submits article.
2. Simple submit query is executed.
3. Submit query is finished...start complex longer query (takes time).
4. User is forwarded to success page, user then continues to browse website. Complex query still executing at the same time, while user browses website.
5. Complex query is finished.
View 4 Replies
Sep 30, 2010
Im using SQL Server 2008 R2, Server version 9.0 SP3Im trying to do a replace on a comma seperated values before submitting to the "IN" condition.
[Code]....
[Code]....
View 2 Replies
Nov 29, 2010
I have a strange error, I've tried to search for it before writing this post but I wasn't able to find out a solution yet.
I'm executing a query using ExecuteStoreQuery against a MySQL database, but it throws an exception reporting that there's a syntax error in my SQL.
I've tried to copy&paste the sql query into the MySQL tool and it works nicely, giving the correct results.
I've tried to open manually the connection and using CreateCommand to use it the "old way".
My query is a bit long, 4000 chars more or less, could it be the problem?
View 4 Replies
Mar 9, 2010
Currently i am having an UploadFile action result that is working.
My form looks like that:[Code]....
If i select a file with "file1" input and i press the "submit" button, the file is "found" and saved in code-behind file.My "showUpload" javascript function looks like that:[Code]....
It is triggering the same UploadFile Action result, but it doesn't find any file [:(]
Here is my ActionResult script
[Code]....
So, if i am selecting file and i press "submit" button, Request.Files has 1 file, but if i press the standard "upload file" button, Request.Files has 0 files
View 2 Replies
Jun 23, 2010
I am having problem in diffrentitate error between internet connection loss error and Other Error in query for example: duplicate record found.
Both the error fall into System.Data.SqlClient.SqlException category.
But the way to handle both this 2 error is different.For connection error , i need to bring user to connection loss page while for duplicate record found error, i need to show the user a pop up.
Unless i do a checking exactly on the error message , else i have no ways to differentiate connection loss error and any other error. Am i correct for this?
View 1 Replies
Aug 31, 2010
I have a webpage with 6 drop down lists. User can start with selecting any drop down list first, and then proceed in any order. 1. Assume when the 1st dropdown is selected first, rest 5 drop downs (except 1st) are filtered/updated based on the selected value in the 1st dropdown.2. Assume user selects the 4th dropdown second, rest 5 drop downs (except 4th) will be filtered/updated but the condition would be based on both 1st drop down and 4th drop down. But while filtering the first drop down, only the 4th drop down is used as filter (self-filter will be ignored).
The code works fine but I see a very bad performance hit in time when the user selects the fourth dropdown after selecting three drop downs. I tried using both SQLDataAdapter and SQLDataReader but neither used to solve the issue. The code takes a lot of time on one line in either of the code (which is highlighted below). When I run the query in SQLServer Mgmt Studio, the query completes in a few seconds.
[Code]....
View 5 Replies
Oct 21, 2015
How do i hide button Add after data submission and display button cancel.
View 1 Replies
Feb 9, 2011
I have 3 tabs with 3 seperate gridview and radios buttons in them. Each page has a seperate submit button, but for some reason each pages submit button is validating all the radio buttons on each tab, i picked the seperate controls to validate under but on any submit theya re all validated instead of just the ones on that tab.
[Code]....
View 5 Replies
Jul 24, 2010
I have a databound Gridview (with a LINQ datasource). The gridview displays questions from the SQL DB to the user. I've inserted a radio button list into the gridview with 3 horizontal radio buttons with fixed values of 1,2,3 for the user to select. I have a question ID, a tempuserID, and AnswerValue columns set up in the database. It all works nicely.
After the user selects radio buttons, I would like for them to push a button to submit the QuestionID, the associated Radio Button Value (AnswerValue) and their tempUserID into the DB. How do I do this? I'm not sure what to do next and what VB/LINQ code to put in the code behind file in the button click event handler. I'm also not sure on what to use for the tempUserID, can I use the sessionID? I'm using VB and here's my code:
[Code]....
View 15 Replies
Feb 15, 2011
On a webform, I've got a Button inside a Placeholder control. Initiallty, I set its Click event declaratively in markup:
<asp:Button runat="server" ID="btnSubmitAgain" OnClick="btnSubmitAgain_Click" CssClass="button iconButton SubmitAgainbtn" />
However, everytime I click this button it bypasses the defined handler (the breakpoint I set is never hit) and behaves like a generic submit button and causes a postback. My handler clears a session variable and then Redirects back to itself so does not cause a postback).I've got an almost identical version of this form which behaves correctly and is, to all intents and purposes, identical code.
View 1 Replies
Jan 12, 2011
How would I take a text box value and use it in the query string on submit? I'd like it to start as this,
/News?favorites=True
and end up something like this after the user enters in a search and clicks search.
/News?query=test&favorites=True
The controller action looks like this
public ActionResult Index(string query,bool favorites)
{
//search code
}
View 1 Replies
Feb 5, 2011
working on a project interfacing RFID and Vb.
I have got the code for interfacing VB to RFID CAN ANYONE TELL ME HOW CAN I SUBMIT MY ENTRY TO DATABASE AS SOON AS THE TEXT APPEARS IN THE TEXTBOX AND WITHOUT USNG A SUBMIT BUTTON?
View 1 Replies
Jul 9, 2014
I was given this sample code from a financial institution to take a credit card payment:
Code:
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Insert title here</title>
</head><body>
<form method="post" action="<% Response.Write(ConfigurationSettings.AppSettings["BaseUrl"] + "MakePayment"); %>">
<input type="hidden" name="biller_code" value="123456" />
[Code] ....
But the problem is, that i need to put this into a VB.Net aspx page. And so the way here of doing a form/submit button won't work.
How do I put the code above into an aspx page written in VB.Net?
View 3 Replies
Dec 25, 2010
I added a Button and a LinkButton to same page and set same properties to both of them. LinkButton works fine but Button's PostBackURL not work after executing javascript (Clicked "OK" in message window). it posted back to same page instead of second page. following is the code:
<asp:Button ID="Button1" runat="server" Text="Button"
PostBackUrl="~/second.aspx"
OnClientClick="return confirm('Switch page?');" />
<asp:LinkButton ID="LinkButton1" runat="server" Text="LinkButton"
PostBackUrl="~/second.aspx"
onclientclick="return confirm('Switch page?');" />
View 2 Replies
Nov 23, 2010
I have never worked with dot net... this is my first project that I will be working on... What I need is a Web browser which executes the T-Sql stored in XML file and the output is shown in the browser.... There will be a node and when I select that node it should run a tsql in XML file and show the output in the browser...I was told to use ASP.net and C#..
View 7 Replies
