|
Hi guys,
Im working on asp.net1.1 web application on C#. actually i have a page in which the user fills up certain details and also have an option to upload a file which is mandatory. Now at the database along with the details entered by the user the file location path also gets saved in the database say for example D:\webapp\Hello\Modules\Agreement\01-11-2010 08-43-50AMimage.gif -- dis is what gets stored in the DB. Now after the user has clicked the submit button the data is inserted and i also have a datagrid in the same page on which the data stored in database gets populated, currently the path of the file is displayed on the datagrid as mentioned above. but what my requirement is i want the path to be displayed as a hyperlink so dat on clicking the link the file gets downloaded.. trhe code is as follows
the following code is on page display.aspx.cs
private void BindAgreement()
{
string Module = Request.QueryString["servId"];
DataSet dReasons = DataAccess.ExecuteStoredProcedure(Session["MosaicConn"].ToString(),"asp_app_get_mainagreement "+Module);
if(dReasons.Tables.Count > 0)
{
if(dReasons.Tables[0].Rows.Count > 0)
{
DataTable dtDisplay = new DataTable();
dtDisplay.Columns.Add(new DataColumn("row_id",typeof(string)));
dtDisplay.Columns.Add(new DataColumn("module_id",typeof(string)));
dtDisplay.Columns.Add(new DataColumn("total_value",typeof(string)));
dtDisplay.Columns.Add(new DataColumn("amc_start_dt",typeof(string)));
dtDisplay.Columns.Add(new DataColumn("license_amt",typeof(string)));
dtDisplay.Columns.Add(new DataColumn("implement_amt",typeof(string)));
dtDisplay.Columns.Add(new DataColumn("number_of_licenses",typeof(string)));
dtDisplay.Columns.Add(new DataColumn("agree_file_name",typeof(string)));
for(int i = 0; i < dReasons.Tables[0].Rows.Count; i++)
{
DataRow drDisplay;
drDisplay = dtDisplay.NewRow();
drDisplay[0] = dReasons.Tables[0].Rows[i].ItemArray[0];
drDisplay[1] = dReasons.Tables[0].Rows[i].ItemArray[1];
drDisplay[2] = dReasons.Tables[0].Rows[i].ItemArray[2];
drDisplay[3] = dReasons.Tables[0].Rows[i].ItemArray[3];
drDisplay[4] = dReasons.Tables[0].Rows[i].ItemArray[4];
drDisplay[5] = dReasons.Tables[0].Rows[i].ItemArray[5];
drDisplay[6] = dReasons.Tables[0].Rows[i].ItemArray[6];
drDisplay[7] = dReasons.Tables[0].Rows[i].ItemArray[7];
dtDisplay.Rows.Add(drDisplay);
}
lblMessage.Visible = false;
rptUsers.DataSource = dtDisplay;
rptUsers.DataBind();
}
the following code is the code for the datagrid on display.aspx page
<table style="BORDER-COLLAPSE: collapse" borderColor="#006699" width="100%" border="1">
<tr>
<td bgColor="background" colSpan="6"><FONT face="Arial" color="#ffffff" size="2"><STRONG> Available
Agreements</STRONG></FONT></td>
</tr>
<TR bgColor="background">
<td style="WIDTH: 38px"><FONT face="Verdana" color="#ffffff" size="1"><b> Total Value</b></FONT></td>
<td style="WIDTH: 66px"><FONT face="Verdana" color="#ffffff" size="1"><b> AMC Start
Date</b></FONT></td>
<td style="WIDTH: 50px"><FONT face="Verdana" color="#ffffff" size="1"><b> License
Amount</b></FONT></td>
<td style="WIDTH: 95px"><FONT face="Verdana" color="#ffffff" size="1"><b> Implementation
Amount</b></FONT></td>
<td><FONT face="Verdana" color="#ffffff" size="1"><b> Number of licenses</b></FONT></td>
<td><FONT face="Verdana" color="#ffffff" size="1"><b> File Name</b></FONT></td>
</TR>
<asp:repeater id="rptUsers" runat="server">
<ItemTemplate>
<TR bgColor="#dcd1ff">
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"total_value")%> </FONT><input runat=server type="hidden" id="row_id" name="row_id" value='<%# DataBinder.Eval(Container.DataItem,"row_id")%>'></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"amc_start_dt")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"license_amt")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"implement_amt")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"number_of_licenses")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"agree_file_name")%> </FONT></td>
</TR>
</ItemTemplate>
<AlternatingItemTemplate>
<TR bgColor="#d7dcff">
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"total_value")%> </FONT><input runat=server type="hidden" id="Hidden1" name="row_id" value='<%# DataBinder.Eval(Container.DataItem,"row_id")%>'></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"amc_start_dt")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"license_amt")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"implement_amt")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"number_of_licenses")%> </FONT></td>
<td><FONT face="Verdana" size="1"> <%# DataBinder.Eval(Container.DataItem,"agree_file_name")%> </FONT></td>
</TR>
</AlternatingItemTemplate>
</asp:repeater></table>
<br>
</td></TD></tr>
</table>
Thanx in advance,
Tash
|
|
|
|
|
Add a hyperlink rather than a label. What problems are you encountering? What don't you understand?
Also, you should not be using the FONT element. Use CSS.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi thanks for your reply.
Actually i can display the path of the file in my page. since im using a repeater over here i wanna show the path of the file as a hyper link and when user clicks on the path the file should get downloaded.. im struggling at this point.. Any help is appreciated..
Thanx in advance,
Tash
|
|
|
|
|
Hello,
i have multiple files on server. I want to Copy all files on Client Machine at once time.
Now i am just using this code
Response.Write("<script type=\"text/javascript\">window.open('download.aspx?f=" + path + "');</script>");
Its Save the file one by one on client machine and ask every time for save.
But i want to save all files at once save click, ya copy all files in Client Machine at once
Regards
Raushan Kumar
|
|
|
|
|
hello all..
I want to ask for help..
about making simple chatting.. with filter word..
any suggest or turtorial maybe?
just simple chatting like facebook, maybe desktop not online..
thx b4..
|
|
|
|
|
if you go to BCC news website or any other website you'll see the usrl is referring to a file like this:
http://www.bbc.co.uk/news/world-middle-east-11661496
not to a database like this:
http://www.bbc.co.uk/news.aspx?id=9999999
so what's the best way to save news website? how do they do it? i don't think it's just physical files because maintaining it would be very very difficult..
can anyone explain to me please....
|
|
|
|
|
jrahma wrote: http://www.bbc.co.uk/news/world-middle-east-11661496
The above url that you are talking about, It is not the linked to the direct page. They must have used some routing mechanism or URL rewriting kind of thing. So user clicks the news link it is redirected to the appropriate page wit the help of mechanism implemented.
jrahma wrote: so what's the best way to save news website? how do they do it? i don't think it's just physical files because maintaining it would be very very difficult..
I didn't get your question.
Do you want save the links of the news. So for a user point of view, both the links are same, whether the routed url or querystring one.
|
|
|
|
|
I have a timer which displays the current time within an asp:UpdatePanel This part is working fine..
I have another asp:UpdatePanel on the same page with two TextBoxs for login purpose.
The problem when the timer is running and I try to put the cursor in one of the two boxes in the UpdatePagel of the loging area it just stays there for seconds and then lose the focus! why is that?
these are the panels:
<dxt:ASPxTimer ID="timerClock" runat="server" Interval="1000" OnTick="timerClock_Tick" />
<asp:UpdatePanel runat="server" UpdateMode="Always">
<Triggers>
<asp:AsyncPostBackTrigger ControlID="timerClock" />
</Triggers>
<ContentTemplate>
<asp:Table runat="server" Width="120" BorderWidth="0" CellPadding="0" CellSpacing="0">
<asp:TableRow>
<asp:TableCell HorizontalAlign="Center" VerticalAlign="Middle"><dxe:ASPxImage ID="imageFlag" runat="server" ImageUrl="~/images/flags/ar-BH.gif" /></asp:TableCell>
<asp:TableCell HorizontalAlign="Center" VerticalAlign="Middle" Width="100%"><dxe:ASPxLabel ID="lblCurrentTime" runat="server" Font-Bold="true" Text="Loading.." /></asp:TableCell>
</asp:TableRow>
</asp:Table>
</ContentTemplate>
</asp:UpdatePanel>
<asp:UpdatePanel runat="server">
<ContentTemplate>
<asp:Table ID="Table1" runat="server" CellPadding="2" CellSpacing="2">
<asp:TableRow><asp:TableCell>Email Address:</asp:TableCell></asp:TableRow>
<asp:TableRow><asp:TableCell><dxe:ASPxTextBox ID="txtLoginEmail" runat="server" Width="160px" /></asp:TableCell></asp:TableRow>
<asp:TableRow><asp:TableCell>Password:</asp:TableCell></asp:TableRow>
<asp:TableRow><asp:TableCell><dxe:ASPxTextBox ID="txtLoginPassword" runat="server" Width="160px" /></asp:TableCell></asp:TableRow>
<asp:TableRow><asp:TableCell HorizontalAlign="Center"><asp:Button ID="btnLogin" runat="server" Text="Login" Width="100px" /></asp:TableCell></asp:TableRow>
</asp:Table>
</ContentTemplate>
</asp:UpdatePanel>
|
|
|
|
|
What is the easiest way to achieve that?
Do I have to create an API for my website?
Any references please send them.
Thanks
|
|
|
|
|
Hello
what does this error mean?
"500-inernal server error .
There is a problem with the resource you are looking for, and it cannot be displayed."
This project has been written with visual studio .net 2010 and the database is ms sql server 2008.
Every few times I am faced with this error.
Can anyone help me to solve this error ?
Thanks
Davood
D.riazi
|
|
|
|
|
The 500 message you posted is pretty much the server equivalent of "Exception", in that it means "something" has gone wrong the processing the request and the error is on the server side (as opposed to a bad call from the client). It could be one of 1000s of things, can you post a stack trace or log message as the error you supplied doesn't narrow things down very much.
|
|
|
|
|
See, this error is returned from the web server. The Web server encountered an unexpected condition that prevented it from fulfilling the request by the client
This error itself doesn't describe about the error. You need to see the IIS logs to find more details about the error.
So see the logs which might help you to find the exact issue.
|
|
|
|
|
hi
how to print a mobile web page that run at mobile device such as pda or smart phone?
thabks a lot
|
|
|
|
|
hiii to all
any one can tell step by step how to upload data base like Ms Access and Sql Server
rizvan sivally
|
|
|
|
|
Upload a database?? What do you mean by that???
Cheers,
Karthik
|
|
|
|
|
to upload a MS Access to the server for particular website by that we can store and edit our record on the web as we do in our local system
rizvan sivally
|
|
|
|
|
Check out this tutorial. It might be of help to you.
http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/1/[^]
In this case the poster uses a local MS Access database. So in your case, you could have your .mdb in your server and then use Server.MapPath to get the full physical path. But be careful to secure your database file (w/ a password or some other mechanism), because in such an implementation, its accessibility will be wide open. If there is an option to use MS SQL, you could always choose that.
Cheers,
Karthik
|
|
|
|
|
i waht to know what is WCF and how to learn it
Thanks
|
|
|
|
|
WCF Tutorials[^]
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
Is it difficult to find it out in google; the tutorial site and the books?
IMO, getting a book and reading it from scratch should help you more.
Well, wrong forum.
CodeProject has got a separate forum for WCF:
WCF Forum in Code Project[^]
|
|
|
|
|
I am trying to remove address bar of browser from javascript. I am writing the following code
window.open('newWindow.aspx', 'new', 'width=' + width + ', height=' + height + ', toolbar=no,location=0, left=' + left + ',top=' + top + 'screenX=' + left + ',screenY=' + top + ', directories=no, menubar=no,scrollbars=no,resizable=no, status=no');
please help,
Thanks in advance.
|
|
|
|
|
amitrajahuja wrote: I am trying to remove address bar of browser from javascript.
Then why haven't you asked this in the Javascript forum instead of here?
I could be wrong, and can't find a reference now, but I seem to remember reading that Microsoft had removed the ability to do this, on the grounds that users had a right to know the address of whatever page they were on (and maybe re-directed to unwittingly) - call it a security measure.
|
|
|
|
|
search on google you will find it
|
|
|
|
|
hi, just try this.
I think in new versions of IE address bar will be visible ...
var strVal = "toolbar=0,location=0, directories=0, status=0, menubar=0,scrollbars=0,resizable=0," + "width=" + width + ",height=" + height +",left=" + left + ",top=" + top
window.open("newWindow.aspx", "new", strVal);
|
|
|
|
|
Hi, i have a requirement like as below.
I need to get the current url of the browser in the code.Based on that url the logic will depends. The problem is we are doing URL rewriting in web.config.
Original URL - http://mysite.com/test/mypage.aspx
URLRewrite - http://mysite.com/site/champ
In my code if i use Request.URL i am getting URLRewrite one. But how can i get the original url in mycode ?
Please suggest me
G. Satish
modified on Friday, October 29, 2010 3:49 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
