How to select all checkboxes in Datalist using Javascript in ASP.NET?

In this article I will explain how to select all records in Datalist using Javascript.

When we click “Select all” checkbox, all item will get selected. If we unselect one of record, then “Select all” checkbox will get unselected.

Read More

How to Check uncheck All checkboxes in Gridview using JavaScript in Asp.Net?

In this article I will explain how to check all check boxes in gridview using Javascript.

When we click on header check box then all checkboxes will be checked and if one of the checkbox is unchecked then Header will also be unchecked. If we check all checkboxes then Header checkbox  will automatically checked.

Read More

How to save Image in binary format in database in ASP.NET(using C#).

In this article I will explain how to save image to database in binary format.

Create a Table in database: “Image”

Image Saved in Binary Format:

click on Image to Enlarge it.

Read More

How to bind dropdwon and set default value in ASp.NET(C# & VB.NET)?

Introduction:

In this article I will explain how to bind dropdown list to database and how to set default value in dropdown list from code behind.

Read More

How to Fill or populate Datatable using stored procedure in Asp.Net (c#&vb.net)?

Introduction:

In this article I will learn how to fill or populate Datatable using Stored Procedure with data from database in asp.net. First of we will fetch data from Sql database using Stored Procedure then  fill data in Dataset using SqlDataAdapter.

Implementation: Follow following steps

Create a database i.e. “Test”.  Then create a table “Student_Info”.

Column Name	Datatype
Student_id	Int(Primary Key. So set Is Identity=True)
Student_Name	Varchar(500)
Age	int
Class	Varchar(50)

Now insert some data in this table using “insert” command.

Create Stored Procedure:

create proc Fill_DataTable

as

begin

select * from student_info

end

Create Connection: Now create connection in  webconfig file as given below.

<connectionStrings>

    <add name="con" connectionString="Data Source=localhost; Initial Catalog= Blog; Integrated Security=true;" providerName="System.Data.SqlClient"/>

  </connectionStrings>

ASP.NET code behind File using C#:

Add following Namespaces:

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

C# Code to get data and Fill Data Table:

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e) 

    {

        if (!IsPostBack)

        {

            Bind_datatable();

        }

    }

    //Fetch data from database and bind to gridview

public void    Bind_datatable ()

    {     

        if (con.State == ConnectionState.Open)

        {

            con.Close();

        }

        con.Open();

        DataTable dt = new DataTable ();

        SqlCommand cmd = new SqlCommand();

        cmd.Connection = con;

        cmd.CommandText = "Fill_ DataTable ";

        cmd.CommandType = CommandType.StoredProcedure;

    SqlDataAdapter dataadapater = new SqlDataAdapter();

    dataadapater.SelectCommand = cmd;

        dataadapater.Fill(dt);      

    }

VB.NET code:

Add following namespaces:

Imports System.Data

Imports System.Data.SqlClient

Imports System.Configuration

Now Write Following Code:

Private con As New SqlConnection(ConfigurationManager.ConnectionStrings("con").ConnectionString)

Protected Sub Page_Load(sender As Object, e As EventArgs)

    If Not IsPostBack Then

        Bind_datatable()

    End If

End Sub

'Fetch data from database and fill dataset

Public Sub  Bind_datatable ()

    If con.State = ConnectionState.Open Then

        con.Close()

    End If

    con.Open()

    Dim dt As New DataTable ()

    Dim cmd As New SqlCommand()

    cmd.Connection = con

    cmd.CommandText = "Fill_DataTable"

    cmd.CommandType = CommandType.StoredProcedure

    Dim dataadapater As New SqlDataAdapter()

    dataadapater.SelectCommand = cmd

    dataadapater.Fill(dt)

End Sub

Read More

Fill or populate dataset using stored procedure in asp.net (c# & vb.net).

Introduction:

In this article I will explain how to fill or populate dataset using Stored Procedure  in asp.net. First of we will fetch data from Sql database using Stored Procedure then  fill data in Dataset using SqlDataAdapter.

Implementation: Follow following steps

Create a database i.e. “Test”.  Then create a table “Student_Info”.

Column Name	Datatype
Student_id	Int(Primary Key. So set Is Identity=True)
Student_Name	Varchar(500)
Age	int
Class	Varchar(50)

Now insert some data in this table using “insert” command.

Create Stored Procedure:

create proc Fill_DataSet

as

begin

select * from student_info

end

Create Connection: Now create connection in  webconfig file as given below.

<connectionStrings>

    <add name="con" connectionString="Data Source=localhost; Initial Catalog= Blog; Integrated Security=true;" providerName="System.Data.SqlClient"/>

  </connectionStrings>

ASP.NET code behind File using C#:

Add following Namespaces:

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

C# Code to get data and Fill Data Table:

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e) 

    {

        if (!IsPostBack)

        {

            Fill_dataset();

        }

    }

    //Fetch data from database and bind to gridview

public void Fill_dataset()

    {     

        if (con.State == ConnectionState.Open)

        {

            con.Close();

        }

        con.Open();

        DataSet ds = new DataSet();

        SqlCommand cmd = new SqlCommand();

        cmd.Connection = con;

        cmd.CommandText = "Fill_Dataset";

        cmd.CommandType = CommandType.StoredProcedure;

    SqlDataAdapter dataadapater = new SqlDataAdapter();

    dataadapater.SelectCommand = cmd;

        dataadapater.Fill(ds);      

    }

VB.NET code:

Add following namespaces:

Imports System.Data

Imports System.Data.SqlClient

Imports System.Configuration

Now Write Following Code:

Private con As New SqlConnection(ConfigurationManager.ConnectionStrings("con").ConnectionString)

Protected Sub Page_Load(sender As Object, e As EventArgs)

    If Not IsPostBack Then

        Fill_dataset()

    End If

End Sub

'Fetch data from database and fill dataset

Public Sub Fill_dataset()

    If con.State = ConnectionState.Open Then

        con.Close()

    End If

    con.Open()

    Dim ds As New DataSet()

    Dim cmd As New SqlCommand()

    cmd.Connection = con

    cmd.CommandText = "Fill_Dataset"

    cmd.CommandType = CommandType.StoredProcedure

    Dim dataadapater As New SqlDataAdapter()

    dataadapater.SelectCommand = cmd

    dataadapater.Fill(ds)

End Sub

Read More

How to fill datatable with data from database in ASP.NET(c#&vb.net)

Introduction:

In this article I will explain how to bind or fill datatable in asp.net using C# and Vb.Net. In this article I have used sql query to fetch data from database and fill the datatable using SQLDataAdapter.

Implementation: Follow following steps

Create a database i.e. “Test”.  Then create a table “Student_Info”.

Column Name	Datatype
Student_id	Int(Primary Key. So set Is Identity=True)
Student_Name	Varchar(500)
Age	int
Class	Varchar(50)

Now insert some data in this table using “insert” command.

Create Connection: Now create connection in  webconfig file as given below.

<connectionStrings>

    <add name="con" connectionString="Data Source=localhost; Initial Catalog= Blog; Integrated Security=true;" providerName="System.Data.SqlClient"/>

  </connectionStrings>

ASP.NET code behind File using C#:

Add following Namespaces:

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

C# Code to get data and Fill Data Table:

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e) 

    {

        if (!IsPostBack)

        {

            Bind_datatable();

        }

    }

    //Fetch data from database and bind to gridview

    public void Bind_datatable()

    {     

        if (con.State == ConnectionState.Open)

        {

            con.Close();

        }

        con.Open();

        DataTable dt = new DataTable();

        SqlDataAdapter dataadapater = new SqlDataAdapter("Select * from student_info", con);

        dataadapater.Fill(dt);      

    }

VB.NET code:

Add following namespaces:

Imports System.Data

Imports System.Data.SqlClient

Imports System.Configuration

Now Write Following Code:

Private con As New SqlConnection(ConfigurationManager.ConnectionStrings("con").ConnectionString)

Protected Sub Page_Load(sender As Object, e As EventArgs)

    If Not IsPostBack Then

        Bind_datatable()

    End If

End Sub

'Fetch data from database and bind to gridview

Public Sub Bind_datatable()

    If con.State = ConnectionState.Open Then

        con.Close()

    End If

    con.Open()

    Dim dt As New DataTable()

    Dim dataadapater As New SqlDataAdapter("Select * from student_info", con)

    dataadapater.Fill(dt)

End Sub

Read More