I am going to making asp.net 4.0 for first time. I was making my all application in asp.net 2.0 where I was using DAL and BLL method. In that DAL I was making Table Adapter.
Now I am going to make application in asp.net 4.0 and I am thing that my application will become more complex and huge data. Can somebody guide me about stable and fast method for data manipulate like insert, update, and delete also complex query.
I have a project I am working that requires me to go to an FTP port and copy a file to the local machine... so far so good... the next step is to take the comma delimited file and import the records (rows) into a local Access database...
Should I be looking the Attach method in Access? To attach and dump all the data in one shot?
OR To open the file with StremRead and process each row one at a time?
I am using VS2008, C#, .NET 3.5, Access 2007... once in production there could 20 - 30 thousand records to be appended to the DB then normalised.
I have a Customer database table with a text field named customerPicture with the name of the JPG file.
I have made a Customer Entity class with the LinQ to SQL Designer.
I also have a FormView displaying Customer instance binding with a LinqDataSource.
My problem is:
I want to make some modifications when some control want to bind the customerPicture field.
For example, when my FromView want to show the field customerPicture I want to return not only the JPG file name, I want to modify this string to add the complete file path and perhaps resample the image to a determinate width and height.
I know that is posible to defeine a partial class named Customer to implement certains partial methods, like OnCustomerPictureChanged(), but I dont know how to do this.
If I make, in this Customer partial class, a new method, for example getResamplePicturePath(), how could I invoke it from a FormView?
I am working on Vs2005 and asp.net 2.0. I have a solution with 4 projects (business object, components, data access, webclient)When I change any existing method or property in Business object or data access, it is not reflecting in the application. I have deleted the existing references to the project and added them after the new build. I always get errors like "method not found or No overload method "It seems like old verion of dll is still there in the reference.
I am creating an Asp.net web site which will support dynamic data. When I am creating a dynamic web site from Scratch (from template in VS) all is working fine. But when I am trying to add dynamic entity (.edmx) file and running the application I am getting following error
"The method 'Skip' is only supported for sorted input in LINQ to Entities. The method 'OrderBy' must be called before the method 'Skip'. "
I have a table with columns songID, Album, Artist and title. I have created a method called Updatesong() in data access layer. The SQL qerry in UpdateSong() method is
UPDATE Music SET Title = @Title, Album = @Album, Artist = @Artist
WHERE (Title = @Title)
In a web page I have called the UpdateSong metod on a button click as
Whatever I'm changing in the textbox are getting updated except title column. I dont no whats wrong in that. If I change the SQL querry in tableadapter as
UPDATE Music SET Title = @Title, Album = @Album, Artist = @Artist
WHERE (SongID = @Original_SongID)
I get an error saying "No overload for method 'UpdateSong' takes '10' arguments".
I want to access the user session from a web method. But when I check for the session object, its nothing! How can I access the current user's session from the webmethod?
I am working on my company intranet and trying to integrate it with our existing MS Access applications.
I need to provide the ability to have the client click on a link/button from an aspx page and have it call a function in the MS access application to look up the corresponding record.
I came accross the thread [URL] but that is not really what I want as the ADP application will already be running on the client I just need to pass it a value.
Alternitively if I could start a new instance of the ADP passing it a parameter on open to find the correct record that would be a compromise.
I have one main doubt for long perioad, If we access the DB using SqlDataSource and ObjectDataSource, Can i know which is the fastest accessing the DB.
I have a Solution in which i m using Gridview which stores image inside it. Every time when user uploads images and clicked on button, image get inserted into Gridview.
But every time user hits on button page get postback,so to avoid this i used web method which is get called when user hits on button (html button). But when i m trying to bind gridview in this method.It is not get accessed .
how i access this gridview inside web method? Why Web methods are always static?Is there any other way to do this?
I have some confusion with singleton class, below are my some points:
1.Can singleton class have static method?,if yes then how we call that methods? 2.what is main difference between Static class and Singleton Class?
I have created my singleton class as follows:
[Code]....
In Above class structure I have created two method one is Static and second is non static, When I am trying to access Static Method it gives me compile time error.
I have a shared folder with directories on a remote server that I am trying to access with the method System.IO.Directory.GetDirectories(). This folder is based off of the credentials gotten from windows authentication. My problem is that everything works fun when I debug the Web Application in the built in IIS in VS, but when I set it up in IIS V5.1, it tells me that I have an invalid username and password. I am using Visual Studio 2005 on a Microsoft XP SP2 machine.
I have a static method and need to get the Textbox text in it. But I get "An object reference is required for the non-static field, method, or property 'Members_ETC_Tab5.TextBox1' " when I use TextBox1.text in the static method so I modified my Method as below
[Code]....
but I see that txtBegin is null. How can this be fxed?
I have a table with 4 columns: ID, signId, storeNum, quantity with ID, SignId, and storeNum as composite primary keyif storeNum is -1, that means the quantity is the default quantity. If a store has a store-specific quantity, the storeNum is this store's number.
I need to show all rows that have specific quantity for a store, and all rows that have default quantity and of which the store does not have store-specific quantity
currently I use table-value function with storeNum as parameter to return the list. first, I get all rows that have specific quantity for a store; then, I use cursor to loop through all rows that have default quantity and check each row if the store has a specific quantity. It takes 9 seconds to run the function for a store.
The function is called within a stored procedure, which in turn is called by a function in a class, which in turn is called by a aspx code behind file. It takes about 20 seconds to load the page. 20 seconds to load a page is too long. I am trying to improve the performance.
I wonder if there is an alternative method to the cursor to get the second part of the list.
I am trying to use Rounded Corner buttons in my ASP.NET website using AjaxControlToolkit's RoundedCornerExtender. When I use this on a Buton control, I get an error saying "htmlfile: Unexpected call to method or property access" to which I can Break/continue.
When I run the sites, it gives me an error "Unexpected call to mathod or property access".Here's the screenshot: [URL]
I access querystring values in each content page's pageload method to get Username and Id. Is there a way I access the querysting values from Masterpage's pageload method and each content page goes to Masterpage to get those values without creating any other local variables in content pages? I know this can be done with Session's or view state but I was thinking to reduce redundancy of accessing query string in each content page.