i"m using write.xml to write xml files from ms sql server table. the problem is that the information is not trimed... so i get lines like-
<data>1 </data>
are there is a way to trim the data even if i use write.xml mathod?
I'm trying to add functionality to a simple web service that will allow me to log information to an XML file on the hard drive where the application is located. When I employ the functionality in a Console version of the application, the data gets logged to:binx86Debug MySolution.MyProjectMessageLogTestMessagess.xml. However, when I try to write read from or write to the XML file in the ASP.NET application, I get a System.UnauthorizedAccessException with the message: Accees to the path 'MessageLog' is denied.I would like the log file to appear in the in folder of the application directory, so what settings in IIS or on the server itself would I need to change to allow my application to read from and write to that folder?
View 3 RepliesI have to write data from excel to data table on my server and ms office is not installed on the server. I am able to save the excel file but I don't how I can write it to data table from excel when ms office is not installed.
View 3 Replieshow can we write a code for displaying a files and folders of server directory using Grid View in asp.net?
View 3 RepliesI have created an ASP.Net application using .Net framework 4.0. I need to save an xml file on any location on same server (if file not already exists) and want to access then after always. But I dont want to set write permission to any folder. Is it possible to write a file to any location for Network service account without specifying write permission? Does Network service account have default write permission to any location?
View 2 Replieswhich component in MVC pattern is responsible for writing files to disk? Is this a controller or model?
View 2 Replieshow to write two files using Response.WriteFile?
I tried the following
Response.AddHeader("Content-Disposition", "attachment; filename=" + textFile);
Response.Flush();
Response.WriteFile(FilePath);
Response.End();
streamWriter2.WriteLine(CodeFileText);
streamWriter2.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=" + textFile2);
Response.Flush();
Response.WriteFile(FilePath2);
Response.End();
But it downloads the first and stops.
It doesnot go for second one.
I'm trying to write an application that combines 2 media files (MP3, MP4 or FLV) of the same types in to one
View 2 RepliesA table can be used to automatically sense Model. But when I get more than one table after the SQL query is a DataTable. When this DataTable to return View (DataTable) later. In the aspx file, can automatically perceive it as the Model, as the self-paragraphs?
[Code]....
Is there a was to automatically write a tables contents to a .txt file? For example, a table 'deals' has the columns [id], [col1] and [col2]. Another table called 'customs' has the columns [id], [info] and [details]. both [ids] relate to one another. In 'deals', the col1 and col2 data will change, but when the [col1] = [col2] id like the corresponding [id]'s on the other table to be identified and [info] and [details] data be written to a .txt file.
View 2 RepliesI want to use response.write to generate a table. but I have a question, the result of table must display on the top of web page. How can I control the location of table? e.g. at the middle or end of web page or starting from number of line.
View 5 RepliesI am going to create a table with SQL Server, this table only has two columns: MessageName and Message.
One example is like
[Code]....
[Code]....
But I don't want to manually type in the message because of trmendous text; what I want is to read the message from an existing web page which like
[URL]
I need to pass a table type parameter to a user-defined table valued function in SQL Server 2005.How would I do this?
My function name is udf_t_GetSales ( @financialYearMonthsData as table)
The table @financialYearMonthsData has 3 columns ( MonthId int, DisplayText nvarchar(500), CalendarYear int)
Being new to Linq and Entity Framework, I find myself struggling to write queries that are relatively simple in SQL. My latest challenge is how to write a query that pulls records from a master table and includes a column for aggregating data from related detail records. Let's start with this example:
List<Customer> list = (from x in Customer select x.Customer_ID, x.CustomerName).ToList();
Now I'd like to modify this so that I include a column indicating how many orders each customer has, where there is a one-to-many relationship between the Customer and Order entities. I suspect the solution might result in a List of an anonymous type rather than the List of Customer like my example, but that would be
I have some information I am pulling from my db into a table. Can anyone direct me to a tutorial that shows how to dynamically create a file and allow a user to download that file with the table contents. All this must be dynamic.
View 2 RepliesWe have two database called First(Application) and Last(Workflow) I am submitting a Personal injury report which contains Date of Accident,time,eventID,eventDate,etc.
After submitted the button, these values in insert one of the database(First). At the same time few above column values in insert on another database(Last). Now i want to write a function to insert these values (selected values from both the tables) into new table in First Database.
Because we are adding new tables for audit purpose. User are saying their report are missing. that y we are inserting new table.
i have 2 databases in my project with many tables of information. my need is to pull certain pieces of data from different tables and put them into one table called "results" at a certain time called "endDate" in the database. what is the best way to do this automatically?
View 6 RepliesI manage a large asp.net site which has previously been converted from static html site to asp.net. For several reasons (mainly SEO) we decided not to rename all the files to .aspx back when we originally converted the site. This was very easy to do by simply adding the buildProvider and httpHandler to the web.config.
<buildProviders>
<add extension=".html" type="System.Web.Compilation.PageBuildProvider"/>
</buildProviders>
<httpHandlers>
<add path="*.html" verb="*" type="System.Web.UI.PageHandlerFactory"/>
</httpHandlers>
Now I am upgrading the site to use Asp.net WebPages with Razor cshtml files. I can rename all the files if necessary, and use url rewriting to make the urls stay the same, however it would be much easier if I could just configure the web.config to tell it to parse .html files as if they were .cshtml. I have searched around quite a bit, and could not find anything equivalent to the PageHandlerFactory for razor pages. It appears as though it is just an internal mechanism in the .net 4.0 ISAPI handler.
The site is currently running on Windows 2003 server and IIS 6. We will be upgrading to 2008/IIS 7.5 in the near future, but I'd prefer not to wait for that. Is there any way to get the .html files to be parsed by razor as if they were .cshtml files?
I am not sure this is the forums but I dont know where to write this and this is an EMERGENCY ::I had windows 2003 server. on C: and I have installed windows 2008 server.I had SQL server installed and all of the database files stored inside c:program filessql server....PROBLEM is that after I installed 2008 server I can see 2 folders of program files one for x86 and the other for 64 bits.
View 2 RepliesI have a form with 10 file inputs. They can contain 10 random files with random sizes. If I send these files to ASP.NET server with this code:
var count = HttpContext.Current.Request.Files.Count;
var TotalSize = 0;
for (int i = 0; i < count; i++ )
{
HttpPostedFile postedFile = HttpContext.Current.Request.Files.Get(i);
TotalSize += postedFile.ContentLength;
}
And as you can see I didn't save the files on the server, will this code just calculate the summary of files without need to receive the whole file from the client (And therefore it would be very fast)?
I am trying to open different types of files that I have uploaded on my sql server database. I would like to display all the list of files in Gridview. When user click the link it should open download dialog box and should be able to open its particular applications such as word, excel, browsers etc.
View 3 Repliesmy main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replieshow can I create stored procedure and write my select statement in it, I know how to create dataset then put type stored procedure and assign it to the sp ... what I want is writing my sp... how can I make it ?
check the following code, this is what I want to write put I don't know where or how !
CREATE STORED PROCEDURE SP_CATEGORY
@CATEGORY VARCHAR(30)
AS
BEGIN
SELECT LATIN_NAME, ENGLISH_NAME, ARABIC_NAME, CATEGORY
FROM FLORA, CATEGORY_LIST
WHERE FLORA.CATEGORY=CATEGORY_LIST.CATEGORY_NAME AND CATEGORY_LIST.CATEGORY_NAME IN (SELECT * FROM SPLITLIST(@CATEGORY, ','))
END
where can I write this code ?!
Not a fan of creation and modifcation data in each table's row but I don't make the rules here. Something about normal comes to mind. Simple method to insert or update data in a table ia EF. Datatype = smalldatetime and no it is not changing across schema. Don't care about milli seconds. In oOrg = null I always fail because of a datatype mismatch.Not sure but didn't M$ make both of these products, and shouldn't the EF know about a smalldatetime when it reads the schema? So what is the fix outside of changing many tables to be datetime which is frowned upon at this piont.
public static String updateOrgs(Orgs org, Guid user)
{
using (ELogs2Entities EL = new ELogs2Entities())
[code]...
I want to write the query for finding second highest salary in my employee table how to find it??
View 3 Replies