|
I'm using asp.net and sql server, i have table loguser fields arelike this userid varchar(50)
tdate datetime
login datetime
logout datetime
timespend datetime
i want to findout between that how many hour he spend...
Ex:
Login Time: 11:50:39
Logout Time: 12:35:03
then again when he login Login Time:12:50:03
Logout Time: 2:35:03
i want to find out today how much hours he spend
and update the field timespend in database
|
|
|
|
|
This question better belongs to General database forum.
Since the database columns are of type DateTime, you will have the date as well. Now, use DateDiff function and find the difference between login and logout time. This would give the time spent. Make sure that the dates are for both login and logout. If the dates are different, then login time to midnight would be time spent today and midnight to logout time would be the time spent the next day.
|
|
|
|
|
Hi,
I think you can record the total timespend to db when he logs out: timespend =timespend + Logout Time - Login Time,
and you should check if the login is the first login of that day, if it is, set timespend = 0.
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:47am.
|
|
|
|
|
I'm using Cache file dependency in my code with CacheItemRemovedCallback function set. File dependency is on a xml file which is output of a Dataset.WriteXml. Below is the code in my CacheItemRemovedCallback method
<br />
public void RemovedCallback(String k, Object v, CacheItemRemovedReason r)<br />
{<br />
DataSet ds = new DataSet();<br />
ds.ReadXml(filePath);<br />
Cache.Insert("KeyName", ds, new CacheDependency(filePath), DateTime.Now.AddHours(1), TimeSpan.Zero, CacheItemPriority.High, OnRemove);<br />
}<br />
filePath points to the XML file which is output of ds.WriteXml.
When there is some update to the dataset I write the dataset using
ds.WriteXml(filepath, XmlWriteMode.WriteSchema);
On execution of above line, the call back methode RemovedCallback gets called. And as ds has not released the xml file yet, I get a error "...access denied as file is in use...".
Is there a way ds.WriteXml() method can release the file immediately after writing?
Else please suggest any alternate method ??
Thanx
s.a.w.
|
|
|
|
|
how to call panel1 multiple times on linkbutton click event in asp.net 2005
|
|
|
|
|
What do you mean by calling a panel?
|
|
|
|
|
use a loop and inside call the panel multiple times 
|
|
|
|
|
e.Row.Attributes.Add("onclick", "javascript:rowno(( e.Row.RowIndex);");
function rowno(rowindex)
{
here we want the correct index of row after moving rows
alert(rowindex);
i=rowindex;
}
function AddRow()
{
var gridview=document.getElementById("<%= gvPracticeFacility.ClientID %>");
var gridview1=document.getElementById("<%= gvPracticesAssignedFacilities.ClientID %>");
var tr = document.createElement("tr");
var cell1 = document.createElement("td");
var celln = document.createElement("td");
var cell2 = document.createElement("td");
var cell3 = document.createElement("td");
var cell4 = document.createElement("td");
var cell5 = document.createElement("td");
var cell6 = document.createElement("td");
var cell7 = document.createElement("td");
//var i =parseInt(document.getElementById("<%= hdnfldSelectedRow.ClientID %>").value);
cell1.innerHTML = gridview.rows[i].childNodes[0].innerHTML;
cell2.innerHTML = gridview.rows[i].childNodes[1].innerHTML;
cell3.innerHTML = gridview.rows[i].childNodes[2].innerHTML;
cell4.innerHTML = gridview.rows[i].childNodes[3].innerHTML;
cell5.innerHTML = gridview.rows[i].childNodes[4].innerHTML;
cell6.innerHTML = gridview.rows[i].childNodes[5].innerHTML;
cell7.innerHTML = gridview.rows[i].childNodes[6].innerHTML;
tr.appendChild(cell1);
tr.appendChild(cell2);
tr.appendChild(cell3);
tr.appendChild(cell4);
tr.appendChild(cell5);
tr.appendChild(cell6);
tr.appendChild(cell7);
gridview1.firstChild.appendChild(tr);
gridview.deleteRow(i);
}
<input id="Button1" type="button" runat="server" value="button" onclick="AddRow();" />
this code works in internet explorer but not works in ff......
|
|
|
|
|
|
Hi...
I am having a main menu called menu1. Its sub menus are submenu1, submenu2,submenu3.
I can write event for main menu click event as
ASP code:
<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal" ForeColor="white" BorderStyle="None"
Height="30px" onmenuitemclick="Menu1_MenuItemClick">
and c# code is:
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
Str = "sample";
}
Now how to write click event for submenu1?
any help will be appriciated....
thanks...G.Paulraj
|
|
|
|
|
|
|
Hi Abhijith,
Thanks for your reply...
My code is as follows. Please tell me how to create menu subitem on this...
<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal" ForeColor="white" BorderStyle="None"
Height="30px" onmenuitemclick="Menu1_MenuItemClick">
<DynamicHoverStyle ForeColor="#000000" BackColor="Black"/>
<Items>
<asp:MenuItem Text="File" Value="File">
<asp:MenuItem Text="Open" Value="Open" ToolTip="Open File"></asp:MenuItem>
<asp:MenuItem Text="Recent Files" Value="Recent"></asp:MenuItem>
<asp:MenuItem Text="Exit" Value="Exit"></asp:MenuItem>
</asp:MenuItem>
Thanks....G.Paulraj
|
|
|
|
|
You need to close <items> tag and <asp:menu> tag First.
Try This :
<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal" staticdisplaylevels="5" BorderStyle="None"
onmenuitemclick="Menu1_MenuItemClick">
<Items>
<asp:MenuItem Text="File" Value="File">
<asp:MenuItem Text="Open" Value="Open" ToolTip="Open File"></asp:MenuItem>
<asp:MenuItem Text="Recent Files" Value="Recent"></asp:MenuItem>
<asp:MenuItem Text="Exit" Value="Exit"></asp:MenuItem>
</asp:MenuItem>
</Items>
</asp:menu>
And In Code Behind :
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
Response.Write(e.Item.Text);
}
Here you will find on click of every menu items / subitems , Menu Text getting write on page.
Hope this will help you !
|
|
|
|
|
Ya... Its working fine...
Thanks...G.Paulraj
|
|
|
|
|
Welcome 
|
|
|
|
|
Hi,
I have developed a web application which need to be deployed in client location. Can any body tell me how i can package it, so that others cannot view the code. My application is having both asp and asp.net pages.
|
|
|
|
|
|
First thing that you need to it, Publish the code. Right Click on Solution > Publish Web Site. After Publishing the site, you will not find any .cs file in your published folder, all code will be converted in to dll only.
After than , you can create a Web Setup project which will work as Installer.
Please have a look into this,
http://www.beansoftware.com/ASP.NET-Tutorials/Deploy-ASP.NET.aspx[^]
This may help you. Let me know if you need more information.
Thanks !
|
|
|
|
|
public
void BindThumbnails()
{
DataSet ds = new DataSet();
ds = GetBinaryImagesByProfileID.FetchAllImagesInfo(intGetProfileID, "omegaloveConnectionString");
DLThumbnails.DataSource = ds;
DLThumbnails.DataBind();
}
Now when I come to the page on load I call the method BindThumbnails with a variable intGetProfileID
Will refresh the databind.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:omegaloveConnectionString %>"
SelectCommand="sprGetBinaryImages" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="ProfileID" Type="Int32" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
<asp:DataList ID="DLThumbnails" runat="server" RepeatDirection="Horizontal" CellPadding="3" DataKeyField="img_id"
HorizontalAlign="Center" CssClass="view" RepeatColumns="5" Item-BorderWidth="1"
Item-BorderColor="#c0c0c0" OnItemDataBound="DLThumbnails_ItemDataBound" OnItemCommand="DLThumbnails_ItemCommand"
BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
GridLines="Horizontal" ShowFooter="False" ShowHeader="False"
DataSourceID="SqlDataSource1">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<ItemStyle Width="20%" BackColor="#E7E7FF" ForeColor="#4A3C8C" BorderColor="silver"
BorderStyle="dotted" BorderWidth="3px" HorizontalAlign="Center" VerticalAlign="Bottom" />
<SelectedItemStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<FooterTemplate>
</FooterTemplate>
</asp:DataList>
How can I fix the above so I do not get the following error:
Both DataSource and DataSourceID are defined on 'DLThumbnails'. Remove one definition.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Both DataSource and DataSourceID are defined on 'DLThumbnails'. Remove one definition.
Source Error:
Line 82: ds = GetBinaryImagesByProfileID.FetchAllImagesInfo(intGetProfileID, "omegaloveConnectionString");
Line 83: DLThumbnails.DataSource = ds;
Line 84: DLThumbnails.DataBind();Line 85: //CountPhotos = Convert.ToInt32(ds.Tables[0].Rows[0]["NumberOfPhotos"].ToString());
|
|
|
|
|
You are getting this error because of DLThumbnails having two different dataSource. And the error message is saying the same thing.
If you check in codebehind,
macupryk wrote: void BindThumbnails()
{
DataSet ds = new DataSet();
ds = GetBinaryImagesByProfileID.FetchAllImagesInfo(intGetProfileID, "omegaloveConnectionString");
DLThumbnails.DataSource = ds;
DLThumbnails.DataBind();
}
You are giving data source of DLThumbnails as ds.
On the other hand, in aspx page, you have created one more SQLDataSource,
macupryk wrote: <asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:omegaloveConnectionString %>"
selectcommand="sprGetBinaryImages" selectcommandtype="StoredProcedure">
<selectparameters>
<asp:parameter name="ProfileID" type="Int32" defaultvalue="0">
and you have also assigned the same SQLDataSource as the DataSource of DLThumbnails. Which causes the confiliction error. You can remove any one them. Just Remove DataSourceID="SqlDataSource1" From Datalist aspx code. It will work 
Hope this will help you. Let me know if you need any more help.
Thanks !
|
|
|
|
|
I have a web control defined like
class SomeControl<T> : WebControl
...
How do I use it directly in an aspx page (= .aspx file), with the type specification?
In the code, it is easily
SomeControl<int> ctrl = new SomeControl<int>();
but in the aspx, I am clueless. Any ideas?
|
|
|
|
|
I didn't get your question.  Sorry ! Here you are creating the object of web user control, then how does this related with aspx page code. Can you please describe it in more details, so that I can help you.
Thanks!
|
|
|
|
|
Hello,
My application is in Asp.net1.1 hence the third party ABCpdf can be used in this project. Hence i created a webservice in Asp.net2.0. Upon test run, its working okay and creating the PDF document from a url and saving in one of the directory of my orignal application written in ASP.net1.1.
I created the proxy class using Wsdl.exe of vs2005 and added the class in the ASp.net1.1 application.Build is okay. no error. But this class in not refereced in the project. Hence i cannot invoke the method to save the webpage as PDF. How to reference the proxy class. Its object is not being created and the project is not recognizing. The rest of the ASp.net1.1 project is in VB.net but this proxy class in in C#.
What should i do.Every thing is working okay i just need to invoke the webservice from ASP.net1.1 project. Plz help.
Thanks,
Ali
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
