Html Data Table 

This Datatable is created dynamically Youre Solution In that Png & use Css For
Attractive youre datatable

<<Download My Blog Android Application On Youre Device>>
Click To Download
Download My Blog Android Application For Youre Device
keep reading youre blog

Ap Xml 8777 part 3rd

Ap Xml 8777 part 2nd

part 2 video of c# to Xml see this all video

Download Xml Full Demo.
Download and learn C# With Xml database:
From :Atul Pathrikar(8777)
Demo 1st:
Download C# With Xml Demo 1st

Demo 2nd:
Download C# With Xml Demo 2nd

Ap Xml 8777 part 1st

This Video Is Very hepful for Youre Reffrance

<<Download This Linq Document For Reffrance>>
<<Download Linq Notes>>

<< Store procedure Use  IN,NOT IN keyword>>
Create procedure SP_Demo777
(

@Country varchar(max)

)
as
select * from Tbl_Country where CountryName in(@Country) and CountryName=@Country
return

<<See Video>>

<< create view & Call in Store Procedure>>

See This Video

linq to Sql example Download Here:
https://drive.google.com/open?id=0B2RO2WvKFY-aQ3piTEZ0N1hyTFU

https://drive.google.com/open?id=0B2RO2WvKFY-aYkxpYzZzYWRMeUE

https://drive.google.com/open?id=0B2RO2WvKFY-aUjVaRTZpMnVzWW8

https://drive.google.com/open?id=0B2RO2WvKFY-abU1QWWxtdlUxZms


Banking asp Web Application Demo In Linq To Sql

LINQ to SQL is a component of the .NET Framework version 3.5 that provides a run-time infrastructure for managing relational data as objects. In LINQ to SQL, the data model of a relational database is mapped to an object model expressed in the programming language of the developer.

https://drive.google.com/open?id=0B2RO2WvKFY-aMlppNGJWdUMxRXM 

Defination Of Sql View:
===========================================================================
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
=========================================================================== 

example for create views
===========================================================================
CREATE view [dbo].[GetDATAforTimetable_Excel]
as
select t.TT_ID, staff.Person_Name,std.Std_Name,c.Course_Name,sub.Sub_Name,t.Batch_Year,
t.Start_Time,t.End_Time,t.Date,staff.Staff_ID,b.Branch_Id
 from Tbl_TimeTable t,Tbl_Subject sub,Tbl_Course c,Tbl_Stad std,Tbl_Staff staff,Tbl_Branch b
 where t.Course_ID=c.Course_ID and sub.Sub_ID=t.Sub_ID and std.Std_ID=t.Std_ID and
 staff.Staff_ID=t.Staff_ID and staff.Branch_Id=b.Branch_Id

GO
===========================================================================
this view also use in storeprocedre Creating by their Object,Alias

<< This example For Generating The Barcod for Seprate Product>>
<<Download This Demo >>
https://drive.google.com/open?id=0B2RO2WvKFY-aUVJrWG1XSDVQbFU

<< Copy the data 1 listbox To Another List Box >>
<<Download This Demo>>

https://drive.google.com/open?id=0B2RO2WvKFY-aYlp3eDFtQUZYTTA

if you need this project example , click to download
https://drive.google.com/open?id=0B2RO2WvKFY-ac1l0MkhaVzM2dlU

<<How to Create Insert Function >>
=====================================================|
Write this function In perticuller class
 public int Insert_State()
        {
            obj_Con.obj_con.Open();
            cmd = new SqlCommand("SP_State", obj_Con.obj_con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@StateID", StateID);
            cmd.Parameters.AddWithValue("@StateName", StateName);
            cmd.Parameters.AddWithValue("@Country", CountryID);
            cmd.Parameters.AddWithValue("@Status", "Insert");
            cmd.ExecuteNonQuery();
            obj_Con.obj_con.Close();
            return i;
        }

=======================================================

Sql Server,Linq Videos
https://www.youtube.com/watch?v=_AOLyLgOHak 
https://www.youtube.com/watch?v=dIeJPvAQZp4

https://www.youtube.com/watch?v=YzKc-Bk9vGs

http://saipathrikar.blogspot.in/
In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).

<<Free text search Storeprocedure>>
Cretae PROCEDURE [dbo].[Sp_FreetextSearchForSch_Email]
(

@Email_ID varchar(max)

)
as
select Email_ID from Tbl_Schedule  where Email_ID like '%'+@Email_ID+'%' return


<<All Multiple Operation In Single StoreProcedure>>
create procedure [dbo].[SP_Allinone]
(
@ID int,
@Name varchar(max),
@Add varchar(max),
@Status varchar(max)


)

as
begin
if @Status='Insert'
Begin
insert Tbl_Demo (ProductId,Productname,Price) values (@ID,@Name,@Add)
end
else if @Status='Update'
begin
Update Tbl_Demo set Productname=@Name,Price=@Add where ProductId=@ID
end
else if @Status='Delete'
begin
Delete from Tbl_Demo where ProductId=@ID
end
else if @Status='Select'
begin
Select * from Tbl_Demo where ProductId=@ID
end
end

This video is very helpfull for reffrance