Information Technology,Software Programming

Asp.net,PL/SQL Tips Tricks for error resolution ,SQL version 2014,2012,2008,2005,Procedural language,Stored Procedure, computer , excel macro programming,Visual Studio,Musical notations,Indian ,Western Music Lyrics,Chords.

June 9, 2015

How to Reduce Microsoft Outlook Data file size

Sometime out Outlook Data file size become big and it's not getting decrease after deleting of lot of old mails then there is one option to decrease data file size of outlook.

You need to use compact option of outlook file. Below are step to do it.

1. Delete items that are old dated and not required.

2. Go to File tab->Account Settings-> Account Settings.

3. Go to Data Files tab, select the data file that for compacting purpose then you can  click Settings     then Click On Compact Now.

Outlook Express
Outlook Express
Outlook Express




May 28, 2015

Step Recorder feature of Windows 7

Do you know that you can record steps that you are using for your work on windows by using step recorder.

You need to just click on Start button then type step recorder in search box then you can open the step recorder.

Then click on start to start your task recording when you want to stop your step recorder just click on stop.

Then save as dialog box will be open you can save your file on selected location and file will be save in zip format.

Once file saved you can open that file in Internet explorer browser.

Its windows secret that I know most people do not know but it is very much helpful to make document for your task for future learning.
Step recorder command


Step Recorder




File will be save in MHT format which is MHTML format.

May 11, 2015

How to find distinct from number of list in string

How to find distinct from number of list in string in SQL

Distinct in sql




Solution:

SELECT LTRIM(H,',') OUTPUT
FROM
(SELECT sys_connect_by_path(K,',') H,
L val
FROM
(SELECT K,
ROW_NUMBER() OVER (ORDER BY K) L
FROM
(SELECT UNIQUE TO_NUMBER(REPLACE(SUBSTR(G,1,INSTR(G,',',1)),',','')) K
FROM
(SELECT B,
J,
A,
(LTRIM(SUBSTR(A,B,J),',')) G
FROM
( SELECT DISTINCT b,
LEAD(b)over (order by b ASC) j,
A
FROM
(SELECT instr(a,',',level)b,
A
FROM
(SELECT ('1,2,0,2,432,445,3,3,-1,10099,-2,0.32,0.3432,.3432,4,4,5,6,0.32,-2,432,32,21029,10099,3209839')
||',' a
FROM dual
)
CONNECT BY level <=LENGTH(A)+1
ORDER BY b
)
)
WHERE B<>J
ORDER BY B
)
ORDER BY 1
)
ORDER BY K
)
WHERE connect_by_isleaf=1
START WITH L =1
CONNECT BY L = prior L+1

);

April 16, 2015

Error "Can not load File or Assembly "xxxxx". Parameter is incorrect in Asp.net

If you are facing below error

Error "Can not load File or Assembly "xxxxxx". Parameter is incorrect in Asp.net

Error "Can not load File or Assembly "xxx". Parameter is incorrect in Asp.net









Solution is:

You can try out this cleaned up or delete files from below path

 C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary Files.

March 29, 2015

Asp code to call home page on logout button,reset password of user

Asp code to call home page on logout button

Make script code this way Put this code in vb-script tag

sub home()
document.frm.submit()
end sub


to call function on click event this way
onclick="home()"

Asp code to reset password of user

If you want to reset password or change password of particular user and you can login page then you can get hint or help to set this code in your form.

set con=server.CreateObject ("ADODB.CONNECTION")
set rs=server.CreateObject ("ADODB.RECORDSET")

con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database Path"

Response.Clear ()

set rs = con.Execute ("select * from logtable where Username='" & Request.Form ("logid") & "' and pwd = '" & Request.Form ("oldpassword") & "'" )

if rs.RecordCount <=0 then
 Response.Write "invalid password"
end if

if Request.Form("check1")="pwd" and Request.Form ("check2")<>"question" then
con.Execute ("Update logtable set pwd='" & Request.Form("newpassword") & "' where pwd='" & Request.Form("oldpassword") & "'")
Response.Redirect ("loginpage.asp")

elseif Request.Form("check2")="question" and Request.Form ("check1")<>"pwd" then
con.Execute ("Update logtable set Question='" & Request.Form("question") & "', Answer='" & Request.Form("Answer") & "' where pwd='" & Request.Form("oldpassword") & "'")
Response.Redirect ("loginpage.asp")

elseif Request.Form("check1")="pwd" and Request.Form ("check2")="question" then
con.Execute ("Update logtable set pwd='" & Request.Form("newpassword") & "', Question='" & Request.Form("question") & "', Answer='" & Request.Form("Answer") & "' where pwd='" & Request.Form("oldpassword") & "'")
Response.Redirect ("loginpage.asp")
end if