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 Repliesthere 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 to write a file in asp.net using c#. explain with example.
I'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 RepliesI need to take the information that would normally be displayed on the page for Trace and write that to a file. I have the IO part down, but need to know the method to pull the trace information and put it into a string.
View 1 RepliesI tried to save a file to local drive using the code below but got "access denied" error. How to save file to local drive? Dim file As String = "c:myfile" Dim stream As New System.IO.FileStream(file, System.IO.FileMode.Create)
View 6 RepliesUsing vb.net asp.net 1.1 sql server 2005I'm want to show content in a label.No need for binding just for show.I should know my way out of this but I'm having some trouble.I'm only displaying the last item in the label with this code below.
[Code]....
I am using a code where I can upload a file to my other ftp. This code works without problem.
What it does is to create a file named TextFile1.txt
What I want to do is also to write a string to the uploaded file (putString) ?
What is needed to add to this code to do that.
[Code]....
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?
How to write to a file the content of cache when Cache expires.
View 1 Repliesassume that i have Literal Control like this:
Literal1.Text="Hello Word!";
then how i can creat HTML File and Write Literal1.Text To HTML File?
have the following
Response.ContentType =
"application/octet-stream";
Response.AppendHeader("Content-Transfer-Encoding",
[code]...
Error 1 'Response' is an ambiguous reference between 2 references that have a Response.Neither is the one I need,how do i reference the Response that write the file?
I would like to write text file under my applicaiton folder like below;
../myapp/Data/mytextfile
i got directory information from console application now i want write that file from the command prompt output how can i do that
View 3 Replieshow to write connection string in app.config file in vb.net windows application and how to call connection string in forms
View 2 RepliesI 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 RepliesI have a web app that I am developing at work. I need to be able to take input data and append a text file after (x) number of lines.
My web app is using asp.net with c#