Search results for query: *

Hello All, I am adding output cache to a few usercontrols within my website that have quite a few database calls. I have added the following into the uc: <%@ OutputCache Duration="100000" VaryByParam="none"%> All works fine with the caching, except when I come to click a button that will...

I am in the process of moving from a single server solution to a load balancing solution. Once of the websites that will be located on the server makes use of asp.net in-process sessions. I am looking for peoples opinion on the best way to go about making the required alterations to how the...

I am trying to create a feed (csv, txt etc) processor that will do the following: 1. Run through each feed line by line 2. Make any required alterations to the values located within the feeds (if required at all) 3. Save each line in turn into a MS SQL database The first two points above work...

I have tried just executing the .sql file, however I receive a OutOfMemoryException.

Hello all, If this is the wrong place to be posting such a question, I am sorry. I have just swapped servers from a single server solution which worked with MSSQL Express edition to a Master-slave solution which uses MSSQL Workgroup. I need to update certain database tables on a daily basis...

I am using ASP.net to connect to a MySQL database. I think this is a MySQL problem rarther that ASP.net. Please let me know if I have posted in the wrong forum. This is the first time I have encountered this error: Error: Exception information: Exception type: MySqlException...

Ok thats great. Thanks for all your help and advice. I will have a test with Rindo.ETL and using my c# code to see which will work the best. Once I have all the required alterations into the staging table(s), what is the quickest way to actually copy over just the altered rows and new rows...

Thank you for your quick replies. I am interested in both of the methods that you have suggested. I am currently only using Mirosoft Server Management Studio Express, are DTS and SSIS still available in this version? MDXer: Sounds like quite an interesting solution. Sorry if this seems a...

I have a MS SQL database table with around 500,000 rows. Each day, this table is updated using a csv file. Currently I have been looping round each row within the CSV file to check to see if the row that it matches within the database has changed. If this has changed I will make a UPDATE sql...

Hi All, I have the following code that sends a soap request to a web service and receives a soap response back, void HttpSOAPRequest(String xmlfile, string proxy) { XmlDocument doc = new XmlDocument(); doc.Load(Server.MapPath(xmlfile)); HttpWebRequest req =...

Do you have any examples or websites that I can look at? Im still a little unclear on how exactly to go about this.

Hello all, Im trying to get an update panel to update while I am executin a large process. If I can output to the screen, I will know exactly where the process is up to. For example: //.aspx <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>...

Hi all, I have built a CSV parser that will convert each line of a csv cod into a string[]. if (File.Exists(path)) { using (FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read)) { using (StreamReader sr = new StreamReader(fs))...

Hello all, I’m looking to be able to create a script of a .MDF database (data + schema) automatically using c# code. What I want to be able to do is create a .sql file of all the data in a .mdf database (exactly what you can do using the “Publish to provider” tool in Visual Studio. Any...

Thanks for your quick reply. With regards to the ddl, I want its value to remain the same where ever the user is within the site. The user can set the ddl on any page of the website, but when they navigate to another page within the website I want the ddl value to stay the same. I am...

I am looking to save the value of a dropdown box which is located on a masterpage when I flip between other pages that use the masterpage. For example, all my masterpage contains is a dropdown box with a few items: <asp:DropDownList ID="DropDownList1" runat="server">...