Wednesday, October 14, 2015

Play Youtube video using video url in Asp.net

Asp.Net , C#.Net
Play Youtube video using video url in Asp.net
In this article I am going to explain how to play YouTube video using video url in asp.net web application

Description:
In the previous articles I have explained How to fill Country, State and Citydropdown list using linq to sql and how to set the video autoplay and disablethe related video option.

I want to play the youtube video in asp.net application. To play the video the simply enter the particular youtube video url.

Implementation:
Add a webform to asp.net application. Add the below given HTML markup to webform.

HTML Markup:
<table>
   <tr>
   <td>Enter Youtube Video URL :</td>
   <td> <asp:TextBox ID="txturl" runat="server" Width="450px"></asp:TextBox></td>
   <td> <asp:Button ID="btnsubmit"
            runat="server" Text="Play"/></td>
   </tr>
   <tr>
   <td colspan="3" id="video" runat="server"></td>
   </tr>
   </table>

On button click write the below given code

Read more »
By at No comments:
Tags: , , ,

Wednesday, October 7, 2015

How to fill Country, State and City dropdown list using linq to sql

C#.Net , Linq
How to fill Country, State and City dropdown list using linq to sql
In this article I am going to explain how to fill Country, State and City dropdown list using linq to sql

Description:
In the previous article I have explained Youtube autoplay and disable relatedvideos and Asp.net Embed Youtube video

I want to populate the Country, State and City dropdownlist.

Implementation:
I have created three tables Tb_Country, Tb_State and Tb_City.
How to fill Country, State and City dropdown list using linq to sql

HTML Markup of webform:
Read more »
By at No comments:
Tags: , ,

Friday, October 2, 2015

Youtube: autoplay and disable related videos

Youtube ,
Youtube: autoplay and disable related videos
In this article today I am going to explain how to set the video autoplay and disable the related video option.

Description:
In the previous article I have explained Import MS Excel sheet records into Sqlserver database and change the text color in Image dynamically using asp.net.

I have embed a video https://www.youtube.com/watch?v=vOncd4pEErw in asp.net application. I want this video be auto play means when page load it start playing and want to hide the related video option.

Implementation:

To hide the related videos:
To embed the video go to Youtube video URL and scroll down. You see the share option below the video title, click on it.

Youtube: autoplay and disable related videos

There options are available Share, Embed and email. You have to choose the 2nd one (Embed), click on it. 
Youtube: autoplay and disable related videos

Below textbox you see option Show more, click on it and uncheck the “Show suggested videos when the video finishes” option.

Youtube: autoplay and disable related videos


You see an iframe code in textbox. Copy it and paste where you want to display the Youtube Video.
Read more »
By at No comments:
Tags:

Thursday, October 1, 2015

Asp.net: Embed Youtube video

Asp.Net , Youtube
Asp.net: Embed Youtube video
In this article today I am going to explain how to embed Youtube video in asp.net application

Description:
In the previous article I have explained Import MS Excel sheet records into Sqlserver database and change the text color in Image dynamically using asp.net.

I want to embed the https://www.youtube.com/watch?v=vOncd4pEErw video in asp.net application.

Implementation:
To embed the video go to Youtube video URL and scroll down. You see the share option below the video title, click on it.

Asp.net: Embed Youtube video

There options are available Share, Embed and email. You have to choose the 2nd one (Embed), click on it. You see an iframe code in textbox. Copy it and paste where you want to display the Youtube Video.
Asp.net: Embed Youtube video


Example:
Read more »
By at No comments:
Tags: ,

Friday, September 25, 2015

Asp.net: Import MS Excel sheet records into Sql server database

Asp.Net , Sql Server
Asp.net: Import MS Excel sheet records into Sql server database
In this tutorial I am going to explain how to import the MS Excel sheet records into Sql server database in asp.net

Description:
In the previous article I have explained change the text color in Image dynamically and Different ways to disable auto-fill in browser for a textbox.

I have a MS excel file which have records/details of employees. I want to import all records from excel file into database table.


Implementation:
I have a table in Tb_Employee
Read more »
By at No comments:
Tags: ,

Thursday, September 24, 2015

Asp.net: change the text color in Image dynamically

Asp.Net ,
Asp.net: change the text color in Image dynamically
In this article today I am going to explain how to change the text color in Image in Asp.net.

