Web Forms :: Writing A Log In Xml File Or Insert Query In Database?
Feb 20, 2010
i want to maintain a log of the visitors for a website.. the number of visitors is fix approximate (800), but i have to maintain the record of each visit page wise like page Id, time visited, user id. i am doing it using a database as it was .
i was asked to use a insert query on every page ,(ie each time user visits a page write the log to database), but i dint like the idea.. of making server trips every time the user visits a page and also we have a seperate database server. I had a idea of using XML.. but which is the best way performance wise writing a log in Xml file or insert query in database?
View 4 Replies
Similar Messages:
Jan 8, 2010
i have a problem executing an insert query. whenever i try to insert i have an exeption telling me it cant execute because a record needed in another table; where i select a value form that other table according a listbox, and then insert it into this table. here is a sample of my code:
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|emp2.mdb");
int a = 0;
conn.Open();
string sqlcmd = "select id from nationality where descreption = '" + DropDownList1.Text + "'";
OleDbCommand readNatCmd = new OleDbCommand(sqlcmd, conn);
OleDbDataReader readerNat = readNatCmd.ExecuteReader();
while (readerNat.Read())
{
a = readerNat.GetInt32(0);
}
readerNat.Close();
conn.Close();
string saveEmpcmd = @"insert into employee " + "(nationality) " + "values (@nationality)";
OleDbCommand objCmd = new OleDbCommand(saveEmpcmd, conn);
objCmd.Parameters.AddWithValue("@nationality", a);
conn.Open();
objCmd.ExecuteNonQuery();
conn.Close();
now, the form executes with no errors, but it catches an exeption caused by the ExecuteNonQuery funtion; here it is in details:
System.Data.OleDb.OleDbException: You cannot add or change a record because a related record is required in table 'nationality'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Default2.Button1_Click(Object sender, EventArgs e) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesempDefault2.aspx.cs:line 305
when i remove the relation between the tables, the exeption isnt catched anymore, but the value stored in the employee table is 0 how can i solve this?
View 6 Replies
Sep 4, 2013
I have created a table in database and i have inserted all the data but i cant able to insert the fileupload buttons data in database
SqlCommand cmd=new SqlCommand("insert into reg values('"+txt_name1.Text+"','"+txt_mobile1.Text+"','"+txt_email1.Text+"',
'"+txt_qualification1.Text+"','"+txt_yearofpassing1.Text+"','"+FileUpload2+"')");
View 1 Replies
Dec 23, 2010
Spent ages trying to get this right but am struggling now. I have a list box and textbox, I can happily enter Email addresses into the textbox which are saved into a text file and populated in a list box. I want to be able to select a list item and delete it, along with it's record in my text file. I was going to do it by on the delete list item / button click, it delete's the text file and then writes and a new one with the remaining list items in the list box. Unfortunately it's re-writing the file but either not including the remaining list items. Here's some examples of what I've changed and what populates the text file:
StreamWriter1.WriteLine(Addresses.Items); - System.Web.UI.WebControls.ListItemCollection
StreamWriter1.WriteLine(Addresses.Text); - A blank line?!?
The code is below. The reason I wouldn't allow the user to delete the first list item is because I thought the code was working ok but for some reason putting in a blank line to start with, and if I deleted the line it'd delete all file content. No, I don't know why I thought that either.
[Code]....
where I've gone wrong? I've not actually slept since I woke up at 8am yesterday. It's now 11am... today.
View 5 Replies
Aug 10, 2012
I am having a list of contents in the notepad.
I having the following content.
000012|vasanth|Sofware Engineer|Chennai|
0000215|Arun|ASE|Keral|
The field is static and the column name is ID,name,Designation,City.
I need to read the note pad charecter by charecter and i have to insert the records corresponding in the field which is seperated by "|".
View 1 Replies
Oct 22, 2010
I have TBL_PRODUCT table : ProductID, ProductName, CategoryID, Image. I can insert data to table :
[Code]....
I can upload image file too
[Code]....
But I want two function become one. When I press <Submit>, it's insert data and upload image file.
View 8 Replies
May 11, 2010
i have a "Users today" function that i am trying to work on, i have all the tables set up, and a TimeStamp column, i would like to know how i could get all the users that appeared, but for that day only.
So i used the select statement, but then when i tried to add into query, filtering, i tried using the DateTime.Now, but it only got the users specific to that date, hour, and second.
View 3 Replies
Dec 1, 2010
i want to insert doc/docx file into database and after that i want to retrive that file in lable
View 10 Replies
Oct 27, 2010
Based on this piece of code, I want to do exactly like this demonstration. However, correct me if I'm wrong but if two or more users somehow simultaneously access the web page at the same precise nanosecond in time, then wouldn't we have a race condition? So is this piece of code valid? How would I correct this to make it thread safe?
[Code]....
View 3 Replies
Jan 19, 2011
i have a excel file in which "PuNumber,MachineNo,MachineName,StartDateTime,EndDateTime,WorkOrder,RescheduleInterval,Description ,ACT CODE,ACTIVITY DESCRIPTION" are column. WorkOrder is Primary key. we have multiple value of " ACT CODE, ACTIVITY DESCRIPTION" of one work order. i want to store this data into two table one is shcedule table and another in activity table. shcedule table has this column "PuNumber,MachineNo,MachineName,StartDateTime,EndDateTime,WorkOrder,RescheduleInterval,Description " work order is primary key. and Activity table has three column ACT CODE, ACTIVITY DESCRIPTION and WORKORDER " act code and workorder is primark key.
View 11 Replies
May 7, 2015
I want to insert a .rar file into my database, i tried many times, but i couldn't.
The database is called db_AkiraNetwork
The table is called tbl_driver:
iddriver - int - PK and Auto Increment
tipo - nchar(15)
so - nchar(10)
arquitectura - nchar(3)
ficheiro - varbinary(MAX)
The code i made in ASP is:
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="adddriver.aspx.cs" Inherits="admin_adddriver" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
[code].....
View 1 Replies
Mar 9, 2011
I am using more than one files to read and write to the server. Suppose during writing or reading any of files gets error the already stored files need to be rollback or removed from storing.So that the user agin try to write without error. Simply the all of the files need to be stored into the server without error, of error occurs to any of file none of files need to be read/write
View 2 Replies
May 18, 2010
I am trying to create and write a file on a remote server using the below code:
[Code]....
but i am running into issues and getting errors. Below are some tries i have given. My IIS settings are 'Anonymous Access' checked and also 'Integrated windows authentication' checked.
a. As i understand asp.net site would run using ASPNET account, i tried giving full permission to ASPNET account to the folder on the remote server (where i want to drop the file). But i am getting this error - "Logon failure: unknown user name or bad password"
b. The other thing i tried is giving full permissions to 'Everyone' to the remote server folder. But i get the same error as above. But when in my web.config i enable impersonation by using:
[Code]....
then the error goes away and everything works fine as expected. The file gets dropped to the network share.
why the scenario (a) doesn't work because that should work as if i give ASPNET account full access to the folder, and my website is running under the same account, then it should work.
Also, in the scenario (b), i believe it is using my domain account, as the impersonation is true without specifying any username and password and also the remote server folder has Everyone access to full control.
BUT, as a security breach, i cannot use Everyone account to the remote folder. In that case, how can i make this working.
I was also thinking if i can use the virtual directory as the path to the remote folder, something like
http://domain.com/remotefolder but dont know how can i use this approach. Can someone pls share some sample code and the configuration.
View 1 Replies
Oct 19, 2010
I'm making an application which takes image from user upload it to server and then perform any image processing like to convert to gray or invert etc.
My problem is this when i did the process on image to gray it or invert then how to write this new file on server or is there any other way so that i would be able to show this (new) image to user and make it downloadable?
View 2 Replies
Mar 16, 2011
In my application i want to share one .txt for read and write among no. of users. in Button click i m writing data in that file and in tick event of Timer i m reading that file, In tick event i m reading that file based on file based cachin means if file have been changed then only i m reading that file but when i have put m application i IIS then i m not able to get updated file.
View 2 Replies
Aug 24, 2010
I have the following subroutine in an asp.net application class. The subroutine writes data to a text file upon application login. My question is that if this function was called at the same time by two different users would it cause any kind of error. Is there a need for a try catch?
Public Shared Sub writeToLogFile(ByVal UserName As String)
Dim strLogMessage As String = String.Empty
Dim strLogFile As String = System.Web.HttpContext.Current.Server.MapPath("~/Log.txt") Dim swLog As StreamWriter
strLogMessage = DateTime.Now.ToShortDateString().ToString() " ==> " & UserName
If Not File.Exists(strLogFile) Then
swLog = New StreamWriter(strLogFile)
Else
swLog = File.AppendText(strLogFile)
End If
swLog.WriteLine(strLogMessage)
swLog.WriteLine()
swLog.Close()
End Sub
View 5 Replies
Jun 29, 2010
I keep getting this error when trying to Run or Build my ASP Project. A few details:
I migrated this project from VS 2003 to VS 2008 (C#) It works fine when I successfully compiled it and deployed onto server.I have Plenty of free diskspace available.I have 4 GB Ram and Windows XP So each time I try to build this project, I get the following error.
Error 57
Unexpected error writing metadata to file 'C:InetpubwwwrootProject.IntranetobjTestProject.Intranet.dll' -- 'Not enough storage is available to complete this operation. 'Project.Intranet
View 1 Replies
Oct 19, 2010
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 Replies
Jun 3, 2010
i just cannot work this out... i have a gridview and when a user clicks on a row the checkbox unchecks itself... when the user clicks the row a sqldatasource.update is called from the selectedindexchanged event, problem is when it writes back to the database it writes back every checkbox as unchecked, i want just the row that's selected...
what i can't work out is i've tried putting a where clause in the sqlcommand which is something like where primarykeyID = gridview1.selectedvalue... now it won't write anything back to the database...!!!
... once i take out the where clause, it writes back to every row..!!
View 9 Replies
Mar 29, 2010
i trying to write some text to a file in browser system......for this i'm using stream writer as like this
StreamWriter sw = new StreamWriter("c:/Billing report.doc");
but wat i need is browser should open a dialog box and ask open or save.
View 7 Replies
Oct 21, 2010
I'm fairly new at writing c# with asp.net and thought I'd give writing a custom class for a single file uploader, but Im a bit stuck with it. I get build errors with a few of the items, here's my code:
[Code]....
View 1 Replies
May 23, 2013
i have a folder in soultion explore that in folder there are some xml file but when write data in c# in xml file,error Access to the path 'E:YavariTCMS-v3TCMSTCMSMDFXMLXMLFile1.xml' is denied. every i remove propertice readeonly from xml or folder that contain xml file ,next tim reade onl true
View 1 Replies
Apr 24, 2012
I want to insert form data to two table at one button click event.
like
cmd = new SqlCommand("Insert into regis(fname, lname, uname, passwo, repasswo, email, contact, gender, country, pin) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + D1.Text + "','" + TextBox9.Text + "','" + TextBox8.Text + "')", con);
I want to store email and contact to another table named details(fieldname= contact,email)
How I write query for this. When user click submit button record will saved to both tables.
View 1 Replies
Apr 11, 2012
How can I insert value in two tables by single sql query because if I'm using two sql query it gives problem me on binding data and connection. Like I have 2 table table 1, table 2 ... In table I'm only save id and name and in other table I'm saving id, time1, time2
View 1 Replies
Jul 21, 2010
I have some problem in inserting the wholerow in mt database table at once.....I would like to explain it:i have a function as
public DataSet senddata()
{
........................... [code]...
Now I to insert this data into the database I have made in the same format(schema).I have a function like :
database name is ABC
tablename is XYZ
public void inserttodatabase()
{
DataSet ds= senddata();
View 5 Replies
