As the title implies how can I create a new log file each day in C#? Now the program may not necessarily run all day and night but only get invoked during business hours. So I need to do two things.
How can I create a new log file each day? The log file will be have the name in a format like MMDDYYYY.txt
How can I create it just after midnight in case it is running into all hours of the night?
I have created an excel sheet from datatable using function. I want to read the excel sheet programatically using the below connectionstring. This string works fine for all other excel sheets but not for the one i created using the function. I guess it is because of excel version problem.
OleDbConnection conn= new OleDbConnection("Data Source='" + path +"';provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;";);
which i can create an excel sheet such that it is readable again using above query. I cannot use Microsoft InterOp library as it is not supported by my host. I have even changed different encoding formats. Still it doesnt work
[code]....
I have looked at two of Microsoft's tutorials for MVC. In one tutorial they are creating a .edmx file to handle the Entity Framework in order to execute Linq queries. In another tutorial they made a class called "MusicStoreEntities.cs" here is the code:
using System.Data.Entity;
namespace MvcMusicStore.Models
{
public class MusicStoreEntities : DbContext
{
public DbSet<Album> Albums { get; set; }
public DbSet<Genre> Genres { get; set; }
public DbSet<Artist> Artists { get; set; }
public DbSet<Cart> Carts { get; set; }
public DbSet<Order> Orders { get; set; }
public DbSet<OrderDetail> OrderDetails { get; set; }
}
}
And the tutorial creates an instance of this class and starts doing Linq queries as well. What are the differences between these 2 methods? and how can I make DbSet objects in a .edmx file?
How do you create an XSLT file from an xml file with an existing XSD file
View 1 RepliesI have the following code that creates a new Excel file in my C# code behind. When I attempt to save the file I would like the user to select the location of the save.
In Method #1, I can save the file my using the workbook SaveCopyAs without prompting the user for a location. This saves one file to the C:Temp directory.
Method #2 will save the file in my UsersDocuments folder, then prompt the user to select the location and save a second copy. How can I eliminate the first copy from saving in the UsersDocuments folder?
Excel.Application oXL;
Excel._Workbook oWB;
Excel._Worksheet oSheet;
Excel.Range oRng;....
I am creating a PDF template file and I will want to use that to create other files. I have been looking around and found the following code:
[Code]....
The problem is that pdfreader, pdfstamper, acroreader are underlined and it says it is not declared so I couldn't test it, I wasn't sure what I had to import in order for it to work. In addition, if you have any other way that is easier to use let me know.
I have a text file with one line. It has a value like:
111111~222222~333333~444444~
I want to make a new text file (or change this one which is preferable) to look like this:
111111~
222222~
333333~
444444~
That is, I want 4 rows like above with a carriage return / line feed after each tilde (~).
I've an arraylist having 30000 items in it, what's the best way of creating a text file on the fly from an ASP.NEt page? Currently I'm using the code below but it times out with large data,
Using fileStr As New FileStream(sFileName, FileMode.Create, FileAccess.Write)
Using writer As New StreamWriter(fileStr)
writer.WriteLine("Error Messages") [code].....
how to create a class library file and how to implement in web forms?
View 3 RepliesI want create my output in excel file. But in server i cannot install office, its too costly i am developing it with vishual studio2005 with vb. so anybody can give the solution for this.
View 2 RepliesI'm not sure where this should go (I don't know whether it's a database problem, or a code problem), but I think it's a code problem, so I'm posting here.
I'm working with a database that is storing images (actually, it's a modified version of the AdventureWorks database from Microsoft), and I'm creating a form that will let you upload a file. I've got a business object based on the table that I'm using (Production.ProductPhoto) and I'm using two stored procedures to either get (Production.ProductPhoto_Get) or add (Production.ProductPhoto_Add) an entry from/to the table. The image is being stored as a varbinary field in the database, and a Byte() in my business object.
The problem I'm having is that when I'm adding a new entry and uploading a file, the length of the file uploaded is correct (so I assume everything is going smoothly), and it gets passed along to my ProductPhotoProvider DAL class where I create a DbCommand and add the parameters for my stored procedure. The information is all added to the database successfully, and I'm returned the identity of the new entry as expected -- however, when I try to read this image back, it seems that the length is 1. I've put in break points and stepped through everything, and I don't know what's going on.
I think that I know my ProductPhotoProvider class is at least reading things correctly -- I can display other images from the database (that came with the database, that is) just fine. Mine just all come back with a length of 1.
I'm just hoping someone knows what the hell I'm talking about; I have a lot of programming experience, but this is my first major venture into ASP.NET. I have no idea which parts of my code are relevant, so I'll just post my Add and Lookup functions for now?!
[Code]....
My ProductPhotoProvider class is based off of an abstract class called AbstractDALProvider (which I can also provide if needed). I can provide the rest of my project, if needed, too.
Oh, and for good measure: I was told that when you used to store images in Microsoft Access, there was some sort of problem when retrieving the data and you'd have to strip the first 72 bytes of data from it, or something. I can only assume that this is not a problem here, because I have no problem displaying other photos that were not created by me.
I have a website that requires the user to log in to it. Once the user is logged in they can select a report and criteria, click a button which will then create a CSV file on the server in CSVFiles folder and email to the logged in email address. My problem is I am getting a Access Denied when it trys to open a file for out put on the server.
View 16 RepliesBelow is my class file.
[Code]....
I just created a profile page were users can enter their name current location age , etc. I want users profile info be created together with their profile photo on the top left hand corner. Ive created a database for the profile but how to upload a profile pic using either file upload or any other method.
View 1 RepliesI am having issues with giving id to a text box in the aspx for
heres my code
[code]...
Is there any way of adding in a dynamic id to a textbox created on the aspx file?
In my asp.net page, I am creating excel file using Office.Interop and saving. The application works correctly in my local. When I am deploying in Win 2003 server I am getting below Error. I don't have excel installed in server.
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005
i am getting following error while creating the excel file
System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005(E_ACCESSDENIED)). at QA.CreateExcel.createDoc() in e:~~CreateExcel.cs:line 33
i am using this code.
private Office.Excel.Application app =new Office.Excel.Application();
I have a current file upload that works but I have to make sure that the SupplierImage folder is created. I would like for the upload to create the folder if the folder does not exist. Here is my code
protected void btnUpload2_Click(object sender, EventArgs e)
{
try
{
string path = "~\Assets\ApplicationCompany\SupplierImage\" + ddlVendor2.SelectedValue.ToString() + ".jpg"));
Label1.Text = "Received " + FileUpload2.FileName;
}
else
{
Label1.Text = "You have not selected a valid upload file. GIFs only";
}
}
catch (Exception)
{
throw;
}
}
I'm converting Active X code in DTS to Script Task for SSIS and I'm having trouble creating an XML file from my stored proc. Here's the code:
[Code]....
It throws an error on the dataAdapter fill saying:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '<'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '<'.
Msg 132, Level 15, State 1, Line 5
The label 'sql' has already been declared. Label names must be unique within a query batch or stored procedure.
I have a requirement in which i want to create an aspx form in which I want to define the name of the controls in the xml file and on the basis of the xml file i want to create the aspx form. if in the xml form there are 10 controls then dynamically 10 controls will be created i have following type of xml
[Code]....
i have an asp.net application
c# code
i have adtabase in access and i craete adatset from it
i want to create excell file
I'm developing two applications. One is server application and one more is client application and i'm implementing Localization in both the applications. I have used 7 language resource files in both the application. I need to add the reference of server application in my client application to access some global methods and all. After i'm adding the resource file in the application if i build the application it creates folder for each resource file with language culture code (Spanish -> es-ES, French -> fr-FR) under Bin directory.
Similarly if i add the reference of server application into client application then the resource file dll of server application will be added under corresponding langauge culture folder(es-ES,fr-FR) in the Bin directory. But i don't want to create any resource file dll for the application under Bin directory and aslo i need to put all the resource files inside the application only.
I want to create the Formsview using C# code and initialize the Item Template in the code.
View 3 RepliesI am having problem when i was trying to attach .mdf file while create a new connection of SQL server, create a new connection of SQL database file and open the database in Server Explorer. I am using VS 2010 Ultimate and SQL Express 2008 R2.
Here are the error message.
1. Attach .mdf in SQL database file and open the database in Server Explorer
2. Create a new SQL server and attach .mdf
First i created the TimeSheet.aspx file,then added code files names TimeSheet.aspx.cs file. created a TimeSheet class and code some code in that ,later in the @page directive added the codebehind attibute with value "TimeSheet.aspx.cs" and inherits attribute with value TimeSheet. Now i want to make this code behind file to show up as a sub-branch of TimeSheetp.aspx.Just like a designer file.
Like
TimeSheet.aspx
|----TimeSheet.aspx.cs
how will i do that?
