I 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 RepliesIn trying to track down a performance issue that is only occurring in our production environment, we have enabled tracing within the app so see method calls and page load times.
This is working well and there is lots of information that helps to track down issues. However, the only way of viewing this information is to browse to the Trace.axd and then view each request individually.
It is also only possible to track the first X requests in this way and X has a maximum limit of 10,000.
Is there a way to direct this trace information to a file or database? I believe this can be done using System.Diagnostics, however, I am not having much luck.
I have enabled tracing using
<trace enabled="true" writeToDiagnosticsTrace="true" />
I have tried using the XmlWriterTraceListener using
<system.diagnostics>
<trace autoflush="true">
<listeners>
<add
name="XmlWriterTraceListener"
type="System.Diagnostics.XmlWriterTraceListener"
initializeData="c: race.xml"
/>
</listeners>
</trace>
</system.diagnostics>
This results in an xml file containing the timestamps and data for the trace items such as "Begin Load", "End Load", etc.
However, it only seems to log a single request and does not log all requests. In addition, whilst the load times are useful, ideally I would like to have available all of the information that can be seen in the Trace.axd, such as request data, post data, session data, etc.
Is this possible at all without any major code changes? Ideally I would like to enable this using only web.config changes.
Alternatively, I have looked into other applications such as RedGate and Equatec's profiling tools, however, I would like to exhaust the non invasive tracing options first.
The application is written in ASP.Net 3.5 and C#.
I am trying to redirect my trace output to a text file.
For this I tried to add a textwritertracelistener object to Trace.Listeners.Add but I can't see Listeners Class in Trace.ie When I put Trace. the Listeners class is not popup. Also I am unable to add System.Diagnostics.TraceListener namespace to the page.
My code is as given below ..
[Code]....
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 .
I'm using .net web config to create trace listener for debug and trace output in a .NET web app.
The problem is that if left, the log file, which always uses the same name can get massive and has actually caused me some application issues today.
I can't find a method on the net of setting a log file size limit, or a method of using a dynamic name, such as one that uses a date string as part of the name. Does anyone know if this is possible?
So far I am using:
<system.diagnostics>
<trace autoflush="true" indentsize="4">
<listeners>
<add name="CollectionLister" type="System.Diagnostics.TextWriterTraceListener" initializeData="Collections.log" />
</listeners>
</trace>
</system.diagnostics>
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'm currently exporting a database table with huge data (100000+ records) into an xml file using XmlTextWriter class and I'm writing directly to a file on the physical drive.
_XmlTextWriterObject = new XmlTextWriter(_xmlFilePath, null);
While my code runs ok, my question is that is it the best approach? Or should I write the whole xml in memory stream first and then write the xml document in physical file from memory stream? And what are the effects on memory/ performance in both cases?
EDIT
I will indeed be using XmlTextWriter but I meant to say whether to pass a physical file path string to the XmlTextWriter constructor (or, as John suggested, to the XmlTextWriter.Create() method) or use stream based api. My current code looks like the following:
[Code]....
URL....the code works good when my webform is not inside content place holder of Master page.but, when i use same code in the webform which lies inside content place holder of a Master page, downloading of excel doesnot happen.
View 1 RepliesHow would I display the following code into a GridView. First, I need the application to write the xml file somewhere on my harddrive and then I need it to read it to populate a gridview.
protected void Page_Load(object sender, EventArgs e)
{
var xmlRequest =
new XElement("GetTicketAction",
new XAttribute(XNamespace.Xmlns + "xsi",[URL] "
new XAttribute(XNamespace.Xmlns + "xsd", "[URL]"),
new XElement("CompanyName", Setup.Company),
new XElement("IntegrationLoginId", Setup.Username ),
new XElement("IntegrationPassword", Setup.Password),
new XElement("SrServiceRecid", Setup.SrServiceRecid))
.ToString();
var proxy = new MyWebService.integration_io();
var xmlResponse = proxy.ProcessClientAction(xmlRequest);
var parsedXmlResponse = XElement.Parse(xmlResponse);......................
I have a SQL trace I run on a database which I would like to be able to monitor more easily. How can I access a trace in real time with an ASP.NET page?
View 1 RepliesSuppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
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();
I 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?