|
What do mean by dynamic data?
It's just a HTML file with HTML on it. Just website content, words and pictures.
I just wanted to store some extra stuff like in a image file, just some data.
But I'm starting to think that's its a bad idea anyways.
Today I wrote some code that makes a XML file that represents the editable content, and the XML file points to the HTML file.
|
|
|
|
|
Alright I get it now.
Had to think about that for a while.
How about if I store the final post to the database?
In other words, let them use the temp html file in app_data so they can build there content over time, and then write the HTML to the database when they are ready to post it to the website as the final revision.
|
|
|
|
|
i use sql dependency related code in globa.asax file to detect db change notification. i just start the sql dependency from Application_Start event in global.asax file and also called a function which monitor db table change and send notification. every thing is working fine if
application pool
is running means at least one user is on our web site and at the same time db table change occur.
suppose when db change occur and at the same time
application pool
is idle or no visitor is visiting our web site then change detection routine is not getting invoke automatically.
here is the code
protected void Application_Start(Object sender, EventArgs e)
{
System.Data.SqlClient.SqlDependency.Stop(connectionString);
System.Data.SqlClient.SqlDependency.Start(connectionString);
RegisterNotification();
}
static SqlDependency dep;
private static void RegisterNotification()
{
string tmpdata = "";
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT ActivityDate FROM [bba-reman].ContentChangeLog";
dep = new SqlDependency(cmd);
dep.OnChange += new OnChangeEventHandler(OnDataChange);
SqlDataReader dr = cmd.ExecuteReader();
{
while (dr.Read())
{
if (dr[0] != DBNull.Value)
{
tmpdata = dr[0].ToString();
}
}
}
dr.Dispose();
cmd.Dispose();
}
}
finally
{
}
}
static void OnDataChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency dep = sender as SqlDependency;
dep.OnChange -= new OnChangeEventHandler(OnDataChange);
SiteSearch.CreateIndex(false);
RegisterNotification();
}
protected void Application_End(Object sender, EventArgs e)
{
System.Data.SqlClient.SqlDependency.Stop(connectionString);
}
just discuss how could i restructure my routine as a result
OnDataChange()
will fire if application pool is idle or if no visitor is visiting my web site.
one guy told me very vaguely
you are use the thread from the thread poll for the first request. as asp.net recycles threads and actions like redirect abort the thread, you need a safer thread to perform your action one. so in application start you should start a background thread to handle the dependency.
so please some one discuss this issue in details as a result my above code should run perfectly when no visitor is visiting our web site any page. thanks
tbhattacharjee
|
|
|
|
|
i through i will call SQL Dependency related code Application_Start event and my objective will be completed. my scenario is i have a routine in my web application which i invoke manually just clicking on a button when data updated in sql server table. i was told to make this process automated.
so i go through couple of article on SQL Dependency and through i can make my manual process automated by SQL Dependency because we can monitor table change by SQL Dependency and SQL Dependency can notify us when change done.
please see my code
protected void Application_Start(Object sender, EventArgs e)
{
System.Data.SqlClient.SqlDependency.Stop(connectionString);
System.Data.SqlClient.SqlDependency.Start(connectionString);
RegisterNotification();
}
static SqlDependency dep;
private static void RegisterNotification()
{
string tmpdata = "";
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT ActivityDate FROM [bba-reman].ContentChangeLog";
dep = new SqlDependency(cmd);
dep.OnChange += new OnChangeEventHandler(OnDataChange);
SqlDataReader dr = cmd.ExecuteReader();
{
while (dr.Read())
{
if (dr[0] != DBNull.Value)
{
tmpdata = dr[0].ToString();
}
}
}
dr.Dispose();
cmd.Dispose();
}
}
finally
{
}
}
static void OnDataChange(object sender, SqlNotificationEventArgs e)
{
SqlDependency dep = sender as SqlDependency;
dep.OnChange -= new OnChangeEventHandler(OnDataChange);
SiteSearch.CreateIndex(false);
RegisterNotification();
}
protected void Application_End(Object sender, EventArgs e)
{
System.Data.SqlClient.SqlDependency.Stop(connectionString);
}
the above code was running fine but i faced a good problem. suppose no visitor is visiting our web site and at the same time if some one change sql data by a win apps then i saw OnDataChange() event is not firing but if at least one visitor is with our site then OnDataChange() event is firing properly.
may be this is default nature of asp.net engine. i could use SQL Dependency in win service or in winform apps but i have some constrain because the routine which i am calling after detection of data change in db that is in our web application.
So please guide me what i can do as a result OnDataChange() event should always fire if no visitor is visiting our web site.
thanks
tbhattacharjee
|
|
|
|
|
Actual Source code exist in vs2010, Now i am converted into vs2012, this source code working fine for some days, but recently i got this error.
Compiler error Message : Metadata file 'C:\Users\Arka\AppData\Local\Temp\Temporary ASP.NET Files\root\5c0b21a7\1cd1610d\App_Web_kog0qzeo.dll' could not be found
how to solve this issue.
Please help me....
Thanks in Advance..
|
|
|
|
|
The message seems quite clear; check the location for the file in question.
|
|
|
|
|
Something went wrong with your ASP.NET temp folder (there should be files from older - 2010 - compilation that prevent 2012 to create new ones but also prevent 2012 to overwrite them...) - my advise is to delete it (wipe it out!) and recompile your project under 2012...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Hi friends
Flipkart Api can i use in asp.net
If Possible can give me sample Code
Thank You
|
|
|
|
|
I think there is no api for FlipKart. There is some affiliate program. If you want to know more ask to affiliate@flipkart.com
|
|
|
|
|
|
Hi friends
Please help me
how to use datapager with repeater in asp.net
Thank You
|
|
|
|
|
|
yes this is a good solution
Sankarsan Parida
|
|
|
|
|
Hello,
I am using ASP.Net to call crystal report..Not able to display the report using chrome browser but working fine with IE and Firefox.
Chrome version: 36.0.1985.143 m
Crystal Report Viewer version: 11.0
PLease help me in this regard.
Thanks,
SMA
|
|
|
|
|
You need to right click on the element and select inspect element, and verify or inspect the element to see what is wrong. It's not a common problem, so you need to do some detective work on it.
|
|
|
|
|
Good day everybody. Please, is it possible to call the onitemcommand of datalist control on page load event. If yes, how can it be done. Please help
|
|
|
|
|
Please do not repost the same question.
|
|
|
|
|
Please, i didn't meant to repost same question. It was network condition and i didn't know my question was already posted. Pardon the mistake
|
|
|
|
|
Good day everybody. Please, is it possible to call the onitemcommand of datalist control on page load event
|
|
|
|
|
|
Thanks Richard. I followed the link you suggested but that is not what i want. I know how to add the onitemcommand and how to call it. What i want is, i want to call the onitemcommand event on page load without waiting for click. Below is example of what i want.
Html
<pre><asp: DataList ID="dtl" runat="server" onItemCommand="action"/></pre>
code behind
<pre>Sub action(ByVal obj As Object, ByVal e As DataListEventArgs)
MsgBox("Hello")
End Sub
</pre>
the msg can only show when a button inside datalist is click. How can i make the msg show on page load? Thanks.
|
|
|
|
|
That's never going to work - you're trying to display a message on the server.
If you're lucky, you'll get an exception telling you that the current process is not interactive.
If you're not lucky, the message box will pop up on the server, where nobody will see it, and your page will hang waiting for someone to click the "OK" button.
The code might appear to work when you test it from Visual Studio, but that's only because you're testing it locally, so the server and client are the same machine. As soon as you deploy it to a real server, the code will fail.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
Respected sir,
I am student of final year B.Tech.(Information technology).plz suggests me some projects related to application software....
|
|
|
|
|
It is unlikely that we can make a valid suggestion, since we know nothing about you, your interests or experience. Find a subject that interests you and think of some application that would be useful in that field. Even a simple database and reporting system might have some useful application.
|
|
|
|