|
1. Using ADO.NET Datareader a user extracts data from a database table
having 1000 rows.He closed his browser in between.
that is after fetching only 50 records.
What happens to the Datareader?will it remain connected?
and will fetch 1000 records and what after?
will garbage collector collect and dispose it soon?
2. A user fetched dtata from a database table
using Dataset(Disconnected records) for updation.
Another user deleted the table just after.
what happens when the first user try to update the table after changes? Error or Something else
3.where is session id stored in ASP? in IIS aerver or ASP Engine
Thanks & Regards
Vishal Sharma
vishalsharma556@yahoo.co.in
|
|
|
|
|
If we help you get the job, do we get part of your paycheck, too?
--Jesse
|
|
|
|
|
Rule #1...don't post the same question in more than one topic board.
|
|
|
|
|
Ans 1: Active connection will be there in the database, connection won't close itself, because we used a datareader, it is a not disconnected like dataadapter. We have to manually close the connection.
Ans 2: We will get an exception exception like "concurrency violation ..."
Ans 3: No idea
Ram
|
|
|
|
|
The session ID in ASP.NET is usually stored as a nonpersistent cookie on the client. The format of this cookie for example, asp.net_sessionid=jhmbobkcbinehlpkjhopabbe.
In addition to the traditional nonpersistent cookie method of maintaining state, ASP.NET supports a “cookieless” mode. When the cookieless mode is enabled, ASP.NET embeds the session ID in the URL that is sent back to the client. This provides persistence for clients using browsers that either do not support cookies or have cookies disabled. Cookieless mode is worth keeping in mind, considering the current emotions concerning cookies and tracking customers with them.
Regards,
Uma
-- modified at 0:17 Friday 18th August, 2006
|
|
|
|
|
|
Hi Ram,
Thank u. can u give me ur id
Regards,
Uma
|
|
|
|
|
Here is my id e_ramsubbu@hotmail.com
Ram
|
|
|
|
|
Hi,
I am using Form Authentication in ASp.net 2.0 .
FormsAuthentication.SetAuthCookie(
"jhon", false);
FormsAuthenticationTicket ticket1 =
new FormsAuthenticationTicket(
1,
"jhon",
DateTime.Now,
DateTime.Now.AddMinutes(10),
false,
"Admin"
);
HttpCookie cookie1 = new HttpCookie(
FormsAuthentication.FormsCookieName,
FormsAuthentication.Encrypt(ticket1));
Response.Cookies.Add(cookie1);
Response.Redirect("Default.aspx");
In Authentication_BeginRequest event i have this code
if (HttpContext.Current.User != null)
{
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
FormsIdentity id = (FormsIdentity)HttpContext.Current.User.Identity;
FormsAuthenticationTicket ticket = id.Ticket;
string userData = ticket.UserData;
string[] roles = userData.Split(',');
HttpContext.Current.User = new GenericPrincipal(id, roles);
}
}
I am using Sitemap xml file where nodes specified with role attribute. When on binding the sitemap to a treeview . All nodes are listing. Seems role based listing is not comming into action. How to solve this problem.
|
|
|
|
|
Have you enabled security trimming on your sitemap? You can do this by adding the attribute securityTrimmingEnabled="true" in your site map provider definition in web.config, as in the following example:
<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
<providers>
<add name="XmlSiteMapProvider"
description="Default SiteMap provider."
type="System.Web.XmlSiteMapProvider"
siteMapFile="Web.sitemap"
securityTrimmingEnabled="true" />
</providers>
</siteMap>
|
|
|
|
|
Hi Mike,
I've added the Tag to web config but the problem is still there . What to do.
|
|
|
|
|
|
Thanks for your valuable time mike.
It was some problem with the authorization folder paths in webconfig.
|
|
|
|
|
Hi friends,
Please help in
opening a file using c# on a button click...
I tried with link button by asigning the resolve url to the file path..
but i couldnt open it...
Regards,
Sivaprasad
|
|
|
|
|
What problem are u getting? Which type of you want to open?
Best Regards,
Apurva Kaushal
|
|
|
|
|
i want to open a .html file
Regards,
Sivaprasad
|
|
|
|
|
it should be filefield html control will solve your problem.
|
|
|
|
|
Try this out,
We can change the content type to open a file, This code will open document:
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" +
sOrigFilename);
Response.AddHeader("Content-Length", oFileInfo.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.WriteFile(sFullFilePath);
Response.End();
This will used to open an excel file:
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename="
+ "c:\\Test\\Test.xls");
Response.AddHeader("Content-Length", oFileInfo.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.WriteFile("c:\\Test\\Test.xls");
Response.end
Ram
|
|
|
|
|
Thanks Ram...U r code will do ..but I want to know the exact content type which will help me to download a .html file
I am using Response.ContentType="application/x-zip-compressed" and Response.ContentType="application/x-zip...But in both case i am not able to open it....
Regards,
Sivaprasad
|
|
|
|
|
I am using c#. i have a gridview and one of the column is Category. I have used the objectdatasource to bind the data. I want to count the number of "P" exist in that column and display it at the footer of the gridview.
<br />
int presentCount = 0;<br />
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
if (e.Row.RowType == DataControlRowType.DataRow)<br />
{<br />
presentCount++;<br />
}<br />
else if (e.Row.RowType == DataControlRowType.Footer)<br />
{<br />
e.Row.Cells[3].Text = presentCount.ToString();<br />
}<br />
}
What whould be the correct way. What syntax should be replaced by #?
Is there any sample I can follow?
thanks in advance. Much appreciated.
|
|
|
|
|
Hi,
Please check wether you can write e.Row["Category"] = "P" instead of # = "P".
I think this will help !
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
Anant Y. Kulkarni
|
|
|
|
|
There was an error when I compiled.
Error Cannot apply indexing with [] to an expression of type 'System.Web.UI.WebControls.GridViewRow' C:\WebSites\Attendance\Admin\frm_Report.aspx.cs 322 17 C:\WebSites\Attendance\
thanks in advance. Much appreciated.
|
|
|
|
|
Hi,
Sorry about that but i dont know about the GridView.
You can use the cells collection of the row -
r.Row.Cells(0) where the '0' is column number of your desired column.
I am not sure about it but you can atleast try !
check this -
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.tablerow.cells.aspx[^]
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
Anant Y. Kulkarni
|
|
|
|
|
Thanks for the link, I have yet to understand.
Anyone there who can help?
|
|
|
|
|
Hi Blur Member ....
u may use ," e.Row.Cells[index].Text " to get the value on that Particular Cell ( index th position, zero indexing) of the current row.
Hope It works..
Regards,
Jay
|
|
|
|