|
iam having the table log table
the fields are userid, logintime,logouttime,totaltimespend
when ever user login or logout he should be updated in database using triggers in sql server 2005 and using asp.net with c# and get the total hours he spend.
|
|
|
|
|
Totaltimespent is a useless column since you have logon and logout times.
I'm not sure I see your question
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
As Mark said, you probably don't need the "totaltimespend" field. Keeping track of login & logout time should suffice.
I may be wrong on this, but triggers aren't the way to go for keeping a log table like this. Personally, I would update the "logintime" via my c# code when the user successfully logs in.
For logouttime, there's an event in your Global.asax file called "Session_End". Within there, simply open a connection to your log table and update logouttime.
Hope that helps.
-Goalie35
|
|
|
|
|
hi,
i want to use charts in crystal reports ,based on the values it should generate graphs.. using asp.net with c#
|
|
|
|
|
there are default different knid of graphs available in .Net itself, after generating the report just click the icon related to graph it will take you to what u want
|
|
|
|
|
Hi All
is it possible to click a button on a web user control and have it retain the focus of the current control on the webform ?
I am trying to integrate the cool TCKeypad Numeric Keypad Web User Control[^] into a webform and want the output of the button to go to the current control of a textbox on my webform rather than the built in textbox of the control.
Any ideas or suggestions would be appreciated
Cheers
Dom
|
|
|
|
|
Have you tried leaving a message for the author of the control - if anyone would know he would.Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
Hello, this is Vikash gohil.
I have created a Activex Control in VB6.0
I have also created the CAB File to deploy this control.
Now I do not know where to place the CAB file, ie in which folder.
Should i put it in Bin folder or the same folder in which the aspx page that uses the control exists.
Also do i need to put the CAB file and the support folder both or just the CAB file.
Please anyone can help me in this matter.
this is my first web deployment, any help would be greatly appreciated.
awaiting your response.
|
|
|
|
|
Hi guys!
I am working as a web developer. In one of my web aspplication in asp.net I am facing problem.
my aspx page will contains following html tags
<asp:FormView ID="fvwTenderProposal" runat="server" ....>
<EditItemTemplate>
<ajaxToolkit:TabContainer ID="tabContainer1" runat="server">
<ajaxToolkit:TabPanel ID="tabPanel1" runat="server" Header="Tab1">
<ContentTemplate>
<asp:TextBox id="txtBox1" runat="server"></asp:TextBox>
</ContentTemplate>
</ajaxToolkit:TabPanel>
<ajaxToolkit:TabPanel ID="tabPanel2" runat="server" HeaderText="Tab2">
<ContentTemplate>
<asp:TextBox id="txtBox2" runat="server"></asp:TextBox>
</ContentTemplate>
</ajaxToolkit:TabPanel>
</ajaxToolkit:TabContainer>
</EditItemTemplate>
</asp:FormView>
As I am disabling the controls inside ajax tab container->tabpanel which is then again contains into the Form view control.
So there are two controls outside ajax tab container TextBox3 & Button1. But these are contains into the formview.
So when I am enter date(or any text) into the TextBox3, then controls inside the current opened tab get disabled using client script as follows
<script type=”text/javascrpt”>
function disabledTabControls()
{
var objCtlTabPanel1 = $get('<%= fvwTenderProposal.FindControl("tabContainer1").ClientID %>' + "_tabPanel1");
var objCtlTabPanel2 = $get('<%= fvwTenderProposal.FindControl("tabContainer1").ClientID %>' + "_tabPanel2");
var objTxtBox1 = $get('<%= fvwTenderProposal.FindControl("tabContainer1").ClientID %>' + "_tabPanel1_txtBox1");
/* there are many controls within the tab panel which want to make enable false. So that user can not edit it.*/
objTxtBox1.disabled = false;
}
</script>
After that when user click on Button1, then I want to get tabpanels controls data and save it into database as follows
protected void Button1_OnClick(object sender, EventArgs e)
{
AjaxControlToolkit.TabContainer tabContainer1 = fvwTenderProposal.FindControl("tabContainer1") as AjaxControlToolkit.TabContainer;
if (tabContainer1 != null)
{
// For current tab panel
AjaxControlToolkit.TabPanel tabPanel1 = tabContainer1.FindControl("tabPanel1") as AjaxControlToolkit.TabPanel;
if (tabPanel1 != null)
{
TextBox txtBox1= tabPanel1.FindControl("txtBox1") as TextBox;
if (txtBox1!= null)
{
string strTextBox1 = txtBox1.Text;/* Here I am not getting data;
Instead if I do not call any client script like ‘disabledTabControls()’ for
disabling controls, then here I am getting data properly.
So here I am facing problem. */
}
}
}
/* code for save ‘strTextBox1, etc’ into database */
}
Hope you understand my problem and let me suggest some solution.
Regards,
Rakesh
|
|
|
|
|
|
no, you cant run asp.net website without dotnet framework and IIS.
|
|
|
|
|
since .NET applications aren't really suppose to run in a linux enviroment, it's not easy, but it can be done.
I'd suggest to take a look at this
;http://www.mono-project.com/Main_Page[^]
With this you can develop in windows using ASP.NET, and you can run compile and run in linux.
Sorry for not giving you an easy answer, but the solution isn't easy 
|
|
|
|
|
Thanks guys that's helpful
|
|
|
|
|
i have 2 table
first is
pk client_fk provider_fk
1 1 2
2 3 2
3 4 5
second is
organization
pk name
1 a
2 b
3 c
4 d
5 e
i watn output like
client name provider name
a b
c b
d e
Thanks and regards,
Amit Patel
|
|
|
|
|
select client.name ,provider.name
from organization as client, organization as provider, firsttable ft
where ft.client_fk=client.pk and ft.provider_fk=provider.pk
|
|
|
|
|
select a.Name, b.Name
from Client a inner join Organization b on a.Client_FK = b.PK Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
this is not giving desired result
|
|
|
|
|
If the description of the tables structures you have given is correct then it should work.
Does it simply return nothing or does it error?
If nothing, then do matching records actually exist?
If an error what is the error?Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
Hello guys,
I am developing an application for deploy on a hosting server. The app is data-driven. I want to know which option is the best, maintenable, secured...
Should I just add an SQL Database to the App_Data folder or create the database on my development machine?
Which ever method you suggest, plz tell me what is necessary to be done at the point of deployment.
Also which is better and (code-wise) secured option of deployment, Precompiled or XCopy?
Thanks in advance.Tunsten
|
|
|
|
|
hi selvamglobal, are u there? i hav a question for u that
in "Select-Move Rows From HTML Tables Using JavaScript
By nishant sagar"
you hav asked a question
hi , how can i use this code on ASP.NET GridView
cause with out effecting sorting and paging.because i tried this logic in grid view its working fine.but while i am doing sorting after moving rows up/down i am getting javascript error.
can you tell the approach.
thanx in advance.
in this i saw that u r successfull in doing this code in grid view.
can u share that code with me?
i'll be highly thankful 2 u
actually i only need moving rows of pone grid to another in javascript..........
plz share it with me.......
|
|
|
|
|
Hello,
I am generating a report from a web application written in .Net 1.1. The report is designed using html and no third party is involed for reporting. Now i wana save this page in pdf and want to send as an attachment. How to convert the report in to pdf format?????
Thanks,
Safvi
|
|
|
|
|
|
i am not converting word document to pdf. rather it is the html page that i want to convert in to PDF.
|
|
|
|
|
Well i have a user control with Save button
Inside the user controls i have dynamically added other user control
Now this inner user control shall have a row of radio buttons.On selecting the radio button a dropddown shall be populated with value based for that radio button.
On pressing save button , i need to find out which radio button and what value was selected in the dropdown of which user control.
How can i achieve that? Should i use a javascript handler for each of the radio buttons to populate a hidden variable?
|
|
|
|
|
you put those radiobuttons or drop down in a placeholder and on button click use placeholder1.findcontrol("controlname") to find the required control.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
