How to bind DataGridView with Connected and Dis Connected Mode in Ado.Net

How to bind DataGridView with Connected and Dis Connected  Mode in Ado.Net Problem : when you bind the GridView in Asp.Net with SqlDataReader dr Its binds with GridView but it doesnot happens in with DataGridView in Windows Application.Now the solution of this problem is given below…. Create table ContactDetails for binding DataGridView……………………………………. create table ContactDetails(SrNo int identity(1,1) primary key,Name nvarchar(50)...

Read More

What is Coalesce Function in Sql Server? How it is comfortable with Optional Search

What is Coalesce Function in Sql Server? How it is comfortable with Optional Search The COALESCE function present in SQL .It use to returns the first non-NULL expression among its arguments. The syntax for COALESCE function is as follows   Select * from "table name" where   WHEN "expression 1 is not NULL" THEN "expression 1"   WHEN "expression 2 is not NULL" THEN "expression 2"   ...   [ELSE "NULL"]   END Create...

Read More

How to create Optional search using coalesce Function in Asp.net

How to create Optional search in ADO.NET with Store Procedure in Asp.net with   coalesce Function in Sql Server --create database sqltopquery use sqltopquery --create table MyFriendList in database sqltopquery create table MyFriendList(SrNo int identity(1,1) primary key,Name nvarchar(50),Emailid nvarchar(50) unique ,MobileNo nvarchar(50)unique,Address nvarchar(50),Course nvarchar(50)) --insert  into table insert into MyFriendList...

Read More