LOKESH MSBI: 05/27/14

Stylish Jquery Notification in the ASP.Net C#

By:LOKESH . at 11:03 PM Labels: Jquery

Step 1:-Download the jquery_notification.css file from the below url

https://code.google.com/p/pccirebonnews/downloads/list?can=2&q=jquery_notification.css&colspec=Filename+Summary+Uploaded+ReleaseDate+Size+DownloadCount

Note:-After downloading the CSS file You have to modify the image locations in that CSS file

Step 2:- Download or copy this file to .js file from this url

jquery_v_1.4.js

https://jquery-in-place-editor.googlecode.com/svn-history/r162/trunk/spec/support/jquery-1.4.4.js

Step 3:- Download this file from the below url jquery_notification_v.1.js

https://code.google.com/p/pccirebonnews/downloads/detail?name=jquery_notification_v.1.js&can=2&q=

Add this codes in the asp page

function showSuccessMessage() {

showNotification({

type: "success",

message: "This is a sample success notification"

});

}

</script>

</head>

<body>

<div>

</div>

</body>

</html>

Run and check

SSRS report error while using in asp.net (The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded)

By:LOKESH . at 4:54 AM Labels: Reports, SSRS

Error 1 The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded.

RDLC File Employee.rdlc

Steps to solving this error

Step 1:- Remove or Delete all Shared Data Sets in the SSRS reports (Share datasets is the 2010 format that will work with visual studio 2012 only)

Step 2:- Converting the share dataset to local datasets

Step 3:- Right Click the Employee.rdl FileàView Codeà

On the top report tag u have to update

Previous

After

Replace 2010 with 2008 in the above code

Step 4:- Ctrl+ Find for “ReportSections” and remove the tags in that code

</ReportSections>

</ReportSection>

Step 5:- Run the code and check

For any clarifications or queries please don’t hesitate to call or Email

Phone :- + 91-9492179390

Email :- lannam@technobrainltd.com (or) lokeshtec@gmail.com

How to checking the NLL value for the integer in ASP.Net c#

By:LOKESH . at 4:16 AM Labels: ASP.NET C#

Step 1:- First write code in the button click like this

int value = null;

it will show error because normally not possible to assign null value to the int

Step 2:- By using “?” we can able to assign the null values to the integer like

int? value = null;

for checking this process using the brake point the code and checking one by one code line

if (value.HasValue == true)

{

Console.WriteLine("True");

}

Step 3:-

When value.HasValue calls it will default false

Then we assign value to the integer

int? value = 1;

then automatically value.HasValue returns “True”

Full Code:-

int? value = null;

Console.WriteLine(value.HasValue);

Output: FALSE

Value=1;

Console.WriteLine(value.HasValue);

Output: TRUE

For any clarifications or queries please don’t hesitate to call or Email

Phone :- + 91-9492179390

Email :- lannam@technobrainltd.com (or) lokeshtec@gmail.com

SQL SERVER ALL DATE CONVERTION FOR SIMPLE UNDERSTANDING

By:LOKESH . at 4:15 AM Labels: SQL

All Date Convertion For Simple Understanding with output as discription name in SQL SERVER

Step 1:- Open sql empty editer copy the below code

select convert(varchar, getdate(), 1) as MonthDateYear

select convert(varchar, getdate(), 2) as YearMonthDate_With_Dot

select convert(varchar, getdate(), 3) as DateMonthYear

select convert(varchar, getdate(), 4) as DateMonthYear_With_Dot

select convert(varchar, getdate(), 5) as DateMonthYear_With_hyphen

select convert(varchar, getdate(), 6) as DateMonthNameYear_With_Space

select convert(varchar, getdate(), 7) as MonthNameDateYear_With_SingleComma

select convert(varchar, getdate(), 8) as Only_Time

select convert(varchar, getdate(), 9) as CompleteDate_With_Time

select convert(varchar, getdate(), 10) as MonthDateYear_With_hyphen

select convert(varchar, getdate(), 11) as YearMonthDate_With_Slash

select convert(varchar, getdate(), 14) as Complte_Time_With_Milliseconds

select convert(varchar, getdate(), 101) as MonthDateFullYear_With_Slash

select convert(varchar, getdate(), 102) as FullYearMonthDate_With_Dot

select convert(varchar, getdate(), 103) as DateMonthFullYear_With_Slash

select convert(varchar, getdate(), 104) as DateMonthFullYear_With_Dot

select convert(varchar, getdate(), 105) as DateMonthFullYear_With_hyphen

select convert(varchar, getdate(), 106) as DateMonthNameFullYear_With_Space

select convert(varchar, getdate(), 107) as MonthNameDateFullYear_With_SingleComma

select convert(varchar, getdate(), 110) as MonthDateFullYear_With_hyphen

select convert(varchar, getdate(), 111) as FullYearMonthdate_With_Slash

Step 2:- Execute the code

For any clarifications or queries please don’t hesitate to call or Email

Phone :- + 91-9492179390

Email :- lannam@technobrainltd.com (or) lokeshtec@gmail.com

Simple way to creating the SSRS reports (Very Basic & Very Easy)

By:LOKESH . at 2:38 AM Labels: Reports, SQL, SSRS

Very very simple steps with full of step by step screen shorts

Step 1:- Open Microsoft visual studio 2008

File à New Project àReport Server Projectà Name it as “SampleSSRSReport”

Empty solution explorer will display like

Step 2:-Right Click the shared data source àAdd New Data Source

Screen will display like

Click Edit button for configure the data base connection

Give all the required parameters

Make Shure check the check box Save mu password (Because wile accessing the report without save that password it will ask every time)

To check the connection successful click the Test connection button

If connected successfully message will show like

Step 3:- Creating the Report

Right Click the ReportsàAddàNew ItemàSelect Report TempleteàName it as Employee.rdl

Click Add empty report is created

Step 4:- Configure the data source

Go to right side click the Report Data

Configure the shared dataset to this report

Right click the Data sourceàAdd data Sourceà Follow the below screen below

Step 5:-

Now creating the DataSet for the Report binding

Data SetàAdd Data SetàFollow the screen bello for proper understanding

First of all I will show Query type with Text

Click OK

With Query Type Store procedure

Click ok

Right click the empty design

InsertàTable à

Mouse over on the table it will show like to bind the data set columns to the table

Like that configure the required fields

Configure the parameter as dropdown

Right click the parameter àParameter propertiesà Follow below screen

Create One more dataset for drop down

Click Preview button

That sol the simply creating the SSRS reports

For any clarifications or queries please don’t hesitate to call or Email

Phone :- + 91-9492179390

Email :- lannam@technobrainltd.com (or) lokeshtec@gmail.com

LOKESH MSBI

Pages

Tuesday, May 27, 2014

Stylish Jquery Notification in the ASP.Net C#

SSRS report error while using in asp.net (The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded)

How to checking the NLL value for the integer in ASP.Net c#

SQL SERVER ALL DATE CONVERTION FOR SIMPLE UNDERSTANDING

Simple way to creating the SSRS reports (Very Basic & Very Easy)