.net - Catching An Exception In C# / "Already There Is A Same Data" Or Any Words?

Feb 22, 2011

I have a simple button ADD

And ADD_Click code is:

protected void Add_Click(object sender, EventArgs e)
{
string strConnectionString = ConfigurationManager.ConnectionStrings["SqlServerCstr"].ConnectionString;
SqlConnection myConnection = new SqlConnection(strConnectionString);
myConnection.Open();
string hesap = Label1.Text;
string musteriadi = DropDownList1.SelectedItem.Value;
string avukat = DropDownList2.SelectedItem.Value;
SqlCommand cmd = new SqlCommand("INSERT INTO AVUKAT VALUES (@MUSTERI, @AVUKAT, @HESAP)", myConnection);
cmd.Parameters.AddWithValue("@HESAP", hesap);
cmd.Parameters.AddWithValue("@MUSTERI", musteriadi);
cmd.Parameters.AddWithValue("@AVUKAT", avukat);
cmd.Connection = myConnection;
SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
Response.Redirect(Request.Url.ToString());
myConnection.Close();
}

What i want is, if anybody adding a data with same HESAP (primary key) i want a alert() function with this words. "Already there is a same data" or any words. Doesn't matter.

How can i do that?

NOTE: I want just the same HESAP value getting and catching an error.

View 5 Replies


Similar Messages:

Catching An Inner Exception - But Only If There Is One?

Mar 14, 2011

I am trying to catch an exception but occasionally get an inner exception. I want to output both into a label. I often get Object reference not set to instance of an object if there is no inner exception.

Catch ex As Exception
exError = ex.Message.ToString
If Not ex.InnerException.Message Is Nothing Then
exError &= "<br/>" & ex.InnerException.Message.ToString
End If
Return View()
End Try

View 2 Replies

Watertight Exception Catching?

May 5, 2010

Take the following code...

[Code]....

The aim here is to throw an 'AfterInitException' if there's an exception after Init has finished. My concern is that some low level error might result in an exception being thrown when, say, setting up the call to DoStuff and before the try/catch block within DoStuff has been set up. So an 'AfterInitException' would not be thrown even though the exception was thrown after Init!This might help...

[Code]....

...but then this is more messy and perhaps there could still be a low level exception which arises in clearing up the call to Init or setting up the try/catch block that follows it!

View 6 Replies

C# - Catching An Exception And Clearing It Before ELMAH Gets It?

Feb 18, 2011

i have a problem where i have an exception being thrown that i am capturing in global asax. As part of this exception handling i redirect the user to a specific page because of this exception.

i also have ELMAH error handling with the email module plugged in. I do not want to receive emails for this exception. I also don't want to add this type of exception to ELMAHs ignore list, in case i want to do granular work around the exception (ie, only if it matches certain properties, happens on certain pages)

i want to:

