Hi,
I want to get Indian Standard Time (IST) in Sql Server 2005. How can I achieve this?
Note:
SELECT 'SYSDATETIMEOFF SET', SYSDATETIMEOFFS ET() this query works fine in Sql server 2008. Is there any option in Sql Server 2005?
Thanks in Advance
visweswaran2830
Last Activity: Jan 11 '12, 06:49 AM
Joined: Nov 3 '09
Location:
-
How to Get Indian Standard Time in Sql server 2005
-
How to get username from OpenId
Hi,
I have used google authentication for my asp.net application using dotnetopenauth. dll . I want to get username of authenticated user. I want to validate through my organizational gmail account. How can I achieve this.
Thanks in advance. -
Set selected value in datagridview combobox column
Hi,
I am having datagridview in that I have datagridview combobox column and noraml textfield. I want to know that how can I load selected value in that combox box when I am loading all entered details in data grid view.Last edited by Niheel; Apr 21 '11, 05:06 PM. -
How to create pdf using ms reportviewer?
Hi,
I want to know how to generate pdf file with help of ms report viewer. I will pass needed parameter to that reportviewer that should generate pdf, it should be done at back side user should not know this(invisible mode).
Thanks in advance -
Set session Timeout and Auto Redirect
Hi,
I am creating web application. In that I want to set session timeout (not idle timeout). If a user logged in that time the session time will start and it automatically should detect session timeout the page should redirect to another page. How can I acheive this. -
Configuration Error in asp.net
Hi,
I did one web-site in asp.net. I have published and I checked in IIS everything works fine. But When I upload into my web domain. I am getting following error.
Error:
Section or group name 'system.web.ext ensions' is already defined. Updates to this may only occur at the configuration level where it is defined
[imgnothumb]http://bytes.com/attachments/attachment/3929d1284731050/error.jpg[/im... -
Append Fields in SQL
Hi,
Consider, that I have 5 fields, In which first four fields has same value and fifth one has different value. If I retrieve these records from table it should shows first 4 fields only once and fifth fields should be appended. How can I achieve.
Eg:
field #1 field #2 field #3 field #4 field #5
101 VV BLR HOME 12K
101 VV BLR HOME 15K
... -
How to textbox value from datagrid header template
Hi,
I have datagrid control. In that I place textbox, insert link button in hearder template. When I click that Insert button the value from textbox should be loaded into grid. I am capturing at rowcommand()
here the code:
...Code:If e.CommandName = "Insert" Then Dim t1 As TextBox t1 = CType(e.Item.FindControl("phasetxt"), TextBox) Dim t2 As TextBoxLast edited by Frinavale; Aug 16 '10, 06:52 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags. -
How to insert table inside datagrid
Hi,
I am having datagrid in that I have one column that should have table. Now I want to know that how can I include table in datagrid. My table values may differ from each rows in datagrid. So that also should be accomplished. -
how to execute stored procedure in SQuirrel
Hi,
I am using SQuirrel. Now I want to execute stored procedure in SQuirrel. How can I achieve this.
Thanks in Advance -
How to get consecutive record number in two select statement
Hi,
...Code:select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_nature,b.inv_total,c.bal_amount,b.client_code,b.amt_received from fn_receipt a, trn_invoice_history b, mst_expenditureinvoice c where a.client_id=b.client_code and a.client_name=b.client_name and a.location=b.client_location and a.receiptno=35 and b.fully_recived not in ('Y') and b.amt_balance>0 and (c.fyear_code=b.fyear_code and b.inv_no=c.inv_no) -
Get DataGrid values in asp.net
Hi,
I am using DataGrid, Now I want to know to get all values from that Datagrid. How can I acheive.
Thanks in Advance,
Visweswaran V -
Error Exception Code: 405 in Aspx
Hi,
I am using updatepanel in aspx with master page content, required validation control. IN that updatepanel I have one datagrid through that I am trying to insert a row. When I click that linkbutton then is shows error like "sys.webforms.p agerequestmanag erparsererrorex ception. Error code: 405" . I tried with another project this code works fine. How to overcome this. Some times error code 12031 also appear in prompt... -
How to redirect from global.aspx
Hi,
I want to redirect from global.aspx to another page. How can I achieve this. I tried with following steps, but no effects on this.
1) Response.Redire ct("~/login.aspx")
2) Me.Context.Resp onse.Write("win dow.parent.loca tion.href='logi n.aspx';")
3) Context.Respons e.Redirect((Dir ectCast(Context .Handler,System .Web.UI.Control )).ResolveUrl(&q... -
Thanks for response.
Actually I am using cookies. My main objective is to redirect the user to login page, if the user idles around 20 minutes. -
How to get time of last request in asp.net
Hi,
How can I get time of last request Sent in asp.net.. Actually I want to set automatic Idle timeout. So I planned to compare this time with current. Please Help me. Other solutions are also invited..
Thanks in Advance. -
Thanks for your response. Could you give me some idea little bit more. Since I am new to this concept.Leave a comment:
-
Close session when users idle
Hi,
I want to know, how to close a session when a user is idle (around 'n' time) in asp.net. -
How to view document in asp.net
Hi,
I want to know, how to view documents(doc,d ocx,pdf) in asp.net (online itself).. -
How to get current online users list
Hi,
I need to know to get current online user list. How can I achieve. I am using membership concepts that is asp login control.
No activity results to display
Leave a comment: