|
You can just create a web page (e.g. WebForm1.aspx) in asp.net and put the following code in Page_Load event in code behind page
Response.ContentType = "application/vnd.ms-excel";
string sFile = Server.MapPath("MyExcel.xls");
FileStream fs = new FileStream(sFile, FileMode.Open, FileAccess.Read);
byte[] b = new byte[(int)fs.Length];
fs.Read(b, 0, (int)fs.Length);
fs.Close();
Response.Clear();
Response.BinaryWrite(b);
Response.End();
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
This will create a new excel sheet. But samerh want the excel inside the aspx page like the images and gif files.
|
|
|
|
|
|
thanx for last help
sir please send me code for taking the value from hidden column in gridview.
|
|
|
|
|
vikas shukla wrote: thanx for last help
Which help are you talking about ?
If you are pointing some of previous thread , then you should post it over there rather than posting a new thread !
|
|
|
|
|
in asp.net hidden field could not render there u can not access it.
but u can apply the technique here.
insert template field hide it. and access its ItemTemplate Control.
<asp:GridView ID="grd" Width="100%" runat="server" AllowPaging="True" AutoGenerateColumns="False" PageSize="15" AutoGenerateEditButton="True" >
<Columns>
<asp:TemplateField HeaderText="ID" Visible="False">
<ItemTemplate >
<asp:Label ID="lblID" runat="server" Text='<%# Bind("ID") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle Width="190px" />
<ItemStyle Width="190px" />
</asp:TemplateField>
</Columns>
</asp:GridView>
foreach (GridViewRow row in grd.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
Label lblID = (Label)row.FindControl("lblID");
string txt = lblID.Text;
}
}
|
|
|
|
|
instead of maintaining some values in a column and hiding it you can use datakeys.
|
|
|
|
|
if the column is a bound field and it's visibility is turn off, it cannot be retrieved as the value isn't rendered in that case. Either use template field or use datakeys, it depends how you're using it.
|
|
|
|
|
I have a dynamically databound gridview on my Page.
I have some data being entered into a textbox for every value being selected in a dropdown.
Everytime TEXTBOX value is entered, It should be reflected in one of the gridview column and should be editable.All the other colums should be non editable.
Can You please let me know how this can be achieved?
|
|
|
|
|
use bound field for non editable columns and use template fields for editable columns
|
|
|
|
|
I am using a template field already.
What is the real issue is how to map the values from a textbox onto this column for a specific row.
|
|
|
|
|
|
Dont spam
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hi!
I am not sure where should I post this topic. I just need an idea about my task below
a central server polls from a legacy server for media updates. the media file has incremental file name i.e 1.mpeg, 2.mpeg and so forth. central server needs to poll the legacy server and check for update via ftp. once it finds update it needs to copy the files and bring into central server from legacy server and distribute to its 600 clients. each client plays those mpegs constantly and central server needs to update the content in clients playlist automatically. for example clients current playlist could be
1.mpeg
2.mpeg and so forth. how do i keep adding the updated file to the play list and keep deleting if the files are more than 20 i.e.
play 1-20 and as soon as it hits 21 delete old files
please help i dont know how to acheive this and which what program.
thanks in forward.
|
|
|
|
|
|
I have a dropdownlist and based on its selected value I want to display the appropriate pdf document. This is the code under the dropdownlist
protected void ddlBasicConcept_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlBasicConcept.SelectedValue.Equals("Variable"))
{
ShowPdf1.Visible = true;
ShowPdf1.FilePath = "file///C:/Documents and Settings/lingwatil/My Documents/VisualStudio2008/websites/LearningConceptsB/asp.net_tutorial01_Basics_cs.pdf";
showpdf1 is my Iframe
and this is the ERROR I'm getting, please help.
Server Error in '/LearningConceptsB' Application.
--------------------------------------------------------------------------------
HTTP Error 400 - Bad Request.
--------------------------------------------------------------------------------
Version Information: ASP.NET Development Server 9.0.0.0
ML Lingwati
|
|
|
|
|
my application is, shutdown remote system using process.start("shutdown",-s,-f \\machinename);
it works fine from visual studio.
but when i install this application in iis server and run, it will displays error
shutdown.exe - application error
application failed to initialized properly.
do i need to set any permissions to run shutdown.exe from remote machines
Thank You
|
|
|
|
|
Hi,
apps in IIS are running under a different account (ASPNET for IIS5, NETWORKSERVICE for above). You could impersonate your process.start with using the properties username and password.
Regards
Sebastian
|
|
|
|
|
nani6666 wrote: shutdown remote system using process.start("shutdown",-s,-f \\machinename);
Why would any Web application would do a System Shutdown?
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
please help me
please post code for showing hyperlink in gridview column by rowdatabound in C#.net
|
|
|
|
|
vikas shukla wrote: please post code for showing hyperlink in gridview column by rowdatabound in C#.net
What did you try before asking this question here.
A simple Google search [^]would have help you and save your time.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
add GridView to your page. add TemplateField to the GridView and add hyperlink control to the item template
<asp:GridView ID="grdUsers" Width="100%" runat="server" AllowPaging="True" AutoGenerateColumns="False" PageSize="15" AutoGenerateEditButton="True" OnRowDataBound="grd_RowDataBound" >
<Columns>
<asp:TemplateField HeaderText="hyperlink">
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" runat="server">HyperLink</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
In row databound you can initialize NavigateUrl Property. as below
protected void grd_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HyperLink Hlink =(HyperLink) e.Row.FindControl("HyperLink1");
if (Hlink != null)
{
Hlink.NavigateUrl = "http://www.google.com";
Hlink.Target = "_blank";
Hlink.Text = "Google";
}
}
}
|
|
|
|
|
I am woring on a scheduler application in asp.net with c#.
in this application i have to show popup on scheduled time and date.
scheduled time and date store in sql server table and popup contains.
can any one help me how can i open popup on specified date and time.
thanks
|
|
|
|
|
through window service u can do it. But will not be web application.
because to open the pop up the application should be in running state.
and we can not ensure a web application is in running state.
for this u can put the timer in your application.
pick the time from database.
then calculate the time span with system Time.
and Initialize the timer Tick property.
start the timer.
and pop up the window on Timer_tick Event.
|
|
|
|
|
Hi
It would be great if you can send across the sample code. This will help me a lot. I am new to this and hence your help would be grealty appreciated.
Thanks in advance.
Awaiting for a positive response from you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