Description:
Asp.net: change the text color in Image dynamically

In the previous article I have explained Different ways to disable auto-fill inbrowser for a textbox and Insert multiple records (rows) into sql serverdatabase.

To change the text color in image I have use the transparent image. In this example I have keep the transparent image in images folder. On button click to change color I have create a new image and save to image folder.




Implementation:
HTML Markup:
  <table>
    <tr>
   <td colspan="2">
        <asp:Image ID="Image1" runat="server" ImageUrl="images/n.png" /></td>
    </tr>
    <tr>
    <td><asp:Button ID="Button1" runat="server" Text="Green" /></td><td><asp:Button ID="btnred"
            runat="server" Text="Red" /></td>
    </tr>
    </table>

Add the Namespace
Read more »
By at No comments:
Tags:

Sunday, September 20, 2015

Asp.net: Different ways to disable auto-fill in browser for a textbox

Asp.Net , C#.Net
Asp.net: Different ways to disable auto-fill in browser for a textbox
In this article I am going to explain different ways to disable auto-fill for a textbox in asp.net

Description:
In the previous article I have explained Insert multiple records (rows) into sqlserver database and Asp.net add multiple rows to Gridview dynamically.

All major browsers (Google chrome, Mozilla firefox, Safari and Internet explorer) has default functionality of auto complete the textboxes values means when user start to type value in textbox gets a dropdown like prefilled values in that particular textbox . We can disable the auto fill settings of browsers by uncheck the enable autofill option in browsers settings.

Asp.net: Different ways to disable auto-fill in browser for a textbox


Read more »
By at 1 comment:
Tags: , ,

Saturday, September 19, 2015

ASP.Net: Insert multiple records (rows) into sql server database

Asp.Net , C#.Net
ASP.Net: Insert multiple records (rows) into sql server database
In this article I am going to explain how to insert multiple records (rows) into sql server database using Asp.net

Description:
In the previous article I have explained Asp.net add multiple rows to Gridview dynamically and Fill Country, State and City dropdownlist.

I have created a table Tb_Movies and want to insert multiple records into it. 

ASP.Net: Insert multiple records (rows) into sql server database

User click on add new row button (user can add multiple rows to Gridview) it will add row to Gridview data control.
Read more »
By at 5 comments:
Tags: , , ,

Tuesday, September 15, 2015

Asp.net add multiple rows to Gridview dynamically

Asp.Net , C#.Net
Asp.net add multiple rows to Gridview dynamically
In this article I am going to explain how to add multiple rows to Gridview control dynamically in asp.net

Description:
In the previous article I have explained Fill Country, State and City dropdownlist and Top 20 Sql server Interview questions with answer on Select statement.

In this article I am going to add the multiple rows to Gridview on button click.

Implementation:
Method 1:
In this method when user clicks on button it continually added the row to Gridview control.

Read more »
By at No comments:
Tags: , , ,

Sunday, September 13, 2015

Asp.net: Fill Country, State and City dropdownlist

Asp.Net , C#.Net
Asp.net: Fill Country, State and City dropdownlist
In this article today I am going to explain How to populate the Country, State and City dropdownlist in asp.net

Description:
In the previous article I have explained Top 20 Sql server Interview questionswith answer on Select statement and ADO.Net entity framework CRUD functionusing store procedure in Gridview.

I want to populate the state dropdown on Country dropdown selection and city dropdown on state dropdown selection. I have created three tables.

Country:
Fill Country, State and City dropdownlist

State:
Fill Country, State and City dropdownlist
City:

Fill Country, State and City dropdownlist

Implementation:
Add a webform to project/website. drag and drop the required control from toolbox to webform.
Read more »
By at 3 comments:
Tags: , , ,

Friday, September 11, 2015

Top 20 Sql server Interview questions with answer on Select statement

Interview Question , Sql Server
Top 20 Sql server Interview questions with answer on Select statement
Sql server Select statement Interview question and answers

I have created a table name EMPLOYEE_INFORMATION.

EMPLOYEE_ID
int
EMPLOYEE_NAME
varchar(50)
EMPLOYEE_SALARY
int
EMPLOYEE_DEPARTMENT
varchar(50)

Table contain the below mention data as in snapshot: 



To Display all the Details from EMPLOYEE_INFORMATION:
SELECT * FROM dbo.EMPLOYEE_INFORMATION

To Display the information and manage in Descending order on Salary wise:
SELECT * FROM dbo.EMPLOYEE_INFORMATION ORDER BY EMPLOYEE_SALARY DESC

To Display the information and manage in Asecnding order on Salary wise:
SELECT * FROM dbo.EMPLOYEE_INFORMATION ORDER BY EMPLOYEE_SALARY ASC

To display the Employee name and Department from Table:
SELECT EMPLOYEE_NAME,EMPLOYEE_DEPARTMENT FROM dbo.EMPLOYEE_INFORMATION

To display Total Salary being paid to all Employee:
SELECT SUM(EMPLOYEE_SALARY) FROM dbo.EMPLOYEE_INFORMATION

To display Highest Salary being Paid to in Department(HR):
SELECT MAX(EMPLOYEE_SALARY) FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_DEPARTMENT='HR'

To display Lowest Salary being Paid to in Department(HR):
SELECT MIN(EMPLOYEE_SALARY) FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_DEPARTMENT='HR'

To display the Employee Name who works in WEB DEVELOPER Department:
SELECT EMPLOYEE_NAME FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_DEPARTMENT='WEB DEVELOPER'

To Display the Employee name who not works in WEB DEVELOPER Department:
SELECT EMPLOYEE_NAME FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_DEPARTMENT NOT IN ('WEB DEVELOPER')

To find the Highest Salary of Employee:
SELECT MAX(EMPLOYEE_SALARY) FROM dbo.EMPLOYEE_INFORMATION

To find the Minimum Salary of Employee:
SELECT MIN(EMPLOYEE_SALARY) FROM dbo.EMPLOYEE_INFORMATION

To Display the Employee Name and Salary between the Range:
SELECT EMPLOYEE_NAME,EMPLOYEE_SALARY FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_SALARY BETWEEN 7000 AND 9000

To Display top 5 Records of Table:
SELECT TOP 5 EMPLOYEE_SALARY FROM dbo.EMPLOYEE_INFORMATION

To Count the number of Rows:
SELECT COUNT(*) FROM dbo.EMPLOYEE_INFORMATION

To Find the Employee Name Starts with ALPHABET ‘V’:
SELECT * FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_NAME LIKE 'v%'

To Find the Employee Name where Second ALPHABET is ‘I’:
SELECT * FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_NAME LIKE '_I%'

To Find the Employee Name End with ALPHABET ‘Y’:
SELECT * FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_NAME LIKE '%Y'

To display Employee Name whose Salary is GRETAER than ‘9000’ and work in Department ‘WEB DEVELOPER’:
SELECT EMPLOYEE_NAME FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_DEPARTMENT='WEB DEVELOPER' AND EMPLOYEE_SALARY>9000

To display Employee Name whose Salary is LESS than 9000 and work in Department ‘WEB DEVELOPER’: 
SELECT EMPLOYEE_NAME FROM dbo.EMPLOYEE_INFORMATION WHERE EMPLOYEE_DEPARTMENT='WEB DEVELOPER' AND EMPLOYEE_SALARY<9000



Read more »
By at 2 comments:
Tags: ,

Thursday, September 10, 2015

ADO.Net entity framework CRUD function using store procedure in Gridview

Asp.Net , C#.Net
ADO.Net entity framework CRUD function using store procedure in Gridview
In this article I am going to share how we can do CRUD (Create, Read, Update and Delete) operations in Gridview using ADO.Net Entity Framework

Description:
In the previous article I have explained Sql server Local vs. Global temporarytable, Asp.net Select, Edit, Update and Delete record in Gridview using EntityFramework and How to set up ADO.net Entity Framework project or website inasp.net.

Create a table movie. I am going to insert, edit, update and delete the record into table using  Gridview.
ADO.Net entity framework CRUD function using store procedure in Gridview


Implementation:
First of all create store procedure to Insert, update, Select and delete the record.
Read more »
By at 2 comments:
Tags: , , , ,

Monday, September 7, 2015

Sql server: Local vs. Global temporary table

Interview Question , Sql Server
Sql server: Local vs. Global temporary table
In this article today I am going to explain the difference between Local and Global Temporary table in sql server

Description:
Temporary tables are created at runtime and we can do all operation which we can do on a normal table. Temporary tables are stored in System Databases >> tempdb database.
Temporary tables are of two types:
1. Local Temporary tables
2. Global Temporary tables
Read more »
By at No comments:
Tags: ,

Sunday, September 6, 2015

Asp.net Select, Edit, Update and Delete record in Gridview using Entity Framework

Asp.Net , C#.Net
Asp.net Select, Edit, Update and Delete record in Gridview using Entity Framework
In this article I am going to explain how to Edit, update and delete the record in Gridview data control using Entity Framework and Asp.net

Description:
In the previous article I have explained Asp.net Entity Framework Fetch recordsand display in Gridview, Insert record into Sql server database using StoreProcedure and Entity framework in asp.net and How to set upADO.net EntityFramework project or website in asp.net.

I have created a table Movie in database and inserted the records into it. Now I will fetch the records from this table and display them in Gridview data control and edit, update and delete the record.

Implementation:
To set up the ADO.net entity framework project read the article How to setupADO.net Entity Framework project or website in asp.net.

Add a webform to project/website.
Read more »
By at 1 comment:
Tags: , , , ,

Saturday, September 5, 2015

Asp.net Entity Framework Fetch records and display in Gridview

Asp.Net , C#.Net
Asp.net Entity Framework Fetch records and display in Gridview
In this article I am going to explain how to fetch the records from Sql server database and display in Gridview using Entity Framework in Asp.net

Description:
In the previous article I have explained How to insert record into Sql serverdatabase using Entity framework in asp.net,  How to set up ADO.net Entity Framework projector website in asp.net and Insert record into Sql server database using Store Procedure and Entityframework in asp.net.

In this tutorial select the records from Sql server database using database first approach. I have created a table Movie in database and having records in it. I am going to display the records in Gridview data control.

Implementation:
To set up the ADO.net entity framework project read the article How to set upADO.net Entity Framework project or website in asp.net.

Read more »
By at No comments:
Tags: , , , ,

Friday, September 4, 2015

Insert record into Sql server database using Store Procedure and Entity framework in asp.net

Asp.Net , C#.Net
Insert record into Sql server database using Store Procedure and Entity framework in asp.net
In this article I am going to explain how to insert record into Sql server database using Store Procedure and Entity framework in asp.net

Description:
In the previous article I have explained How to insert record into Sql server databaseusing Entity framework in asp.net,  Howto set up ADO.net Entity Framework project or website in asp.net, Search records from Sql Server database using Linq to Sql and How to show confirmation alert before closing browser tab using JavaScript.

Insert record into Sql server database using Store Procedure and Entity framework in asp.netIn this tutorial I will insert the record/data into sql server database using database first approach. I have created a table Movie in database.

Read more »
By at No comments:
Tags: , , ,

How to insert record into Sql server database using Entity framework in asp.net

C#.Net , Entity Framework
How to insert record into Sql server database using Entity framework in asp.net
In this article I am going to explain how to insert record into Sql server database using Entity framework in asp.net

Description:
In the previous article I have explained How to set up ADO.net Entity Frameworkproject or website in asp.net, Search records from Sql Server database usingLinq to Sql and How to show confirmation alert before closing browser tab usingJavaScript.

How to insert record into Sql server database using Entity framework in asp.netIn this tutorial I will insert the record/data into sql server database using database first approach. I have created a table Movie in database.




Read more »
By at No comments:
Tags: , ,

Tuesday, September 1, 2015

How to set up ADO.net Entity Framework project or website in asp.net

Asp.Net , Entity Framework
How to set up ADO.net Entity Framework project or website in asp.net
In this article I am going to explain how to set up a ADO.Net Entity Framework project or website in asp.net using Visual studio 2013

Description:
In the previous article I have explained How to show confirmation alert beforeclosing browser tab using JavaScript and Search records from Sql Serverdatabase using Linq to Sql.

In this tutorial I am going to set up a project/website using database first approach. I already created a database.

Implementation:
To set up an ADO.net project/website follow the below given steps:

Step 1: Create a website/project
First of all create a website or project.

Step 2:
Now right click on website in solution explore. Go to Add >> Add new item.

How to set up ADO.net Entity Framework project or website in asp.net


Read more »
By at No comments:
Tags: ,