Is there something i can use to track how long my mysql queries take? perhaps log them if they take > a certain amount of time? or track all queries but only hold the longest query time? using this with C# .NET with ASP.NET. I'd like to use this to occasionally check if my queries are getting slow.
View 1 RepliesI refer this URl.... of yours to save excel file in to mysql using vb.net as front end, i could save file of maximum 500 rows of excel sheet, but i have excel having 2 lakhs rows for this iam getting error as data too long for column 1 and i could not find varinary(max) in mysql/
View 1 Repliesi was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 RepliesI've developed a web application to accept video file uploads and then pass them to a backend service on an external server. The application runs without error on the visual studio debugging webserver, but once on a production iis 6 or 7 server, yields a timeout error at about a consistent amount of time into handling a large upload. Specifically, it errors in the middle of transferring the video file to the external server, once the application has successfully received it from the client. I'm aware of several timeouts to be configured related to the problem, and have done so. The application's web config has been tested with one or both of the following settings
<system.web>
<httpRuntime executionTimeout="9999999" maxRequestLength="2048000" />
</system.web>
and
<configuration>
<location path="default.aspx"> (the page at issue that's timing out)
<system.web>
<httpRuntime executionTimeout="9999999" maxRequestLength="2048000" />
</system.web>
</location>
</configuration>
And within the initialization of the webrequest made to the external server to send the video received from the client browser:
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
httpWebRequest.ContentType = "multipart/form-data; boundary=" + boundary;
httpWebRequest.Method = "POST";
httpWebRequest.Timeout = System.Threading.Timeout.Infinite;
So with the execution time limits on both the webform as a whole and the connection made to the external server, I'm at a loss for what timeout is left unconfigured, or how to determine such, when I continue to get the following error: Unexpected error executing Brightcove Upload:...........................
Why does a very simple script which inserts 26,000 records into a mysql database (myisam, no transactions) take 13 seconds in the php implementation, and then 35-50 seconds using mono+mysql connector? I thought asp.net was faster than php? Could the problem be the mono mysql connector is "platform independent", so the performance just stinks? or does asp.net suffer more overhead than php when it comes to executing each query? Aren't there any native linux binaries for mysql connector for mono that may be faster?
View 1 RepliesI have used ASD.NET code using SQL Database for Transaction operation successfully. By changing the Database Code to interface with MYSQL an Error occurs. If I remove the Transaction Code from within the the application, it works OK by displaying the MYSQL data (Read Only) in the layout of the application. I am using Mysql Essential-4.1.22-win32 and MYSQL Connector ODBC-3.51.2. My objective is to EDIT the MYSQL Data.
View 8 RepliesMy code is to update a record if it already exists in database else insert as a new record. My code is as follows:
protected void Button3_Click(object sender, EventArgs e)
{
OdbcConnection MyConnection = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testcase;User=root;Password=root;Option=3;");
MyConnection.Open();
String MyString = "select fil_no,orderdate from temp_save where fil_no=? and orderdate=?";
OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
MyCmd.Parameters.AddWithValue("", HiddenField4.Value);
MyCmd.Parameters.AddWithValue("", TextBox3.Text);
using (OdbcDataReader MyReader4 = MyCmd.ExecuteReader())
{
//**
if (MyReader4.Read())
{
String MyString1 = "UPDATE temp_save SET order=? where fil_no=? AND orderdate=?";
OdbcCommand MyCmd1 = new OdbcCommand(MyString1, MyConnection);
MyCmd1.Parameters.AddWithValue("", Editor1.Content.ToString());
MyCmd1.Parameters.AddWithValue("", HiddenField1.Value);
MyCmd1.Parameters.AddWithValue("", TextBox3.Text);
MyCmd1.ExecuteNonQuery();
}
else
{
// set the SQL string
String strSQL = "INSERT INTO temp_save (fil_no,order,orderdate) " +
"VALUES (?,?,?)";
// Create the Command and set its properties
OdbcCommand objCmd = new OdbcCommand(strSQL, MyConnection);
objCmd.Parameters.AddWithValue("", HiddenField4.Value);
objCmd.Parameters.AddWithValue("", Editor1.Content.ToString());
objCmd.Parameters.AddWithValue("", TextBox3.Text);
// execute the command
objCmd.ExecuteNonQuery();
}
}
}
I am getting the error as: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,orderdate) VALUES ('04050040272009',' &' at line 1
The datatype for fields in table temp_save are:
fil_no-->INT(15)( to store a 15 digit number)
order-->LONGTEXT(to store contents from HTMLEditor(ajax control))
orderdate-->DATE(to store date)
I am trying to insert html pages to MySQL with my Asp.NET project but i am getting error; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'de Osman patlaması', '', '<div style="text-align: center"> <img src="/i' at line 1
How can i fix that problem my server side code is;
MySqlConnection myCon = new MySqlConnection();
myCon.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.Text;
string query = @"INSERT INTO `test`.`posts` (`id`, `author`, `title`, `description`, `content`, `ispublished`, `iscommentsenabled`, `pubDate`, `lastModified`, `raters`, `rating`, `slug`, `tags`, `categories`) VALUES (NULL, '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}')";
query = String.Format(query, p.author, p.title, p.description, p.content, p.ispublished, p.iscommentsenabled, p.pubDate, p.lastModified, p.raters, p.rating, p.slug, p.tags, p.categories);
cmd.CommandText = query;
cmd.Connection = myCon;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();..............
In my upcoming project, I need to track GPS device attached to vehicles. Is there any way this is possible through PHP or ASP.Net
View 2 RepliesHow to track downloads with ASP.NET?
I want to find how many users completed the file download?
Also How can make restrict user from specific IP?
for example if a user download [URL] the track will work automatically.
I need on my website to track for a particular page who has visited the page and actually click on it.
Is there a way to know that information as much as complete as possible ?
is it possible to track the URL in browsre. i want to change my DB fild if the part of the URL is samen as i want .
View 4 RepliesI want to monitor the activities of all the folders present at "C:Inetpubftprootsan".User can work on any type of files and not only text files.Since we have given 1GB space (lets say) to each user, so user can do anything to utilize this space.
Now I want to monitor the activites that the user will do in his folder like creating new file, deleting an existing file or editing a file.I want to monitor user's activities because i have to keep track of the space given to the user so tht i can restrict the user to use 1GB space only and not more than that.
is there any class that i can use other than FileSystemWatcher as it works only in console applications and not in webapplications?
I'm trying to write an application that allows a visitor to use our service for 7 days. After 7 days, they will no longer be able to use it unless they sign up. What's the best way and the most accurate way to track it without collecting their credit card information? I'm trying to use the following code to track visiotr's ip. But I'm not sure if people are able to change their ip address or using a proxy server that will go through.
HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]
How to track the exception in application. means let say there is enterprise project, If we deliver the project to end user (forget for a while any tester is there/ or in my side who can track this exception). and while navigating or doing any operation , a custom error page occurs, which is define by developer from his web.config file.
then how user will let know to developer that he get something exception while doing particular operation ? How developer can tack this exception without having any kind of debugging. Let say user not allow to deploy again. developer want to track this exception on deployed application. What he must to do. I know we can put try..Catch but need to now particulars..
I've added this in my web.config:
<customErrors mode="RemoteOnly" defaultRedirect="~/Site/Statics/Eroare.aspx">
<error statusCode="404" redirect="~/Site/Index.aspx" />
</customErrors>
Well, in Page_Load method on Eroare.aspx page i try to print to my internal logs the error which caused this redirect but Server.GetLastError() is null...
Do you know why? Or any other solution to get the exception?
I want to put an unique image (1x1) on an e-mail marketing (not spam) of my client. Just like [URL], I'd like to use it to know how many people have actually read the e-mail. I guess I'll have to check how many times this unique image has been accessed, but I can't figure out how to do it.
Is there a way to check how many times an image file was accessed using ASP.NET/C#?
In sql2005 or Sql2008, is there any possibility to find since last month, what r the manipution have done in sql (i.e insert ,update,delete, creation in database makuse of any log file). That i need to track this manually.
View 8 RepliesI am populating a table based on a javascript function.I want to limit the data entered to 2, afterwhich I hide the table.Is there a way to track how many hits the javascript code gets hit?
[code]...
I am trying to track the client IP, with this code
vb.net Code : Dim Ip_TcpIp As StringIp_TcpIp = Request.UserHostAddress()
But it is resulting me
::1
I have built my intranet using MS Visual Web Developer Express 2008. There are several secured areas and my manager asked me to find out if tracking the traffic is possible. Things that I would need to track include:
Which unique user ID's logged in and when? How many times did the same user login? Last login What info was accessed? What page(s) had the most hits? Would I need a database for tracking purposes? Would this info be available with a "dashboard" interface?
I am redirecting from A.aspx to C.aspx and B.aspx to C.aspx.In C.aspx i have a button "Back Page". I am implementing as below.If there is a better way pls let me know.
In A.aspx and B.aspx before redirecting to C.aspx,saving the LastPageURL in session
Dim lastPage as string = Request.UrlReferrer.AbsolutePath
Dim sArray() as string = lastPage.split("/")
lastPage = sArray(Array.Length-1)
Session("LastURL") = lastpage
On click of Button "Back Page" in C.aspx
Response.Redirect(Session("LastURL"),True)
I am recording time taken by a page to be displayed to user, for which I am recording execution end time in page_PreRender. But if the page contains huge amount of data, then it is taking few more seconds after PreRender event. I also tried with Page_Unload, still the same.
View 5 RepliesI'm curious, anyone know the mechanism a checkbox control uses to remember that its checked or not checked after a postback?If I add them manually to a page via html as in <input type="checkbox"/> I have to use javascript and hiddenfields to keep things checked after a postback and I would have to have an onclick="dosomething()" inside the tags.Viewing the html source code for a page with a .NET checkbox control, there is nothing like that there.
I was writing a custom control and rendered my own checkboxes when I came across this problem. After the postback, the control would reload the checkboxes from viewstate and forget the user had clicked anything. As I couldn't use hiddenfields to track the changes (they got reset from viewstate too), I ended up using .NET checkboxes as childcontrols instead but this experience got me thinking.
I want to save each request to the website. In general I want to include the following information: User IP, The web site url, user-if-exist, date-time. Response time, response success-failed status. Is it reasonable to collect the 1 and 2 in the same action? (like same HttpModule)? Do you know about any existing structure that I can follow that track every request/response-status to the website? The data need to be logged to sql server.
View 3 Replies