Contributors

Jacksparow
View my complete profile
Powered by Blogger.
Showing posts with label Programming. Show all posts
Showing posts with label Programming. Show all posts
Monday, April 15, 2013

Crystal Reports RT Components

4:49 AM | Posted by Unknown | | Edit Post

 Crystal Reports Runtime Components
In Crystal Reports Basic for Visual Studio, you can use .msi files for both ClickOnce deployment and Windows Installer deployment. The .msi file contains the components that enable clients to view applications that use Crystal Reports. If you use the .msi file on the target machine, the Windows Installer provides the Crystal Reports runtime files that are required by a deployment project. The .msi files are included with the Crystal Reports Basic for Visual Studio installation.
The following are the .msi files used in Crystal Reports Basic for Visual Studio 2008.
Runtime
Location of MSI
Crystal Reports Basic for Visual Studio 2008 (x86)
C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5\CRRedist2008_x86.msi
Crystal Reports Basic for Visual Studio 2008 (x64)
C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5\CRRedist2008_x64.msi
Crystal Reports Basic for Visual Studio 2008 (IA64)
C:\Program Files\Microsoft Visual Studio 9.0\Crystal Reports\CRRedist\IA64\CRRedist2008_ia64.msi
NoteNote
ClickOnce deployment is not available for the IA64 platform.
Labels: , , , | 0 comments
Friday, April 5, 2013

Speech Input Box with HTML

12:46 AM | Posted by Unknown | | Edit Post
Do you want to accept inputs via voice? here is what you need to do.
working on Google Chrome browser
Put the following javascript in the head section of your html.
//adding speach recognition to an html text box 
//Start of speech
<script type="text/javascript">
function voiceInputOver(val){
     alert("Voice input is complete");
     alert("Your input is " + val);
}
</script>

and put the following line of code in the body section
<input onwebkitspeechchange="voiceInputOver(this.value)" x-webkit-speech />

//end of speech


Here is sample working code
<html>
<head>
<script type="text/javascript">
function voiceInputOver(val){
     alert("Voice input is complete");
     alert("Your input is " + val);
}
</script>

 </head>
<body>
<input onwebkitspeechchange="voiceInputOver(this.value)" x-webkit-speech />
</body>
</html>
Labels: , , | 9 comments
Thursday, March 28, 2013

Finding duplicates in table

6:52 AM | Posted by Unknown | | Edit Post
Finding Duplicates in a table wit SQL

Sometimes finding rows with some duplicate values in some column(s) may be necessary. Let's see how can we manage this thing.
SELECT [Column_Name], COUNT([Column_Name]) AS Number_of_Occurrences
FROM [Table_Name]
GROUP BY [Column_Name]
HAVING ( COUNT( [Column_Name] ) > 1 )

And the query to get all PKs ( primary keys ) for rows with duplicate [Column_Name]
SELECT [Primary_key_Column]
FROM [Table_Name]
WHERE [Column_Name] IN (
SELECT [Column_Name]
FROM [Table_Name]
GROUP BY [Column_Name]
HAVING ( COUNT([Column_Name]) > 1 ))

Let's see it with an example. Let's say we have a tale called  Students and the column we are working on is students first name.
So the above code will become


SELECT [First_Name], COUNT([First_Name]) AS Number_of_Occurrences
FROM [Students]
GROUP BY [First_Name]
HAVING ( COUNT( [First_Name] ) > 1 )
And the query to get all PKs ( primary keys ) for rows with duplicate [First_Name]:
SELECT [Student_ID]
FROM [Students]
WHERE [First_Name] IN (
SELECT [First_Name]
FROM [Table_Name]
GROUP BY [First_Name]
HAVING ( COUNT([First_Name]) > 1 ))
This is simple right? yes it is. :D


Labels: , , | 0 comments

Could not load file(assembly)

6:22 AM | Posted by Unknown | | Edit Post
Error:-
Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
Personal Note:- This occurred in my ASP.NET web application
Solution:- 
Delete all or related files inside the folder 
C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
Labels: , , | 0 comments
Sunday, March 24, 2013

Timed Redirection PHP

9:45 AM | Posted by Unknown | | Edit Post
How to redirect to a certain page after the some specific time.
Code
Syntax:- header("refresh:time; url=redirection page");

Example:- header( "refresh:3;url=index.php" );

If we put the above line of code to the very beginning of our page it will redirect to the index.php page after the time given.
Labels: , , | 0 comments

Popup alert in ASP.NET

9:38 AM | Posted by Unknown | | Edit Post
How to popup an Alert on Button Click from code behind in Asp.net 2.0?
You can try this out.
string script = "alert(\"Hello!\");";
    ScriptManager.RegisterStartupScript(this,this.GetType(),
                  "ServerControlScript", script, true);
 or 
 ScriptManager.RegisterStartupScript(this.GetType() , 
"alerts", "javascript:alert('Hello')", ,true);
Labels: , , | 0 comments
Subscribe to: Posts (Atom)

Archive

Recommend Us

Visitors