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?
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.
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.
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).
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.
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.
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.
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)
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:
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.
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
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?
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.
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.
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:
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.
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?
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:
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#..