write an Application_OnError that redirects a user to a page (i know how to do this part, more for procedure i've left it here) In the Application_OnError stop ELMAH fromrecieving this error after i've caught it

i am currently calling Server.ClearError() inside my App_OnError method, but am still receiving these emails....

View 2 Replies

C# - Catching A Custom Exception Thrown By A WebMethod On WebService

Oct 1, 2010

I have a classical asp.net web service (asmx) and a web method in it. I need to throw a custom exception for some case in my web method, and I need to catch that specific custom exception where I call the web service method.

[Code]....

However, I cannot do that because when I add the web service reference on the client, I have service class, input and output classes, but I do not have custom exception class.

Also another problem is that, I have also problems with serializing Exception class (because of Exception.Data property implements IDictionary interface)

Is there a way to do this in my way, or am I in a completely wrong way, or is there something I miss about fundamentals of web services?

View 2 Replies

Forms Data Controls :: How To Highlight Words In A Repeater When Match The Searched Words

Nov 17, 2010

I have a pretty basic search feature on a site that queries a sqldb with a sqldarasource, and then displays the results on a page, in a panel within a Repeater. I'd like to figure out if it's possible to somehow highlight the words the user searched on as they are displayed in the search results. The code below is my repeater. Do you know of any way to manipulate the Title or Description if the words in it's body match the words searched?

<asp:Panel
ID="pnlExperience"
runat="server"
Height="500px"
ScrollBars="Auto">
[code]...

View 1 Replies

Forms Data Controls :: Catching A Click Event Of A Button Inside The Footer Template Of A Repeater?

Feb 5, 2010

I have a repeater control and in its footer temlate is a button (or 2 in the example) and I want to catch its click event but seem to not be able to.

I tried in the repeater itemcommand event and also I tried defining a subprocedure for the 'occlick' event but neither works..

[code]...

View 3 Replies

Catching Exc As Exceptions?

Aug 5, 2010

I have the following code

[code]....

and while that presents a friendlier error message to a user, I've forgotten how to show me the "real" error.

View 2 Replies

.net - XSLT - Catching Parameters

May 13, 2010

The situation is I have two xslt files: one is called from my ASP.NET code, and there, the second xslt file is imported.What I'd like to accomplish is to pass a parameter to the first one so the second xslt(the one that is imported at the first xslt) can read it.

My c# code looks like this:

var oArgs = new XsltArgumentList();
oArgs.AddParam("fbLikeFeatureName", "", "Facebook_Like_Button");
ltlContentBody.Text = xmlUtil.TransformXML(oXmlDoc, Server.MapPath(eSpaceId + "/styles/ExploringXSLT/ExploreContentObjects.xslt"), true);

And I'm catching the param at the first xslt this way: <xsl:param name="fbLikeFeatureName" />

And then, passing it to the second xslt like this(previously, I import that file):

<xsl:call-template name="Articles">
<xsl:with-param name="fbLikeFeatureName"></xsl:with-param>
</xsl:call-template>

Finally, I'm catching the param on the second xslt file as following: <xsl:value-of select="$fbLikeButtonName"/>

View 2 Replies

Data Controls :: Highlight Searched Words In GridView

Apr 27, 2016

How to highlight searched words in gridview when serach performed on multiple column, i have 5 column in gridview and i perform search through text box and a button and bind gridview with searched record on all 5 column...

How to highlight searched keyword on all 5 column...

View 1 Replies

Forms Data Controls :: Validation For Number Of Words In A Text Box

Mar 8, 2010

I am having some text boxes in my webform. I need to set numbers of words for each textbox. if i put more than defined no of words it should show msgs or popup msgs whatever it may be.

View 2 Replies

Forms Data Controls :: Highlight Key Words In A Datagrid From A Search Box?

Nov 4, 2010

Is there a way to highlight key words in a datagrid from a search box?

View 8 Replies

Configuration :: Compiler Not Catching Compile Error?

Mar 10, 2010

Using VS2008 SP1, .NET 3.5 SP1, C# Web Application Project

As we know, Web Application Projects (unlike Web Site Projects) compile the entire site for deployment. We have discovered a situation where the visual studio compiler doesnt catch and error. Then when we deploy the dll to the website (or even just run it in the built in web server) it catches the error and displays it as a "compilation" error during runtime. This is obviously disturbing. Let me explain the error:

Take a single web page in a new C# web app project, such as the default.aspx. Add a checkbox. Create an event handler for the checked changed event. Note that it modifies the .aspx file to add oncheckedchanged="yourmethodhere" in the checkbox item. Compile and everything is fine.

Now change the name of the method in the .aspx file, say for yourmethodhere to yourmethodhere_1 and compile again. Note you havent change the code behind, so you SHOULD get a compile error. But you dont. Now if you deploy or debug it, you will get a compilation error during runtime.

Note: If you do exactly the same thing in a web SITE project, the validation compile that it does when you choose to "build" the project DOES catch this error. In other words, only c# web APPLICATION projects have this problem.

View 3 Replies

Javascript - ASP Update Panel, Catching Exceptions?

Aug 28, 2010

Thisis the code I use to display an aspxloadingpanel with an ms update panel:

var prm = Sys.WebForms.PageRequestManager.getInstance();
prm.add_initializeRequest(initializeRequest);
prm.add_pageLoaded(pageLoaded);[code]....

However when an error occurs on this page, the loading panel continuously remains on the screen...How can I catch errors so that instead it would actually show the error.

View 1 Replies

Forms Data Controls :: Filter Gridview With Multiple Words From Textbox

May 27, 2010

I have been stuck on an issue that is driving me mad and I bet its simple. I have a Textbox with a gridview and a LINQ statement in code behind that populates the data source of the gridview at page load.

The Textbox is used as a filter for the where clause in the Linq statement. All works as expected however I want to be able to use more than one word as a filter. This is the problem. I take the textbox string and convert to an array

Dim aryTextFile() As String = SearchString.Split(",")

But I need to figure how to pass the values of the array as parameters for the Linq Statement. I need to return all rows that have either a match for LocationName AND/OR Address AND/OR City. I thought of something like this but it fails.

Dim db As New DCLocationsDataContext
Dim q = From t In db.Locations _
Where t.City AndAlso t.LocationName AndAlso t.Address Like aryTextFile _
Select t
GridView1.DataSource = q
GridView1.DataBind()

View 6 Replies

Forms Data Controls :: GridView Best Way To Display With Lots Of Words In A Column?

Dec 28, 2010

I like to use GridView because it is easy and flexible to work with. However, I found it quite frustration when it comes to display a column with a large chuck of words into the value of that particular column. Is there anyway to restrict how many words should only be display in a particular column rather than let it expands to cope up to display all the word. For example, I'm trying to display 20w and normally it would display

wwwwwwwwwwwwwwwwwww

but I would like to limit to 5 words in a line so it's going to be

wwwww
wwwww
wwwww
wwwww

View 6 Replies

Data Controls :: Display Total Currency In Words Inside GridView?

Dec 15, 2013

I want to calculate Quntity*Rate into Total column in Gridview.

calulate the Gross Total of Total Column in Gridview Footer.

Text format of amount in Gross Total into Label Text. with AddNewRow,Remove Options.

How i can calulate the Gross Total and text in Gross Total in gridview?

View 1 Replies

Web Forms :: Catching Form Postbacks With Masterpages And Usercontrols

Jan 23, 2011

I have a website that serves all its pages using a single 404 page. it displays hotel profiles form business and depending on different profile levels offers more or less functionality and information.

Through the DB a masterpage is selected and usercontrols are applyed to that.

I have a contact page like this : 404.aspx > masterpage.Master > contact.ascx

My form action looks like this default.aspx?404%3bhttp%3a%2f%2fwww1.testsite.co.uk%3a80%2fcontactus

and when I click the button this where I send up with an error "Validation of viewstate MAC failed" error.

I have read stuff on these for 4 hours but still have no idea where to start.

Do I need to

Catch the form action URL (postback URL) in the baseclass and change it back to [URL] - If I do this are the form firled values still intact

Do i need to do something to change the form.action url before the page is built, if so is this done in the masterpage preinit event as this is what the form tag is

What I know works is that the usercontrol is aware of the postback, but not the form values.

I want to be able to add a 404 based contact us form on any one of 1000s of profiles and be able to catch the values. Idearly I would like to do this in the codebehind of the usercontrol as this keeps the code seperate

I am sure this must be possible and normally I can work stuff out, but here I am totally stuck. I am trying to do this in VB.

View 3 Replies

VS 2010 - Application Error Not Catching Exceptions From WebMethods

Dec 19, 2011

I have some code that is throwing unhandled DivideByZero exceptions in a WebMethod. These exceptions are not being caught by the global logging in Application_Error in global.asax. why exceptions thrown from a WebMethod are not handled by Application_Error?

View 3 Replies

Forms Data Controls :: How To Make Some Words Of A Cell In Gridview Bold Type

Aug 16, 2010

I'd like to make some words of a cell in gridview Bold. For example - "MRN No.: SI0021848 Name: Cherry" like my attachment. I could query this field value from database but don't know how to make some words Bold. How to do it?

View 2 Replies

Forms Data Controls :: Shorting String To Maximum Length Without Cutting Words?

Dec 21, 2010

i need to cut the text from a box to a shorter version. what i'm using right now is :

CAST(DescriereNoutate AS nchar(200)) AS Descriere from the SqlDataSource, but im having problems because this cuts the words.

how can i do this without leaving the words cut in half.

View 2 Replies

Data Controls :: JQuery AutoComplete With Multiple Words Inside GridView Control

Feb 25, 2014

I found this usefull code in this website but i was wondering a way to select a multiple names in textbox inside GridView.  I have seen one exampe on this website but the example is not in GridView. Here is my code that works fine now but it does not let me select multiple names:

<script type="text/javascript">
$(document).ready(function () {
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
Sys.WebForms.PageRequestManager.getInstance().beginAsyncPostBack();
function EndRequestHandler(sender, args) {
$("[id*=txt_UID]").autocomplete({

[code]....

View 1 Replies

Forms Data Controls :: Search Multiple Words Into Textbox And Populate All Records In Gridview

Aug 24, 2010

I have a textbox and a gridview which is bound to a table what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;

1. Book
2. Red

I have set up the sql data source and everything and my like operator is this.

LIKE '%' + @record + '%'

how can I solve this problem?

View 3 Replies

C# - Catching Exceptions Thrown In An Asynchronous Web Service Completed Event Handler?

Feb 12, 2010

Imagine a web service with a method that returns a Customer object, that takes a customer ID as a parameter, i.e.

[WebMethod]
Customer GetCustomer(string customerId)

Now imagine that you're writing an ASP.NET app and you've generated a proxy for the service with the async operations. You create an instance of the service, wire service.GetCustomerCompleted to your handler, OnGetCustomerCompleted, and call service.GetCustomerAsync("12345"). In OnGetCustomerCompleted you apply logic to detect that no customer was found and throw a custom exception, or you want to throw the exception found in e.Error, e.g.:

void OnGetCustomerCompleted(object sender, GetCustomerCompletedEventArgs e)
{
if (e.Error != null)
throw new ApplicationException("GetCustomer failed", e.Error);
if (String.IsNullOrEmpty(e.Result.FirstName) && String.IsNullOrEmpty(e.Result.LastName))
throw new CustomerNotFoundException();
}

(I've omitted the bits of code that sets up a Customer object and persists it through the calls.) You launch the call to GetCustomerAsync in Page_Load and expect to retrieve the result in a handler wired to Page.OnPreRenderComplete. My question is, how do you catch the exception in your page? I know you can catch it with Global.asax's ApplicationError, but what if you don't want to navigate away from your page?

View 1 Replies

DataSource Controls :: Getting Exception / An Exception Occurred While Executing A Transact-SQL Statement Or Batch

Jan 1, 2010

i need to restore Database.mdf; I create a blank new database exactly the same name as the .mdf file. However, I could not restore the database.

The error message prompted was:

TITLE: Microsoft SQL Server Management Studio Express

An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.Express.ConnectionInfo)

ADDITIONAL INFORMATION:

Cannot open backup device 'C:inetpubwwwrootTCPSystemApp_DataDatabase.mdf'. Operating system error 32(error not found).

RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

click: [URL]

BUTTONS:

OK

View 10 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved