|
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
|
|
|
|
|
There was an error.
Error 1 Cannot implicitly convert type 'string' to 'bool' C:\WebSites\Attendance\Admin\frm_Report.aspx.cs 322 17 C:\WebSites\Attendance\
protected void GridView4_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
if (e.Row.RowType == DataControlRowType.DataRow)<br />
{<br />
if (e.Row.Cells[3].Text = "P")<br />
{<br />
presentCount++;<br />
}<br />
<br />
}<br />
else if (e.Row.RowType == DataControlRowType.Footer)<br />
{<br />
e.Row.Cells[3].Text = presentCount.ToString();<br />
}
thanks for your help so far Jay
|
|
|
|
|
if (e.Row.Cells[3].Text == "P")
put '==' operator for comparision
Regards,
Jay
|
|
|
|
|
Basically I have a dropdownlist which filter adminNo and then display each record at the gridview. So user can see how many P exists in column Category for each adminNo.
the result display at the footer is 0.
i hope it is not due to me filtering records by dropdownlist.
jay thanks
|
|
|
|
|
Whether it works or not ? You need to declare the variable 'presentCount' as a 'static' variable inorder to retain its value during the Gridview is population.
Regards,
Jay
|
|
|
|
|
I hope my declaration is correct.
public static int presentCount = 0;
But yet the footer still show 0.
JAY THANKS
|
|
|
|
|
Believe me it works fine... I think , ur data "P" came from database. It may have some white spaces. use Trim() method to remove that, then the string comparision works properly.
Hope it help u...
static int count = 0;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string tmp=(e.Row.Cells[3].Text).Trim();
if (tmp == "P")
{
count += 1;
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[3].Text = count.ToString();
}
}
-- modified at 6:27 Thursday 17th August, 2006
Regards,
Jay
|
|
|
|
|
Yes it came from a database. What an awesome solution!
Poem for Jay
I 1 2 SAY
to the person JAY
I am so GAY (happy)
to finally get the ans... Hip Hip HOORAY!
another brilliant ans from the pro.
|
|
|
|
|
blurMember wrote: I 1 2 SAY
to the person JAY
I am so GAY (happy)
to finally get the ans... Hip Hip HOORAY!
Best Regards,
Apurva Kaushal
|
|
|
|
|
always welcome...
Regards,
Jay
|
|
|
|
|
When the user click from the ListBox to view each adminNo, the Show Footer manage to calculate the number of P exist in the gridview.
But when the user click another adminNo, the Show Footer number was accumulated with the previous Show Footer.
Example:
when the user click for the first time
Show Footer: 18
second output when user click for the second time, the number of P exist in the gridview is suppose to be 10, but show 38 instead
Show Footer: 38
thanks in advance. Much appreciated.
|
|
|
|
|
i think the static variable 'showCount' keeps its old value. So you may declare it properly , in such a way that when u click a item from ur ListBox , the variable is set to zero.
hope it helps u
Regards,
Jay
|
|
|
|
|
My flu and cough is really bad, i can't even think.
protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)<br />
{<br />
count = 0;<br />
}
I did this to save my trouble. Hope no more problem.
thanks again superjay
|
|
|
|
|
Regards,
Jay
|
|
|
|
|
Try out this !.............
int presentCount = 0;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
YourType obj = e.Row.DataItem as YourType;
if ( obj.Property = "P")
presentCount++;
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[3].Text = presentCount.ToString();
}
}
|
|
|
|
|
i am having doubt the data type need to be used. What is the best solution?
My Category value is a char data type from the database.
thanks in advance. Much appreciated.
|
|
|
|
|
Hi All,
I am a PHP developer with more than 2 years of experience and now I want to start with ASP.NET.
For this I need very basic tutorials and your valuable guidance so that I may proceed.
I could not find these on net. Like I could not find how I shud connect asp.net with MsSql.
So please help.
Thanks
|
|
|
|
|
http://www.google.co.in/search?hl=en&q=creating+database+connection+asp.net&btnG=Search&meta=
Best Regards,
Apurva Kaushal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
