n my button_click event, I have three data connections being opened and closed... I'm wondering... should I have one try/catch statement with the three connections and executions in the single try/catch... or should I have a try/catch statement for each connection/execution?
View 9 Repliesi am having a listbox which contains some entities which i need to select in order to make the submit button work successfully but when no entity is selected it should give an error
protected void SubmitBtn_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
on.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
[code]...
Here is the problem I have this code and i need to write logic to it, but i need to use error handling incase any of the varibles is null:
[Code]....
SELECT u.Email FROM UserProfiles p, aspnet_Membership u WHERE p.RulesCheckBox = 'True' AND u.UserId = p.UserId This gives me a list of registered member email addresses that have selected the RulesCheckBox in their profile, so I can email them with an email script. There is a relationship between the Membership table and the UserProfile table, so it finds the email addresses from the Membership table where that user has the RulesCheckBox checked in their profile (in UserProfiles table). I'm wanting to add some additional names to this list, from a different table. The purpose is so I can manually add email addresses to the additional table, so the additional email addresses will also receive the same email, even though they aren't registered members of the site. So how can I adjust that SELECT statement so this one is combined with it somehow?:
SELECT Email FROM ExtraEmails WHERE Rules = 'true'
know how to navigate to confirm or error page from try catch statement in VB on 3.0 .net website
View 5 RepliesI basically have a series of tables from one database that have an identical structure thus making retrieval of all records fairly easy (I just use a UNION ALL statement). However I need a list of values from another table within a different database that contains information regarding the group of the data.
I so far have the following:
SELECT Table1.* FROM Table1 UNION ALL SELECT Table2.* FROM Table2 UNION ALL SELECT Table3.* FROM Table3 UNION SELECT Database.dbo.SRFILE.SR_GROUP FROM Database.dbo.SRFILE INNER JOIN Database.dbo.SRFILE.SRONUMBER = Table1.Incidentx
I keep receiving a unable to parse message however all I need to retreive is the SR_GROUP value but just don't know the correct syntax. Is it actually possible to do this as the structure of SRFILE is not the same as Table1/2/3.
In the Script documents that asp.net automatically generates how can I surround the whole generated scripts with try/catch statement to avoid 'Microsoft JScript Compilation error'
My issue is: i got a DevExpress control (ASPxGridView) that added and set-up in run time, since i activated the grouping functionality in the grid I still get JS error says ';' expected whenever i use (click) on one of grouping/sorting abilities, I activated script Debugging for IE, in the JS code turns out that there is no missing ';' and once i click ignore for the error msg that VS generates every thing works fine, and surly end-user can't see this msg so i figured out if i try/catch the script that may help avoid this error.
what is the order of multiple catch?
Place under the try block :
1 :Major
2 :Minor
3 :Critical
some thing like this..
try
{
}
catch(Exception1 ex)[code]....
In my web application, some users open app in multiple browser page. How can I catch users when they do it?
Edit about why I need such this thing: I have a variable named DealerID, carried between pages with session. Some users want that: "While I make my jobs with a DealerID in one page, make other jobs with another DealerID on another page"
Here is the code copied from [URL] In asp.net code behind, I use try-catch try to catch any error but never catch it. In SQL database, if I rename Employees to Employeesx or change column DepartmentID to DepartmentIDx, record will not be deleted (it is right) without any error (it is wrong, suppose catch an error).
CREATE PROCEDURE DeleteDepartment
(
@DepartmentID int
)
AS
BEGIN TRANSACTION
DELETE FROM Employees
WHERE DepartmentID = @DepartmentID
IF @@ERROR <> 0
BEGIN
ROLLBACK
RAISERROR ('Error', 16, 1)
RETURN
END
DELETE FROM Departments
WHERE DepartmentID = @DepartmentID
IF @@ERROR <> 0
BEGIN
ROLLBACK
RAISERROR ('Error', 16, 1)
RETURN
END
OMMIT
I get this error in the browser:
Code:
Thread was being aborted.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Threading.ThreadAbortException: Thread was being aborted.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ThreadAbortException: Thread was being aborted.]
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +486
System.Web.ApplicationStepManager.ResumeSteps(Exception error) +501
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) +123
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +379
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
I have try{}catch(Exception ex){} in the right place:
Code:
protected void Button1_Click(object sender, EventArgs e)
{
try
{
// all processing occurs inside here
}
catch(Exception ex)
{
}
}
I even created a global.asax file and on the Application_Error event, I wrote a code that would email me the error (and i'm not getting an email regarding that error when I get the error shown above). I know for a fact that the thread is going inside the "try" statement because I send emails to myself whenever it finishes certain codes inside of it. So how come I'm getting that error in my browser instead of it being handled in my "catch" statement? I have two problems here, one, why is the exception not going to my "catch" statement, and two, why am I getting that error in the first place.
Note: my web app calls a webservice.
have a very important issue,i have three Stored Procedures Sp1,Sp2 and Sp3 .the first one (Sp1) will execute the second one (Sp2) and save returned data into @tempTB1 and the Second one will execute the third one (Sp3) and save data into @tempTB2.if I execute the Sp2 it will works and it will returned me all my data from the Sp3 ,but the problem is in the Sp1, when i execute it it will display this Error:INSERT EXEC statement cannot be nested I tried to change the place of execute Sp2 and it display me another error:Cannot use the ROLLBACK statement within an INSERT-EXEC statement.
View 4 RepliesI am trying to create a quesry that will grant me access to 3 entities that are related. Here is the SQL of what I am looking for.
[Code]....
to do this, I create the following LINQ
[Code]....
How the relationship is following
.1 to * - CLAIM_REF to RESERVE_LINE_REF
.1 to * - RESERVE_LINE_REF to FIN_TRAN_REF
There is no direct association between CLAIM_REF and FIN_TRAN_REF, they are only associated through RESERVE_LINE_REF What is the proper LINQ Query to mimic the SQL statement above?
I'm trying to remove a user from the aspnet_Users table.
[Code]....
I received the following error during my try-catch test:
System.Data.SqlClient.SqlException was caught Message=The DELETE statement conflicted with the REFERENCE constraint "FK_lusHmoob_aspnet_Users". The conflict occurred in database "laujtsov", table
"laujAdmin.lusHmoob", column 'whoInsert'.
The statement has been terminated.
Source=.Net SqlClient Data Provider
ErrorCode=-2146232060
[Code].....
Im using Google Analytics Dashboard Control which are available at [URL] Issue is its working fine when im connected to internet but if im using it on a machine that doesnt have internet access then it shows Server Error in '/' Application. The remote name could not be resolved: '[URL]' I want to catch this exception and shows a friendly message to user. Im calling these dashboard control on my View in an iframe like this <iframe src="../../GoogleAnalytics/Visitor.aspx" height="275"></iframe> and if i place try catch in Visitor.aspx page it doesnot catch the exception. How should i catch this exception, Im using asp.net mvc 2 with c#
View 3 RepliesI am currently trying to create a SQL statement that does a multiple count on a table. The table has a number of reports each listing the "User" who created that report and if that report is "Famous" (A famous report is symbolised as 2 in the table).
What I need to create is a SQL statement that returns each User with the total number of reports he/she has created and how many of these reports are famous. My current SQL statement looks like:
[Code]....
I am fairly new to the asp.net scene. Having build a dashboard gathering info on my OLAP system's health status, I can't seem to figure out how to make sure that I catch the no connection exception.I use the following statements on the datagrid:a) want to change the color of ssas2 button to red if an exception is throw
MyDBConn.ConnectionString =
"Provider=MSOLAP.4;Data Source=core-ssas2;Integrated Security=SSPI;Initial Catalog=Financials;Connect Timeout=6000"
MyDBConn.Open()
MyDBConn.CreateCommand.CommandTimeout = 120
I have 50 textboxes in a table and i would like to write a conditonal statement. If the textboxes has null or empty then i want to assign them 0 to all the textboxes.(VB.Net) I tried
[Code]....
if I have three Dropdownlist A, B, C, how can I write a select statement to get data from sql server based on the dropdownlist selected.e.g. if user select dropdownlist A, select * from table where A = dropdownlist A but if user select dropdownlist A and C, then select statment is "select * from table where A = dropdownlist A and B = dropdownlist B or if selected A, B, C.......how can I settle so many choice.
View 2 RepliesI've got 3 tables.
Table A: UID, Name
Table B: CID, Category
Table C: ID, UID, CID
I've got a TextBox to capture the value of "Name" in Table A.
Ive got a CheckBoxList that displays all the pre-determined values of Table B.
When the user selects an item from the CheckBoxList i want to populate Table C with the value of the selected item from the CheckBoxList and the cooresponding ID associated with the user name for that person's entry.
How do I write the INSERT statement?
How can i Drop Multiple table through an SQL Statement rather than using a procedure or a function.
View 7 RepliesI have an asp.net control that contains a grid view sitting on top of an Ajax update panel. The control has been added to a sharepoint page. When a button is clicked, some server code is called to store the contents of the grid. If the server code throws an error, I want to spit out a javascript alert displaying the error message, but for some reason the error that bubbles up from the server is the generic 500 server error, which doesn't contain any details of the original error.
View 1 Repliesim creating advance search for my project and end up with the problem of select statement format for 2category.
here is example:
i have advancesearch that has checkbox wherein you can select multiple checkbox. example is selecting category, for example ihave 5 category as shown below.
Category
News Sports Opinion Editorial Literary i did tried someformats for my select statements to make it work for 2 or more category, but i just cant get the right format of the select statement.
example if i select the following.
if selected is category 'Sports'
it wil work with this: " 'Select * MyTable1 where [Category Title]='Sports' "
if selected are category 'Sports' and 'News'. what must be the format for my selectstatement for 2 or more category in the same fieldname? should it work with this?
" 'Select * MyTable1 where [Category Title]='Sports','News'" no, how could i make it work. what must be the right format?
[Code]....
I have a select statement that is supposed to be filling grid with information from an income table. It's only supposed to pull if the income is from the current fiscal year or is less than 1 year old. Currently, what it does is pull multiples of rows and also rows from past income years but only if there is a mixture. For instance, if a person has income from 2005 and 2010 what it will show is this
Income 2005
Income 2005
Income 2010
Income 2010
Income 2010
Does anyone know what I've done wrong? BTW, those results are exact, old income is shown twice, current is shown 3X
This question is for wrapping up work on a database driven AJAX AutoComplete Control that I am using to provide keyword hints to user on search pages. Each record has 6 columns for keywords where each column is for an advertiser to add a keyword. These are used in meta keywords tags, but I also want to use them for AutoComplete. The problem is that I don't know how to write a SELECT statement in Visual Studio that treats all 6 keyword columns as if they were all one column. I am looking for something like
SELECT (keyword1 + keyword2 + keyword3) AS Keywords
FROM (Merchandise)
WHERE Keywords LIKE @term
The only other thing I can think of the gain this level of functionality would be to combine them into a new table.