|
Hi all,
I want datetime datatype column in database(SQL Server).In SQL it is stores in the format MM/dd/yyyy hr:mm:ss AM/PM.
My problem is that I need to display this time in 24hrs.
For ex: 6/20/2005 3:30:00 PM
They I want to display 20/6/2005 in date column of datagrid and and the time 3:30 PM should be display as 15:30 and it is AM then I dont have to do any thing.
For Date I have use the following code:
System.Globalization.DateTimeFormatInfo dtf = new System.Globalization.DateTimeFormatInfo();
dtf.ShortTimePattern = "dd/MM/yyyy";
DateTime fdate = DateTime.Parse(txtTrainingfdt.Text, dtf);
Can any one tell me how should I do the same thing for time.If any one can suggest me with the code that will be more help full.
Thanks in advance.
|
|
|
|
|
Hi,
I have dataset and and a hyperlink.when somebody click on that link it should download
the ms-excel file. I dont want to create it and store it on the
web server. I would like to create it on the fly and send
a temp file or something like that.
Can anybody please help me?
Thanks,
NIKI
-- modified at 0:23 Friday 30th June, 2006
|
|
|
|
|
Hello Niki,
You can create excel file on the fly. I have posted in my previous message that how to create excel file on the file and give to user for download.
First of all you need to generate html code in table format from dataset.I am writing the code for that as well.
----------------------------------------------------------------------
//Write a table structure from dataset
//Suppose your dataset name is ds then write following code on click event of hyperlink:
string strHtml = "<table border='1' cellspacing='0' cellpadding='0'>";
DataTable dt = ds.Tables(0);
foreach(DataRow dr in dt.Rows)
{
strHtml+="<tr>";
for(int i=0;i<dt.Columns.Count;i++)
{
strHtml+="<td>" + dr[i].ToString() + "</td>";
}
strHtml+="</tr>";
}
strHtml+="</table>";
//Clear the Response Headers
Response.Clear();
Response.Charset = String.Empty; // String.Empty();
//Set Content Type and add header
Response.ContentType = "application/vnd.ms-excel";
//Add Header to create a file on the fly, give file name also. (i.e. abc.xls)
Response.AddHeader("Content-Disposition", "attachment; filename=abc.xls;");
this.EnableViewState = false;
//Declare new HtmlTextWriter
System.IO.StringWriter myTextWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter myHtmlTextWriter = new System.Web.UI.HtmlTextWriter(myTextWriter);
//Declare new HtmlGenericControl and feed it with the strHtml
HtmlGenericControl gn = new HtmlGenericControl();
gn.InnerHtml=strHtml;
//Finally render the HtmlGenericControl to Response
gn.RenderControl( myHtmlTextWriter);
Response.Write(myTextWriter.ToString());
Response.End();
----------------------------------------------------------------------
Regards,
Ketan.
-- modified at 7:30 Wednesday 5th July, 2006
|
|
|
|
|
Hi Ketan,
Thank You very much for the valuable help.
As I know, we dont have onclick event for HyperLink. So, where should i place this code???
I really appreciate your help.
Thanks,
NIKI
|
|
|
|
|
Set NavigateUrl property of HyperLink control to current page name and add one flag in query string.
For example, if your current page name is page.aspx then set NavigateUrl property as : "page.aspx?excel=true"
And then, in page_load() event add following code:
if(Request.QueryString["excel"]=="true")
{
//Write stuff to create excel file.
}
I am sure this trick will work.
Regards,
Ketan.
|
|
|
|
|
Hi Ketan,
Thank you very much sir.
But I am working on Share Point server. And this functionality i have to add in my WebPart.I am facing hard time for this problem.If you can help me, it will be really great.
Thank you very much ketan for your help.
NIKI
|
|
|
|
|
Well, I dont know anything about Share Point server, I am sorry I cant help now anymore.
Regards,
Ketan
|
|
|
|
|
Hi,
i have a page by name public class webform1: System.Web.UI.Page (webform)
which is basically a page which dynamically generates controls .The users
have to inherit the page if they want the same format of the default page (controls)
so what i did in webform 2 was
public class webform2 : webform1
in the webform1 i have declared the place holder pl1 where i have all the controls pushed in .On running webform2 i dont see the controls present in webform1.(webform1 is running fine with cntls being displayed)
pls help me out
|
|
|
|
|
You may consider using the MasterPage which supports visuality inheritance and it's much simpler.
|
|
|
|
|
You are inheriting the class, but not the contents of the .aspx file.
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
Since the placeholder is declared in the code behind then why is it not displaying.
Is there a way out to inherit the controls(in .net 1.0) from one page to another so that we can use it as a master page as in .net 2.0.
|
|
|
|
|
What you declare in code behind is only the reference to the control, not the control itself.
---
b { font-weight: normal; }
|
|
|
|
|
Scenario: I was using Template columns with ImageButtons with no problem controlling the columns' width. However template columns are not allowed when 'EnableSortingAndPagingCallbacks="True"'.
Original html code:
<asp:TemplateField ItemStyle-Width="22px">
<ItemTemplate>
<asp:ImageButton ID="imbView" runat="server" ImageUrl="~/Images/ViewSearch.gif" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField ItemStyle-Width="22px">
<ItemTemplate>
<asp:ImageButton ID="imgEdit" runat="server" ImageUrl="~/Images/Edit.gif" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField ItemStyle-Width="22px">
<ItemTemplate>
<asp:ImageButton ID="imgDelete" runat="server" ImageUrl="~/Images/Delete.gif" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField ItemStyle-Width="22px">
<ItemTemplate>
<asp:ImageButton ID="imgPrint" runat="server" ImageUrl="~/Images/Print.gif" />
</ItemTemplate>
</asp:TemplateField> So I replaced the template columns with HyperLinkField. Then in the onRowDataBound event in the code-behind, I set the images to the respective links.
</asp:HyperLinkField DataNavigateUrlFormatString="~/Invoices/Invoice.aspx?id={0}&Readonly" DataNavigateUrlFields="InvoiceID" ItemStyle-Width="20px" />
</asp:HyperLinkField DataNavigateUrlFormatString="~/Invoices/Invoice.aspx?id={0}&Edit" DataNavigateUrlFields="InvoiceID" />
</asp:HyperLinkField DataNavigateUrlFormatString="~/Reports/Reports.aspx?DeleteFromSomeWhere" DataNavigateUrlFields="InvoiceID" />
</asp:HyperLinkField DataNavigateUrlFormatString="~/Reports/Reports.aspx?id={0}" DataNavigateUrlFields="InvoiceID" />
public void dgData_onRowDataBound(Object src, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView row = (DataRowView)e.Row.DataItem;
HyperLink link = (HyperLink)e.Row.Cells[0].Controls[0];
if (!(link == null))
{
link.ImageUrl = "~/Images/ViewSearch.gif";
link.ToolTip = "Print";
}
link = (HyperLink)e.Row.Cells[1].Controls[0];
if (!(link == null))
{
link.ImageUrl = "~/Images/Edit.gif";
link.ToolTip = "Print";
}
link = (HyperLink)e.Row.Cells[2].Controls[0];
if (!(link == null))
{
link.ImageUrl = "~/Images/Delete.gif";
link.ToolTip = "Delete Invoice";
link.Attributes.Add("onclick", "javascript: alert('works'); return false;");
}
link = (HyperLink)e.Row.Cells[3].Controls[0];
if (!(link == null))
{
link.ImageUrl = "~/Images/Print.gif";
link.ToolTip = "Print Invoice";
}
}
}
After the changes, which fixes the EnableSortingAndPagingCallbacks problems, the column images (ViewSearch, Edit, Delete & Print) are spaced apart instead of nicely next to each other. I have tried the following variations with no luck.
if (!(link==null))
{
link.ImageUrl = "~/Images/ViewSearch.gif";
link.ToolTip="Print";
link.Width = System.Web.UI.WebControls.Unit.Pixel(20);
e.Row.Cells[0].Style.Add("max-width", "20px");
e.Row.Cells[0].Style.Add(System.Web.UI.HtmlTextWriterStyle.Width, "20px");
e.Row.Cells[0].Width = System.Web.UI.WebControls.Unit.Pixel(20);
}
and also
<asp:HyperLinkField ... ItemStyle-Width="20px" ControlStyle-Width="20px"/>
Thanks in advance,
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
-- modified at 17:18 Thursday 29th June, 2006
|
|
|
|
|
Hi Michael,
There are a couple of ways which you can try:
+ Use Atlas with your GridView control, you can keep using the TemplateField and simply place the GridView control inside the UpdatePanel to support client callback with paging and sorting.
+ Use the ButtonField with ButtonType="Image" :
<asp:ButtonField ItemStyle-Width="22px" ButtonType="Image" ImageUrl="..." />
+ Use the BoundField with adding the ImageButton to the column in the RowDataBound event handler:
<asp:BoundField ItemStyle-Width="22px" />
|
|
|
|
|
I ended up going with the Atlas:UpdatePanel.
Thanks!
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Hi all
I am trying to on mouseover display name and put it in session (IN HTML PAGE)
MYCODE
--------
shape=RECT coords=228,232,441,279 href=hs22.aspx>
------------------
Can any one tell me how can i put the value in session
THX
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
-- modified at 15:05 Thursday 29th June, 2006
|
|
|
|
|
You can't access the Session object from client script. You have to send the value to the server, so that the server code can put it in the session variable.
---
b { font-weight: normal; }
|
|
|
|
|
You may consider using AJAX to send a request to the server to persist the value in the Session object.
|
|
|
|
|
Hi,
I am Ravindra,currently doing a web application
consisting of :
1.Login.aspx
2.Mails.aspx
and other web forms
when I type the url : http\\localhost\Mails.aspx ,it is directly opening that web page
without displaying Login.aspx web page.
I want to restrict the mails.aspx page until the user logins with Login.aspx,
and also mails.aspx page is to be restricted even the user types the
url(http\\localhost\Mails.aspx)
please help me ,I am new to ASP.net.
ravindra donkada
|
|
|
|
|
Simple Forms Authentication
Basically, you need to configure forms authentication and set access rules on different pages or directories to tell the server which pages are registricted.
-- modified at 15:41 Thursday 29th June, 2006
LINK: Made link
|
|
|
|
|
Simply assign some value to a session variable in login Page say..
Session("login")="admin"
And on Mail.aspx page check
If Session("login")="" then
Response.redirect("login.aspx")
else
Your page code here
end if
Lets work it Out.........!
|
|
|
|
|
Hello,
I am using FormsAuthentication and Membership in ASP.NET 2.0 Applicaion. On Login page I have a link to page saying, Forgot password. On click of this link it should lead me to ForgotPassword.aspx page. The problem is, everytime I click on this link, system takes me back to Login page. To reach to that page I have to be logged in, which is not the requirement.
Had anyone have idea, how to mitigate this problem.
Thanks in advance.
- ashish
|
|
|
|
|
Move that page out of the protected area. Or use could use the admin tool to set the access rules on it, or you may be able to do it in Web.config in <location> tags, but I'm not sure if that will work with the Membership stuff.
|
|
|
|
|
Like eggsovereasy said, you can use the
location[^] tag to configure the authorization which allows all users to access this page. You can find the sample settings from the link.
|
|
|
|
|
I want to check whether gridview contain any row so that if grid view is empty i can print appropriate message.
Note that gridview1.rows.count doesn't work.
aLi
|
|
|
|