I have a SQL Server database which contains stock market quotes and other related data. This database needs to be updated at regular interval, say 1 minute. My question is: How do I get stock quotes every 1 minute and update it to database?
View 2 RepliesI want to update a Panel after every 2 minute in asp.net mvc. For that i tried to impletment Update panel and Timer as we do in simple Asp.net . But page not refreshing data in update panel in asp.net mvc. i dont know whether it is problem of timer or update panel.i added the events on aspx page using script tag. So is there any way to update the update panel only after sometime in asp.net mvc..
View 2 RepliesI have a scoreboard kind of application, In which the value of labels in the update panel has to be refreshed every minute.
View 3 RepliesI want to add Mins column in Stored procedure .
ex - Mins(column)
3:10
4:20
5:10
2:30
Output should be 15:10
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
i have a problem with my asp.net (c#) application. I write a code for saving image on database and its success but the code for update image not success (its saving the empty field at image field on database), here's my code:for saving image to database
if (FileUpload1.HasFile && FileUpload1.PostedFile != null)
{
binaryImage = new byte[FileUpload1.PostedFile.ContentLength];
[code]...
i have in asp.net a few textboxes and i wish to update my database with the values that they encapsulate. The problem is that it doesn't work and although it doesn't work, the syntax seems correct and there are no errors present . Here is my linkbutton:
<asp:linkbutton id="clickOnSave" runat="server"
onclick="Save_Click" Text="Save Profile" />
and my update function
protected void Save_Click(object sender, EventArgs e)
{
SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = "DataSource=.\SQLEXPRESS;AttachDbFilename=C:\Users\alex\Documents\seeubook_db.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
con.Open();
String commandString = "UPDATE users SET last_name='" + Text4.Text.Trim() + "' , first_name='" + Textbox1.Text.Trim() + "' , about_me='" + Textbox5.Text.Trim() + "' , where_i_live='" + Textbox2.Text.Trim() + "' , where_i_was_born='" + Textbox3.Text.Trim() + "' , work_place='" + Textbox4.Text.Trim() + "' WHERE email='" + Session["user"] + "'";
SqlCommand sqlCmd = new SqlCommand(commandString, con);
sqlCmd.ExecuteNonQuery();
con.Close();
}
I have a project to build a portable customer information app. Because the client works in remote locations, there is not always Internet service available, so a live online option is not feasible. I plan to construct the project with Visual Web Developer 2010 Express, with .aspx pages for data entry and use an .mdb to store data.
The client has a small server on their site. I can install SQL and copy all tables from the app into a new database. However, I'm not sure how to set up syncing between the portable copies and the onsite database. My questions are:
How do I link the portable with the onsite SQL database?
Through a script, or do I need to use Linked Servers in SQL?Would an Insert statement work? But how do I compare the two, as there may be changes on either side...?
How do I initiate the transfer?
Through a Submit button which runs the script on the user's page? Or, do I need Visual Basic or a SQL script?
I have a button click event code block in which data should be updated to my database. After stepping through the code, the ExecuteNonQuery() executes, but no data in my database is changed. I don't think there is a problem with my code although I will include it just-in-case.
[Code]....
I'm confident that my command text and my parameter adding is correct.
I have taken over development of a asp.net 3.5, c#, MSSQL website, which I did not create.
There is a form on the website which adds all kinds of information into my SQL database. I have added two fields to the database, two corresponding extra form questions and added to the c# code behind so that these new fields are treated in exactly the same way as the existing ones.
I am therefore completely stumped as to why those two fields aren't populated in the database when I submit the form.
No page errors or anything, it's just the fields remain empty when the other pre-existing ones are populated just fine.
Is there something obvious I'm missing - for example is there a setting in the database I'm not enabling to allow the two new fields to be written to by my c# file?
I was not a programmer before this, I'm just picking it all up as I go along.
I am working on my first web site using ASP.net. In the past I was working with ADO to build Windows Forms applications.To the point...I want to know how to link my SQL db with the db that is inside in the ASP Web Site project. If I change the database using SQL Management Studio the data will be updated until I remove the .mdf of the project and add again the .mdf from my folder of SQL. I need to be able to update the database outside (Via the WebSite) and inside using SQL Server.
View 4 RepliesI am currently working on visual studio 2008 , sql express 2005, i have copied .mdf and .ldf files , after i copied these files and try execute some existing stored procedure but exception is coming like " Failed to update database xxxxxxxxxxxxxxxxx.MDF" because the database is read-only", I dont knw what's wrong with this , i have executed same stored procedure in old .mdf and .ldf database , and its working fine . but in copied .Mdf , not working.
View 10 RepliesI have created normalised data tables to hold look up information (such as venues, players, teams etc) and want to dynamically update the 'matches' data table (my transactions) using webpages instead of running SQL queries.
What I want to do is select a name from a drop down list and then post the relevant ID associated with that name to my 'matches' table. At the moment I can only link to the value in the drop down list, i.e. the name which is incompatible with the validation which expects a primary key integer.
I'm sure this problem is a fairly common one but I haven't found the right answer on any of the tutorials or blogs, all of them assume that the data is de-normalised or describe things in more technical ways than I can yet understand. If anyone can point me to a 'how to article' or tell me what I am doing wrong, I would be grateful.
i would like to update database which resides on web server from my database which is on my computer. One method is to upload the file and than make a connectionstring. But its not possible while I do so in every 10 secs.
Is there any method which can make the connection string from desktop to web server or any other way.
I have a Asp Mvc 2 site using forms authentication. When I run it locally I can log in and stay logged in indefinitely.
However when I put it on the server I seem to only stay logged in for a few minutes and then seems to be logged out. I have looked at the cookies and there are 2 which seem relevant:
.ASPXAUTH which is a session cookie .ASPXANONYMOUS which expires in 3 months.
When I refresh the page the cookies stay the same until I get logged out, when I seem to get a new .ASPXANONYMOUS cookie, but the .ASPXAUTH seems to be the same. It seems that I might be able to stay logged in until I do something after a certain amount of time. If I submit a form as soon as I am logged in then it works ok, but if I keep submitting data again and again then after a minute or so, one of the submits will happen as a logged out user and not as the user who was logged in, which all the other submits worked as. What might cause this behaviour and how can I track down what is different & change it so that I can stay logged in indefinitely?
its a single server, but after some more investigation and searching the likely candidate seems to be that I am using more than 100mb on the server and the application pool is getting recycled. I suppose now i need to know How can I check how much memory I'm using. What advice there is to reduce that.
I need to subtract one minute from the TimeOfDay
[Code]....
This the code.
Cache.Insert(txtUserName.Text.Trim(), 1, null,
DateTime.Now.AddMinutes(1),
TimeSpan.Zero);
But Cache didn't expire after a minute.
i have used the Created_Date = DateTime.Now, to set the default value of a datebut i want that date to include inaddtion to the day the hour minutes and seconds
View 6 RepliesI'm using ASP.NET MVC 3 with the Authorize attribute, but it keeps kicking me to the logon page after 1 minute, but even though my expiration is set to a very high value, it times out quickly. I check the cookie in my browser and its still there and not set to expire until about a month later, and it's set to be persistent, so I'm not sure why it keeps booting me. It only happens on my published location, locally it works just fine.
var ticket = new FormsAuthenticationTicket(username, true, 500000);
var encryptedTicket = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
cookie.Expires = ticket.Expiration;
Response.Cookies.Add(cookie);
web.config:
<authentication mode="Forms">
<forms loginUrl="~/Account/LogOn" timeout="7200" slidingExpiration="false"/>
</authentication>
i use asp.net and ajax
I have a button and I want to count that, how many times was the button clicked in 1 minute.if the user clicked the button more than 5 times in 1 minute it will be deny for 5 minute.
i want to execute some code every one minute like i select * from customers , now for each row, i want that each row will execute after 1 minute , in asp.net web application not in windows application.
View 1 RepliesI took a copy of a website that works fine on a server (done have server access) but when I set up a website in IIS7 and run the classic asp code loading a page is taking nearly a minute. It always loads the pages but just takes forever.
View 1 RepliesI have a gridview which is taking values using template feild. ASP databound feild displays duration in my gridview as hour:minute:second .
Eg: 1:30:10 (1hour:30 minutes:10 seconds) . I want to change this to minutes only. that it should converted to 90 minutes , The actual value is 90 minutes 10 seconds, As it has 10 seconds more I want to display it as 91 minutes. Final result in gridvew should be 91 minutes.How can i do this ?
I heard that onrowdatabound can be used for this, if so how can i do it. how can i make use the onrowdatabound to make this work
My source page is as bellow
<asp:GridView id="GrdCallList" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataSourceID="ObjectDataSource2"
Width="876px"
BackColor="#CCCCFF" BorderColor="Black" BorderStyle="Outset" BorderWidth="3px"
EnableViewState="False" Height="85px">
<columns>
<asp:BoundField DataField="Duration" HeaderText="Duration" SortExpression="Duration">
<HeaderStyle Wrap="False"></HeaderStyle>
i want to update the data of a database through a gridview update button
how can i attach a dataconvertion like this
[Code]....
i got a problem to update my database which i bounded to datagrid. The problem is, i want to update my database only by clicking one update button at the bottom.. when the user click it, all the fields will be updated to database.
View 3 Replies