I'm using Visual Web Developer 2008 Express with VB for coding and I'm really just a starter.
I want to use AJAX HTML editor to create an HTML page and then store this at the server.
I've got the HTML Editor set up but how do I "Save" the content as a file in a specific folder at the server?
I would like to know your libraries recommendations to read and write Excel applications on ASP .NET website. I have tried GemBox and NPOI, because they don't required Excel to be installed on the server, but they have some limitations on handling Excel files that are marked to read only.
View 6 RepliesIt is possible to upload a file to an account using the below code by specify an existing filepath.
What I wonder is how it instead would be possible to just write a string to this file instead. Like I want to open the file and write the string "Hello" to this file, file1.txt.
How can that be achieved. I beleive I would have to open up a stream of some kind but are not exactly sure how to set that up:
[Code]....
in the application, I need write a jpg file to local folder on server, then show it in browser.
so, the code likes show this file:
HttpContext.Current.Request.Url.Host + "/View/ViewJpg.aspx"
In the ViewJpg.aspx, it will process the jpg. /view is in root folder.
it works fine when the code is on a server, however, I have problem when I debug in on local machine.
because the code is actually http://localhost/mYproject but HttpContext.Current.Request.Url.Host only returns http://localhost.
I've recently developed a web user control that lists a series of reports. When the user clicks on the report it serves back a CSV file download in the response stream using the following code:
Response.Clear();
Response.ContentType = "text/CSV";
Response.CacheControl = "no-cache"; [code].....
The code initially worked fine in all browsers. Then the client put a requirement to use SSL for the site. As part of this I introduced a global handler to update the protocol from HTTP to HTTPS for all requests as follows:
protected void Application_BeginRequest(Object sender, EventArgs e)
{
string requestURL = Request.Url.ToString().ToLower();[code]....
However, since securing the site using SSL the CSV file downloads no longer work for IE although they do continue to work for Firefox / Chrome / Safari.
Is there something I am missing in the headers that is unique to IE in order for the file response to work correctly?
The message I receive from IE is:
"Internet Explorer cannot download
Reports.aspx from .... in ......
Internet Explorer was unable to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later."
UPDATE:
Here is some example fiddler output coming back from the page request which looks like it's serving correctly. Why doesn't IE understand that it's just been served a file?
HTTP/1.1 200 OK
Date: Tue, 09 Nov 2010 14:23:50 GMT
Server: Microsoft-IIS/6.0[code].....
I have an ASP.Net (2.0) application on an intranet that impersonates the users Windows login.
It has <identity impersonate="true" /> in the web.config file.
In a couple of places it needs to create a file in the temp folder of the server (a text file in one instance and a Word doc in another instance) before sending the resulting file to the user, after which it is deleted.
It runs into a permission problem, which I assume is because the user that is being impersonated does not have permission to write to the server's hard drive.
How do I overcome this?
I assume it be something along the lines of temporarily running under a different account for the create/read/write/delete temp file parts of code.
how to do this and which account would be the best (easiest) to use. It will be a Windows 2003 server.
how can i write a sql to execute the file at specific time sql server database.
View 3 RepliesI want to read write excel file in my application without installing the office on my server. Means my server don't have any excel (MS office) installation. Is it necessory to install the office on server to excute the program of read or write the excel file.
View 5 RepliesMost of my experience has been developing 'webpages'. Presently, I am developing a mozilla extension which does not support web services, others have suggested to use XMLHttpReqest instead. I have the client side code for it but have no idea on how to write the server side for it.
View 2 RepliesWith the ajax file uploader, would it be possible to check the size of the image before uploading?Currently, it uploads the file to the server and then lets me know that it's bigger than the limit size.
there are an access file . >> "test_file.mdb"
there are a table in mdb file .>> "test_table1"
and there are 2 columns in "test_table1" >> "name" and "age"
and i have 2 textbox in my web form . >> "textbox_name" and "textbox_age"
and i have a button for save textbox_name.text and textbox_age.text in mdb file .
i need adox vb code for save textboxs data in mdb file .
how 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 ?!
I have to write a application which connects to remote server(windows 2003 server, open SQL Management studio in that server and enter a specific SQL Server address and access a stored procedure, change some values and execute the stored procedure.)
I have to write this application using C#.Net , Could anybody point me in right direction, Where do I start?
I am using Sql Server 2005,My table structure is below.
Create Table ComentTable(id int,coments varchar(4000))
insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')
insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')
how to write storeprocedure update coments column replace %27 to '
how to write a file in asp.net using c#. explain with example.
have an eCommerce web site that is hosted on a Windows machine with ASP.NET. It uses an MSACCESS database (an .mdb file) which contains all the inventory, the customers, the orders, etc. I have the source code for most of the web site (a bunchof .ASP and .ASPX files) and I understand the database tables rather well. THere's a web.config file on the web site that has this line in it
View 5 RepliesI'm trying to write a new web.config file using VB in ASP.net. I am trying to set access permissions, but it won't let me use the question mark to denote: <deny users="?" /> in the authorization tag. Is there an alternative to this or a different encoding I should be using for this character?
My specific error: The '?' character cannot be used here.
'Create file, overwrite if exists
'enc is encoding object required by constructor
'It is null, so default encoding is used
Dim objXMLTW As New XmlTextWriter((MapPath(".") & "asic" & fold & "" & "web.config"), Nothing)
objXMLTW.WriteStartDocument()
'Top level (Parent element)
objXMLTW.WriteStartElement("configuration")
'Child elements, from request form
objXMLTW.WriteStartElement("system.web")
objXMLTW.WriteStartElement("auhorization")
objXMLTW.WriteString("deny users="?"")
objXMLTW.WriteEndElement()
objXMLTW.WriteEndElement()
objXMLTW.WriteEndElement() 'End top level element
objXMLTW.WriteEndDocument() 'End Document
objXMLTW.Flush() 'Write to file
objXMLTW.Close()
I have a web form, that needs to save the data that the user enters, into a file and on the client pc, that will also be able to read from the saved file and repopulate the fields at a later time. No files will be saved to the server side, so I expect streaming needs to be involved at writing time.
I decided XML would be an easy way to do this, but I'm stymied on methodology. XML documents? XML Writers?
I'm stumped on the right search terms to even get what I want.
[code]....
How to write xml schema for xml file
writing in .dbf , as following is my code with this error :
[ ERROR [07002] [Microsoft][ODBC dBase Driver] Too few parameters. Expected 3 ]
SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=test;Integrated Security=True");
SqlDataAdapter da = new SqlDataAdapter("select * from test", cn);
DataSet ds = new DataSet();
da.Fill(ds, "test");
string odbccon = "Dsn=TEST.DBF;dbq=E:\FOX;defaultdir=E:\FOX;driverid=533;fil=dBase 5.0;maxbuffersize=2048;pagetimeout=5";
OdbcConnection connection = new OdbcConnection(odbccon);
connection.Open();
OdbcCommand createCommand = connection.CreateCommand();
createCommand.CommandText = "CREATE TABLE test (ID int, name varchar(50),last_name varchar(50))";
createCommand.ExecuteNonQuery();
OdbcCommand insertCommand = connection.CreateCommand();
insertCommand.CommandText = "INSERT INTO test (ID,name,last_name) VALUES (@pID,@pname,@plast_name)";
foreach (DataRow dr in ds.Tables["test"].Rows)
{
int id = int.Parse(dr["ID"].ToString());
string name = dr["name"].ToString();
string last_name = dr["last_name"].ToString();
insertCommand.Parameters.Add(new OdbcParameter("@pID", id));
insertCommand.Parameters.Add(new OdbcParameter("@pname",name));
insertCommand.Parameters.Add(new OdbcParameter("@plast_name",last_name));
insertCommand.ExecuteNonQuery();
}
In C# ASP.net, could someone show me how I can write entries from an Array/List to a CSV file on the server and then open the file? I think the second part would be something like - Response.Redirect("http://myserver.com/file.csv"), however not sure on how to write the file on the server.
Also if this page is accessed by many users, is it better to generate a new CSV file every time or overwrite the same file? Would there be any read/write/lock issues if both users try accessing the same CSV file etc.?
Update:
This is probably a silly question and I have searched on Google but I'm not able to find a definitive answer - how do you write a CSV file to the webserver and export it in C# ASP.net? I know how to generate it but I would like to save it to www.mysite.com/my.csv and then export it.
When i just run my web appliction then i get the erro:Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filespersonalwebsite24bf5e63923e6c3e6App_Code.x8uy-li9.dll' -- 'Access is denied. ' I also get this when i run web application fron starter kit........
View 2 RepliesHow do i write something in the innertext of my xml filei am able to read the particualar tag from the file like this:
protected void Page_Load(object sender, EventArgs e)
{// this is to read from xml.
if (!Page.IsPostBack)
[code]...
I want to read and write a txt file but
The process cannot access the file 'D:BelgelerimVisual Studio 2005WebSitesmacrotechCounter.txt' because it is being used by another process.
what is wrong with this
StreamWriter FileWriter;
StreamReader FileReader;
string Countstr;
string str1;
int Len1,i;
FileReader = File.OpenText(Server.MapPath(Page.ResolveUrl("~/Counter.txt")));
FileReader = File.OpenText(Server.MapPath("~/Counter.txt"));
Countstr = FileReader.ReadLine();
FileReader.Close();
FileReader.Dispose();
i = Convert.ToInt32(Countstr) + 1;
Countstr = Convert.ToString(i);
FileWriter = File.CreateText(Server.MapPath("~/Counter.txt"));
FileWriter.WriteLine(Countstr);
FileWriter.Close();
how to write data in and excel sheet. when i retrive the data by foreach loop i want to dynamicaly create a excel sheet and save data inside the sheet.
View 3 Replies