We have a dataset dsActualCost which fetches query value: MonthName in one column and Cost in another.
We have a code to display data in table format.
For MonthIndex = 0 To dsMonth.Tables(0).Rows.Count - 1
Dim tdMonthlycost As New TableCell
If dsActualCost.Tables(0).Rows.Count > 0 Then
[code]...
When processing many records starting from 10,000 System.OutOfMemoryExceptio get the error. There would be some way to handle this type of memory error ?.
ASP.Net SqlBulkCopy- Bulk Insert records and Update existing rows if record exists Exception: Out of Memory Exception C# and VB.Net
I would like to check whether a folder exists or not if not create. I'm sure this folder exists, but for some reason I get "false" when I check with "Exists" method.
The only reason I think could be because of the W: drive? I moved this application to production site and even there it returns false.
while I'm type in Windows explorer on my localhost and on the server "W:/Webs/ASPPages/cropper/uploads" it opens this folder. So my localhost and IIS server has W: mapping.
for test I tried to create the folder then it says can't find the path...
userFolderName = @"W:/Webs/ASPPages/cropper/uploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried "W:\Webs\ASPPages\cropper\uploads"
DirectoryInfo dirInfo = new DirectoryInfo(userFolderName);........
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
I am working on a 3-tier asp.net application. Currently I'm stuck up in a situation where I need to handle a specific type of exception (User Defined) in DAL and Show alert to the user if that exception occurs in DAL.
I tried following things:
1) I raised that exception from the DAL and catch it in BLL and throw a new BLL exception to for that DAL exception and finally catch it in the UI layer to show the alert to the user. I've successfully implement this in my project. But there are some issues in this approach. First of all I feel this is not right way to do this as it may lead to performance related issues. Secondly, the application contains more than 500 pages and classes. so I need to attach additional catch block in every method to catch the BLL exception. which is the last option i'd like to take.
2) in second approach I logged the the DAL exception into a text file. but problem in this approach is that how could the UI layer know that exception has occurred and show the alert to the user. Is there any event in asp.net where i could handle all this activities?
my question is what is the best approach to handle this type of situation? Will Exception handling block help me in this?
I've tried reading many articles on this but i couldn't get an answer for my question? I might not be using right keywords for my search.
In ASP.NET,How can i know the Specific details about an exception (like What kind of Exception it is (FileNotFound /Arithmentc etc..) )from a General Exception class object.
View 2 Repliesi have this application structure:
1. Presentation Layer which calls
2. Business Logic Layer which in turn calls
3. Data Access Layer to do the dealing with the database.
Now i have a Contacts page from where i can add a new contact to the database.So to add a New Contact i fill in all the required details and then call a Add Method (residing in the BLL) from the page, which in turn call a Add Method residing in the DAL.this method in the DAL returns the Current Identity of the record which is then return back to the BLL method and finally delivered on the page.this is fine. but what if a get an exception how do i handle it properly because the method in DAL has a return type of int and i dont want to throw another error!! coz other wise i will have to write try catch in almost all the methods.
//something like this
public int AddMethod(ContactClass contactObj)
{
int result = 0;[code]...
rather i want to show the user a user-friendly message which they can easily understand and in the mean while i will send a mail to myself documenting the Error that just occurred.how can i implement my custom exception classes.
Is there any way to uniquely identify a particular exception from the general exception class.
i.e any property or method that retrieves a unique identifier that to identify a particular exception.
I have kept some error values and corresponding error texts in an xml file. I want to read that xml file and have to taken the error ids and fix the corresponding texts to a label. in the case of a system exception we have to identify a particular exception.
Difference between Exception and Fault Exception..?
Can i use Fault Exception when i get the Exception.
We're getting this InternalSubStringWithChecks exception with our application's healthMonitoring. This exception is like the Padding is invalid and cannot be removed exception where it's being recorded and we're getting a notification email but the end user is unaware that an actual error has happened. Though we don't want our event log filled up with this rubbish! The stack trace is:
Parameter name: length
at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
at System.Web.Handlers.AssemblyResourceLoader.System.Web.IHttpHandler.ProcessRequest
[code]...
I have simple 3 tier web application and have mostly CRUDE functionalities. Recently I required to add new console application to the existing solution in which I call data layer methods for retrieving data from DB but I get an exception "The type initializer for threw an exception."When I debugged I found that the exception is thrown at datalayer on first line of class where I get connectionstring from
web.config, the code is public static readonly string CONNECT_STRING =
ConfigurationManager.ConnectionStrings["DbConnectString"].ConnectionString;
Now if I hardcode the connection string value like public static readonly string CONNECT_STRING = "Data Source=XYZ;uid=sa;password=XXX;initial catalog=ABC;"
it works fine.I don't understand what is the issue here as web application works fine with this datalayer.
I ma trying to update a sql table using linq using the below code and i get the subject error.
[Code]....
I tried to illustrate the problem by providing the following instructions, unfortunately the data was deleted and the example failed. It is now working. I have been working through one of Scott Mitchells ASP.NET Application Tutorials Title "Using TemplateFields in the GridView Control"
The URL is ...
The example demonstrates a temporary field being used in different ways, one of which involves dates in a Calender. If the HireDate in the example is deleted or not available the program fails. Providing the date is a valid date it works fine....
I want to know how it is possible that I get an error like this: key already exists in this method:
[Code]....
I added a new directory and page to my website. when I try to browse to this new page I get redirect to my Default.aspx page with ?aspxerrorpath= appended to the query string.IIS shows the page is visible. The page is there. Why would I not be able to access this page?
View 6 RepliesHere's the case I created this Permias.mdf on another solution that I had and then after that I decided not to use that solution and created a new website from visual studio and copy and paste the .mdf file to be used for this website.
Database 'C:\Permias.mdf' already exists. Choose a different database name.
i am building a project using C# Asp.Net in which i am registering users with a user id, now my question is that how to check that the user id is already exists in the user table or not when user trying to register, i am using sql server 2000?
View 3 RepliesI have a property object that has many activities associated to it. I want to delete all the activities and then add specific ones back in. I am doing this all before the objectcontext save. I am using multiple objectcontexts and attaching/detaching the objects. I am getting the property from the propertyreository objectcontext which is the primary context. Then I get the user which takes a bool to determine if I want to detach from the userrepository object context. I attach to the propertyrepository.
All is good but when I remove all the activities from the property object (entityobject) and then try to attach the activity that I retrieve from the database I get the error: key already exists in the ObjectStateManager Error. When I remove all the activity entity objects from the property entity object they are not really deleted from the objectcontext or the database until I use the save() on the objectcontext which will change all the entity object statuses. How then after I remove the activity do i add it back to the property.Activities?
Controller
[Code]....
Property class
[Code]....
I have a database for a shop. Now I have run into problem when I'm adding products. I have a page where i add general info of the product that will be adding to the product table. Then I should have a page where I can add colors and sizes and so on. But how do I do that? When I add the product I set a price in the productdetail table and colorId and sizeId is sett to null. If I add a color to the table how do I do this the easiest way? I will not have a product where both colorId and sizeId is null. I have this SP and table structure. Then I'll do the same when I add sizes.
[Code]....
Imagine I have 3 classes (student has Marks which has subjects)
[Code]....
I got a List<Student> populated with all the student and nested collection of corresponding Marks and subjects.How do I, before binding this list to any grid, filter records to display only those students, who surely have appeared in subjects with name "X" and "Y"?I tried something like:
[Code]....
i have two datatable, while adding rows in second datatable, i want to first check whether the id in the second datatable matches as in the first datatable, if not only then it should be added in the second datatable, else it should display a message...
i dont have any Primary Key defined on any column, so the rows could be repeatative.
I am a beginner coder, i am building a project using C# Asp.Net in which i am registering users with a user id, now my question is that how to check that the user id is already exists in the user table or not when user trying to register, i am using sql server 2000?
View 4 RepliesI'd like to use a simple switch to display one image or another but I need a way to find out if the image exists.
If FILEEXISTS("pathtojpg") Then
'Display jpg
Else
'Display "no_image_yet.jpg"
End If
How do, to see if an object exists? For example, I want to see if there is a DropDown on the page. I tried this:
if (object != null) {}
But it does not work.
I am very new to this and have watched a lot of the videos. While trying out VWD2010 and SQL2008 Express, I come across many things, I just don't know how to do. Here is the latest:
I have a Table
UserId - Int - AutoIncrement
FirstName - Var(10)
LastName - Var(10)
I also have an ASP web page that allow the user to enter a first name and last name. It also has a button to submit. What I would like to do is have a Select statement check to see if the name already exists, then send a comment back to the user via a label. If it doesn't exist, then I would like to Insert the info and then again inform the user via label.
SelectCommand="SELECT COUNT (UserId) FROM Users WHERE ((FirstName=@FirstName) and (LastName=@LastName))"
InsertCommand="INSERT INTO User(LastName, FirstName) VALUES (@FirstName, @LastName)"
<InsertParameters>
<asp:ControlParameter ControlID="tbFirstName" Name="FirstName"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="tbLastName" Name="LastName"
PropertyName="Text" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="tbFirstName" Name="FirstName"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="tbLastName" Name="LastName"
PropertyName="Text" Type="String" />
</SelectParameters>
On the code behind, I get lost. (Obviously this doesn't work, but I don't know how to go about getting a results back. Protected Sub bSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bSubmit.Click
SqlDataSource1.Select(DataSourceSelectArguments.Empty)
(get a return)
(check return value, if <>0 then
lblResults.Text = "exists!"
else
SqlDataSource1.Insert()
lblResults.Text="added!"
end if)
End Sub
