Admin

Author's details

Date registered: June 28, 2016

Latest posts

  1. crystal report in asp.net — August 2, 2016
  2. how to filter dataset in asp.net using c# — April 3, 2014
  3. how to export data from sqlserver database to excel in asp.net c# — March 30, 2014
  4. How to convert mm-dd-yyyy to mm-yyyy in sql server — February 22, 2014
  5. custom button in c# .net — December 7, 2013

Most commented posts

  1. how to create insert delete and update using stored procedure in asp.net — 19 comments
  2. validations in windows application in c#.net — 8 comments
  3. how to generate a random password and send to mail in asp.net — 6 comments
  4. Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed — 6 comments
  5. how to export data from sqlserver database to excel in asp.net c# — 6 comments

Author's posts listings

Aug 02

crystal report in asp.net

Hi, I this post i will explain how to create a simple crystal report. 1.Open VS studio 2.open a new window application. 3.Drag and drop a Crystal report viewer from the tools( under Reporting). 4.Place a button in the form. 5.Double click on button. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using …

Continue reading »

Apr 03

how to filter dataset in asp.net using c#

Hi, In this article I will explain you how to set filter in dataset while getting data from backend to frontend. Observe the below sqlserver database table , In this we can see the pincode column were it contain different values in pincode column Eg:I want to get only picode=524004 for that I can write …

Continue reading »

Mar 30

how to export data from sqlserver database to excel in asp.net c#

Hi, In this article I will explain you how to export data directly from sql server database table to excel, Assume there is some data in the sql server database as below: I will export this data into excel file to excel by using C#.net coding as below: 1.Add a new file TabletoExcel.aspx in the …

Continue reading »

Feb 22

How to convert mm-dd-yyyy to mm-yyyy in sql server

Hi,In this article I will going to explain you how to convert ‘MM-DD-yyyy’ to ‘MMM-yyyy’ Every developer will face problem while converting date-time, I am keeping query to convert Datetime Eg:  (’12/01/2013 AM 12:00:00′)  to (‘Dec – 2013′) Query: [code language=”sql”] SELECT LEFT(DATENAME(MONTH ,CONVERT(VARCHAR(10), ’12/01/2013 AM 12:00:00′,112)),3) +’ – ‘+ DATENAME(YEAR,CONVERT(VARCHAR(10), ’12/01/2013 AM 12:00:00’, 112)) …

Continue reading »

Dec 07

custom button in c# .net

Hi,In this article I will going to explain you about windows applications “Custom Button” Custom Button : which is looks like WPF button representation, it consists of some extra futures then ordinary windows button,  In this button we can place images and also we can do different  shapes . It works as windows application button …

Continue reading »

Nov 30

how to generate a random password and send to mail in asp.net

Hi,In this article I will explain you how to generate auto generated password and also how to send to generated password mails IDS –> In this application I used GMAIL Credentials to send mails ,use your own maild SMPTS to send mails –> GMAIL  SMTP = smtp.gmail.com –> GMAIL PORT =587 –> Add using System.Net.Mail; …

Continue reading »

Nov 23

Insert Data in DataBase Using JQuery in ASP.NET

Hi,In this Article I will explain you how to Insert data into SQLServer using JQuery with  ASP.NET If u want to insert so many columns then it’s so much of time to insert, to overcome this problem use JQuery  its very fast while executing,I will show you with example. Add a New WebForm “JQuery.aspx” –>Copy …

Continue reading »

Oct 27

how to alter a column data type which is a primary key in the table

Hi, In this article I will explain you how to alter a column data type which is a primary key in the table –>We can’t alter the primary key column data type directly by using query –>To do that we have to delete the primary key first and then we have to alter the column …

Continue reading »

Oct 27

where are windows 7 wallpapers stored in system

Question:where are windows 7 wallpapers stored in system?? This a very common question in everyone’s mind for those who use windows7. ->Check this locations for  those pics c:windowswebwallpaper C:WindowsGlobalizationMCT –Admin.

Oct 25

how to get second highest salary in sql

Hi, In this article I will explain you a common interview question Question : How you will get second highest salary from  Employee table Ans:  Just simply Explain this below query and Scenario Below Image shows you Employee table data Execute below query: [code language=”sql”] SELECT MAX(EmployeeSalary) AS SecondHighestSalary FROM Tbl_Mst_Employee WHERE  EmployeeSalary < (SELECT …

Continue reading »

Older posts «