Showing posts with label C#. Show all posts
Showing posts with label C#. Show all posts

Filter data in datagridview in c#

In this article I will explain how to create filter by entering id or name in text box.

My out will be looks like this Now i am entering Empid and Empname





My solution looks like this


Write the code code in Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;


namespace IdSearch
{
    public partial class Form1 : Form
    {
        BindingSource bs = new BindingSource();
        public Form1()
        {
            InitializeComponent();
        }

        public void displayDataGridView()
        {

            using (SqlConnection con = new SqlConnection("Data Source = CHINNU;Initial Catalog = dotnetdb;Uid = sa;Password = password123;"))
            {
                SqlCommand cmd;
                cmd = new SqlCommand("select * from Employee", con);
                cmd.CommandType = CommandType.Text;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                dataGridView1.DataSource = ds.Tables[0];

                dataGridView1.AutoGenerateColumns = false;
                dataGridView1.AllowUserToAddRows = false;
            }

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            displayDataGridView();
        }

        private void txtfind_TextChanged(object sender, EventArgs e)
        {
            try
            {
            
                bs.DataSource = dataGridView1.DataSource;
          
               bs.Filter = string.Format("EmpId LIKE '%{0}%' OR [EmpName] LIKE '%{0}%'", txtfind.Text);
                dataGridView1.DataSource = bs;
            }
            catch (Exception ex)
            {
                
            }
        }

       
    }
}

how to display page number in rdlc report

In this Article I will explain how to show Page number in the footer .

                      
Drag the TextBox from the Toolbox,in the footer area of the Rdlc Report.
                            
Right click on the TextBox select Expression.
                        
Under Category select Bulit-in Fields,there we can generate the expression to display the total no of pages in the report.
Now I am adding this Expression in that expression window and Click Ok.

="Pages " & Globals!PageNumber & " OF " & Globals!TotalPages
           


Press F5.
Now we can See the Out Put:








how to bind data in combobox from database in c#

In this Article I will explain How to Bind data in Combobox from Database in c#


First I create a new solution in C# Winforms.

In the Form1.cs, I Designed like this
I designed the DB looks like  

After Completing the Steps my solution looks like this.
                              
Now I am adding the App.Config for DataBase connection.

    
  

Now I am Creating a Method for ComboBox1 name loadCountry,Dont forget to call the method in FormLoad.

Writing the code in Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace BindComboBox
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            loadCountry();
        }


        public void loadCountry()
        {
            DataTable dt = new DataTable();

            try
            {
                using (SqlConnection con = new SqlConnection("Data Source = testdb;Initial Catalog = ABC;Uid = sa;Password = PassWord123;"))
                {
                    using (SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM country", con))
                    {
                        adp.Fill(dt);
                       
                        comboBox1.DisplayMember = "Country"; 
                        comboBox1.ValueMember = "Id";  
                        comboBox1.DataSource = dt;
                        

                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}

Finally Out:



How to add No Data Found Message in RDLC Report

In this article I will explain How to add No Data Found Message in RDLC Report. If there is no data based upon selection .

We can also find Previous articles.



My Solution looks like this.

                            
Now double click on the Report1.rdlc

Rightclick on tht TextBox as shown below and select Tablix1
                 

Now we can find in Properties,No Row Messages.

                                   
We can enter any message to display,if no data found in the report selection.
                                        
Now save and Press F5.

We are able to see the Report with data

                             
Now I am selecting Today and Click on Generate Report
  


 So Finally there is no data found on today's date selection.

how to add header and footer in rdlc

In this Article I will explain how to add Header and Footer in RDLC Reports.



My solution Looks like this.




                        
Double Click on Report1.rdlc.

Right Click on that Report1.rdlc

Select Page Header and Page Footer
                  

It will shows like this,Now we are able to add our own Header and Footer.

           
Now I want to add Header Image and Footer Image

Right click on the Header area,Click on image

               
Click on import and select the image to display on header.

             
Same steps for footer also.

Finally it will show like this

Now Press F5 and see the Out Put with Header and Footer.









how to create rdlc report in c# windows application

how to create rdlc report in c# windows application


See my Previous Article for that Form1.I am designing my screen having,Combo Box, Two DateTimePicker and Button for Generating report.
How to Page number in rdlc reports
How to add no data found message in rdlc report
My Out Put looks like this,By default I will display All information.
If we select the combo box options and click on Generate Button,It will Show the Out Put Based on My Requirement




I Designed the Report Form UI looks like this.

                            

I  Design  database looks like this.



Now I am creating the stored procedure to generate reports based upon date selection.
See my Previous Article where we can select existing stored procedure.

USE [chinnu]
GO

/****** Object:  StoredProcedure [dbo].[SP_GenerateReport]    Script Date: 08/05/2013 04:15:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create procedure [dbo].[SP_GenerateReport]

(
@StartDate DateTime
,@EndDate DateTime  
)                                
as
BEGIN

 SELECT EmpId,Convert(varchar,CreatedDate,101) As CreatedDate ,EmpName,EmpAddress
    FROM Employee
    WHERE  Convert(varchar,CreatedDate,101) between  @StartDate and  @EndDate    
    
  
END
GO




Finally my solution looks like this.






   Now write the code in Form1.cs                                                                                                                                                                            

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace RdlcReports
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            ddlperiod.Items.Add("All");
            ddlperiod.Items.Add("Today");
            ddlperiod.Items.Add("Yesterday");
            ddlperiod.Text = "All";
            // TODO: This line of code loads data into the 'DataSet1.SP_GenerateReport' table. You can move, or remove it, as needed.
            //this.SP_GenerateReportTableAdapter.Fill(this.DataSet1.SP_GenerateReport);

            this.SP_GenerateReportBindingSource.DataSource = ReportData();
            ReportData();
            this.reportViewer1.RefreshReport();
        }

        public static DataTable ReportData()
        {
            DataTable DatTab = new DataTable();
            try
            {

                SqlConnection con = new SqlConnection("Data Source=DotNetSharePoint;Initial Catalog=chinnu;User ID=sa;Password = Admin1234;" );
          
                con.Open();
                if (true)
                {
                    con.Close();
                    SqlCommand cmd = new SqlCommand("SELECT EmpId,Convert(varchar,CreatedDate,101) As CreatedDate ,EmpName,EmpAddress FROM Employee", con);
    
                    //cmd.CommandType = CommandType.StoredProcedure;

                    SqlDataAdapter adap = new SqlDataAdapter(cmd);
                    adap.Fill(DatTab);

                }

                else
                {



                }
                con.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return DatTab;
        }

        private void btnReprt_Click(object sender, EventArgs e)
        {
           string  Fdate = ddlstartdate.Text;
           string Ldate = ddlenddate.Text;


             DataTable DatTab = new DataTable();
            SqlConnection con = new SqlConnection("Data Source=DotNetSharePoint;Initial Catalog=chinnu;User ID=sa;Password = Admin1234;");
            con.Open();
            if (ddlperiod.Text == "All")
            {
                SqlCommand cmd = new SqlCommand("SELECT EmpId,Convert(varchar,CreatedDate,101) As CreatedDate ,EmpName,EmpAddress FROM Employee", con);
               

                SqlDataAdapter adap = new SqlDataAdapter(cmd);
                adap.Fill(DatTab);
            }

            else
            {

                using (SqlCommand cmd = new SqlCommand("SP_GenerateReport", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("StartDate", SqlDbType.DateTime)).Value = Convert.ToDateTime(Fdate).ToShortDateString();
                    cmd.Parameters.Add(new SqlParameter("EndDate", SqlDbType.DateTime)).Value = Convert.ToDateTime(Ldate).ToShortDateString();
                    cmd.ExecuteNonQuery();
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    da.Fill(DatTab);
                }
            }

            con.Close();
            this.SP_GenerateReportBindingSource.DataSource = DatTab;
            this.reportViewer1.RefreshReport();

        }

        private void ddlperiod_SelectedIndexChanged(object sender, EventArgs e)
        {

            var toDate = DateTime.Now;
            var fromDate = DateTime.Today;

            switch (ddlperiod.Text)
            {
                case "Today": fromDate = toDate; break;
                case "Yesterday": fromDate = toDate.AddDays(-1); toDate = toDate.AddDays(-1); break;
            
                default: break;
            }

            ddlstartdate.Text = fromDate.ToShortDateString();
            ddlenddate.Text = toDate.ToShortDateString();

        }
    }
}





Now Add AppConfig for DataBase Connection.

        
    

After Completing the Steps,Press F5.


OutPut:



Now Select Today Date Click on Generate Report,It will shows today's Information





check if id exists in database c#

In this article I will explain how to check if Id already exists in DB.
Out Put Looks Like This.

I created a New Project in windows form using c#
Now in Form1.cs, I designed my UI

I created a table name Employee in my database.



Now i am creating the Stored Procedure for Inserting the data in database.                                                     
USE [dotnetdb]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsertEmpinfo]    Script Date: 07/23/2013 13:54:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create procedure [dbo].[SP_InsertEmpinfo]
(
@EmpId nvarchar(50),
@EmpName nvarchar(50),
@EmpAddress nvarchar(50),
@EmpDesignation nvarchar(50)
)

As Begin

Insert into Employee (EmpId,EmpName,EmpAddress,EmpDesignation) values (@EmpId,@EmpName,@EmpAddress,@EmpDesignation)
end

GO

Now i am writing the code on buttonclick in Form1.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CheckId
{
    public partial class Form1 : Form
    {
     public  string empid;
        
        public Form1()
        {
            InitializeComponent();
        }

        private void submit_Click(object sender, EventArgs e)
        {
            using (SqlConnection con = new SqlConnection("Data Source = CHINNU;Initial Catalog = dotnetdb;Uid = sa;Password = password123;"))
            {

                if (!empId())
                {
                }

                else
                {
                    SqlCommand cmd = new SqlCommand("SP_InsertEmpinfo", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@EmpId", SqlDbType.NVarChar).Value = txtempid.Text;
                    cmd.Parameters.Add("@EmpName", SqlDbType.NVarChar).Value = txtempname.Text;
                    cmd.Parameters.Add("@EmpAddress", SqlDbType.NVarChar).Value = txtempaddress.Text;
                    cmd.Parameters.Add("@EmpDesignation", SqlDbType.NVarChar).Value = txtdesignation.Text;
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }  
        }


        public bool empId()
        {

            using (SqlConnection con = new SqlConnection("Data Source = CHINNU;Initial Catalog = dotnetdb;Uid = sa;Password = password123;"))
            {
                con.Open();

                string query = "select EmpId from employee where EmpId= '" + txtempid.Text + "'";

                SqlCommand cmd = new SqlCommand(query, con);

                SqlDataReader dr;

                dr = cmd.ExecuteReader();

                while (dr.Read())
                {

                    empid = dr["EmpId"].ToString();

                    if (empid != "0")
                    {

                        MessageBox.Show("Id Already Exists");

                        return false;
                    }
                    con.Close();
                }


                return true;
            }
        }

                
    }
}


Now I am adding App.config for Connection.

    
  
Now Press F5.

Now I am Entering the employee information as shown below.

Now i inserted the employee information in my db,again i am trying to inserting the same information.

  It throws an error message like this.                                                                                                           
Output:                                                                                                                                                            



insert update delete edit in datagridview using c#

In this Article I will explain How to insert, update, edit, delete, clear using datagridview in C# from one Form to another Form.

We can see my Out Put looks like


In this example I am having Two Forms.



Now I am adding another form, Form2.cs and I designed my Form2.cs as shown below

After completion of UI design.
My Solution explorer looks as shown below.

I design my table with name Employee looks like this


For this table i written two stored procedures for Insert and update.

USE [dotnetdb]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsertEmpinfo]    Script Date: 07/21/2013 15:09:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create procedure [dbo].[SP_InsertEmpinfo]
(
@EmpId nvarchar(50),
@EmpName nvarchar(50),
@EmpAddress nvarchar(50),
@EmpDesignation nvarchar(50)
)

As Begin

Insert into Employee (EmpId,EmpName,EmpAddress,EmpDesignation) values (@EmpId,@EmpName,@EmpAddress,@EmpDesignation)
end

GO


USE [dotnetdb]
GO

/****** Object:  StoredProcedure [dbo].[SP_UpdateEmpInfo]    Script Date: 07/21/2013 15:09:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create procedure [dbo].[SP_UpdateEmpInfo]


(
@Empid nvarchar(50),
@EmpName nvarchar(50),

@EmpAddress nvarchar(50),
@EmpDesignation nvarchar(50)

)

As Begin


update Employee set EmpName = @EmpName,EmpAddress = @EmpAddress,EmpDesignation = @EmpDesignation where Empid = @Empid

End

GO

After Creating Stored Procedure, I Written the code for Insert,Update,Edit,Delete,Clear. In Form1.cs and Form2.cs.

Form2.cs Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace DatagridviewExample
{
    public partial class Form2 : Form
    {
        public static string Employeeid;

        SqlConnection con = new SqlConnection("Data Source = CHINNU;Initial Catalog = dotnetdb;Uid = sa;Password = password123;");

        public Form2()
            
        {

            if (Form1.empid != null)
            {

                Employeeid = Form1.empid;
            }
            InitializeComponent();
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(Form1.empid))
            {
                
                con.Open();
                SqlCommand Command = new SqlCommand("Select * from employee where EmpId='" + Employeeid + "'", con);
                SqlDataReader Reader = Command.ExecuteReader();
                if (Reader.HasRows)
                {
                    if (Reader.Read())
                    {
                        txtempid.Text = Reader.GetValue(0).ToString();
                        txtempid.Enabled = false;
                        
                        txtempname.Text = Reader.GetValue(1).ToString();
                        txtempaddress.Text = Reader.GetValue(2).ToString();

                        txtdesignation.Text = Reader.GetValue(3).ToString();
                  
                    }
                    con.Close();
                }

            }
        }

        private void submit_Click(object sender, EventArgs e)
        {

            string empupdateid = txtempid.Text;
            if (empupdateid != Employeeid)
            {
                SqlCommand cmd = new SqlCommand("SP_InsertEmpinfo", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@EmpId", SqlDbType.NVarChar).Value = txtempid.Text;
                cmd.Parameters.Add("@EmpName", SqlDbType.NVarChar).Value = txtempname.Text;
                cmd.Parameters.Add("@EmpAddress", SqlDbType.NVarChar).Value = txtempaddress.Text;
                cmd.Parameters.Add("@EmpDesignation", SqlDbType.NVarChar).Value = txtdesignation.Text;
                con.Open();
                cmd.ExecuteNonQuery();
                lblmessage.Text = "Data inserted";
                con.Close();
            }

            else
            {
                SqlCommand cmd = new SqlCommand("SP_UpdateEmpInfo", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@EmpId", SqlDbType.NVarChar).Value = txtempid.Text;
                cmd.Parameters.Add("@EmpName", SqlDbType.NVarChar).Value = txtempname.Text;
                cmd.Parameters.Add("@EmpAddress", SqlDbType.NVarChar).Value = txtempaddress.Text;
                cmd.Parameters.Add("@EmpDesignation", SqlDbType.NVarChar).Value = txtdesignation.Text;
                con.Open();
                cmd.ExecuteNonQuery();
                lblmessage.Text = "Data Updated";
                con.Close();


            }

        }

        private void btnReset_Click(object sender, EventArgs e)
        {

            txtempname.Text = "";
            txtempaddress.Text = "";
            txtdesignation.Text = "";
           
                lblmessage.Text = "Data Cleared";
            

        }




    }
}



Form1.cs having datagridview with Edit and Delete LinkButtons.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace DatagridviewExample
{


    public partial class Form1 : Form
    {
         SqlConnection con = new SqlConnection("Data Source = CHINNU;Initial Catalog = dotnetdb;Uid = sa;Password = password123;");
        public static string empid;

        public string emp
        {
            get { return empid; }
            set { empid = value; }

        }
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            displayDataGridView();

            DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
            Editlink.UseColumnTextForLinkValue = true;
            Editlink.HeaderText = "Edit";
            Editlink.DataPropertyName = "lnkColumn";
            Editlink.LinkBehavior = LinkBehavior.SystemDefault;
            Editlink.Text = "Edit";
            dataGridView1.Columns.Add(Editlink);

            DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
            Deletelink.UseColumnTextForLinkValue = true;
            Deletelink.HeaderText = "delete";
            Deletelink.DataPropertyName = "lnkColumn";
            Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
            Deletelink.Text = "Delete";
            dataGridView1.Columns.Add(Deletelink);

        }


        public void displayDataGridView()
        {


           
            
                SqlCommand cmd;
                cmd = new SqlCommand("select * from Employee", con);
                cmd.CommandType = CommandType.Text;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                dataGridView1.DataSource = ds.Tables[0];

                dataGridView1.AutoGenerateColumns = false;
                dataGridView1.AllowUserToAddRows = false;
                int i = 1;
                foreach (DataGridViewRow row in dataGridView1.Rows)
                {
                    row.Cells["SNO"].Value = i;
                    i++;
                }


            

        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == 5)
            {

            
                     empid = Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells["EmpId"].Value);
                Form2 fm2 = new Form2();
                fm2.Show();
                
            }

            if (e.ColumnIndex == 6)
            {
                empid = Convert.ToString(dataGridView1.Rows[e.RowIndex].Cells["EmpId"].Value);
                
                    SqlDataAdapter da = new SqlDataAdapter("delete from employee where EmpId = '"+empid+"'",con);
                    DataSet ds = new DataSet();
                    da.Fill(ds);
                  displayDataGridView();
                    dataGridView1.Refresh();
                
            }
        }
                 
        }
    }



App.Config:

    
  
After Completing all the steps Press F5.

OutPut:

Inserting the data with Label message.


The Data we inserted in Form2 it was displayed in Form1 as shown below.

Now if you want to Edit the Information,when we click on edit it shows form2.cs
I updated the EmpAdress from Us to America.

Now after Updating Form2 it will display Form1 with updated information.


Now if we click on delete the row will be deleted from the datagridview as well as from database as shown below in Datagridview.




how to add edit and delete buttons in datagridview in c#

In This Article I will Explain How to add Edit and Delete Button Links in DataGridView.

In My previous post ,DataGridview will looks like this.



Now  i want to add link buttons to datagridview by using  C#                                                                       

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace DatagridviewExample
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            displayDataGridView();

            DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
            Editlink.UseColumnTextForLinkValue = true;
            Editlink.HeaderText = "Edit";
            Editlink.DataPropertyName = "lnkColumn";
            Editlink.LinkBehavior = LinkBehavior.SystemDefault;
            Editlink.Text = "Edit";
            dataGridView1.Columns.Add(Editlink);

            DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
            Deletelink.UseColumnTextForLinkValue = true;
            Deletelink.HeaderText = "delete";
            Deletelink.DataPropertyName = "lnkColumn";
            Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
            Deletelink.Text = "Delete";
            dataGridView1.Columns.Add(Deletelink);

        }


        public void displayDataGridView()
        {


            SqlConnection con = new SqlConnection("Data Source = CHINNU;Initial Catalog = dotnetdb;Uid = sa;Password = password123;");
            {
                SqlCommand cmd;
                cmd = new SqlCommand("select * from Employee", con);
                cmd.CommandType = CommandType.Text;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                dataGridView1.DataSource = ds.Tables[0];

                dataGridView1.AutoGenerateColumns = false;
                dataGridView1.AllowUserToAddRows = false;
                int i = 1;
                foreach (DataGridViewRow row in dataGridView1.Rows)
                {
                    row.Cells["SNO"].Value = i;
                    i++;
                }


            }

        }
    }
}

OutPut:

How to create rdlc reports in c#


I Created a table in Sqldatabase as shown below. 
  










Now I am going to implement rdlc reports, using vs2010.

Create a new project 


Select the windows and select form give solution name as show below.
Click ok.


Right Click on the solution explorer select new item


Select the Dataset as shown below, Click on add.

After Clicking add It will displays  the Dataset like this

Right click on Dataset add TableAdapter


I will display TableAdapter Configuration Wizard.

Click on NewConnection .
Add connection window will display now.
Select the server name.
Select database name.
If we want test the connection,Click on test connection Click ok->ok.


Click Next


Click next.
Now we have to choose a command type.
I am doing with Sql select staments in this example.
Click next.


Select the Query builder as shown below



Select the table name, In my DB having only one table
Click on Add .






After adding Close the window.
In querybulider window i want to show all the colum’s information,so I selected all.
We can also test how the data will display but clicking the QueryBuilder and click Ok.
Click next.




Click next.


Click Next.and finally click finish.

Now,right click on solution explorer, click on add new item select the report wizard as shown below.


After clicking on add, report wizard window will display
Select the Data source name what we created in our solution.
Select available datasets.
Click on Next.



 In the arrange fields window,we have to drag all the fields as shown.





Click on next->next.


Click Finish.
We are able to see  .rdlc like this.






Now Click on Form1.cs,From Toolbox in Reporting drag the report viewer as shown below.


In the ReportViewer Tasks, select the Report.


After selecting, Press F5.

We can see output:



Labels

.Net Interview Questions add custom button in sharepoint using javascript Add custom column property into a PageLayout in SharePoint Add Page Title on their browser's title bar in SharePoint Customly add zip files in blogger Add-SPOSiteCollectionAppCatalog : Must have Manage Web Site permissions or be a tenant admin in order to add or remove sites from the site collection app catalog allow list Advance SmartObject An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL. Angular 2 Angular JS Angularjs Angularjs 1 anonymous users accessing lists and libraries App Permissions for SharePoint 2013 asp.net membership unique email Asp.net TreeView Control asp.net. Attendees in SharePoint Auto refresh list using Content Editor WebPart in SharePoint 2013. Auto Refresh SharePoint list using JavaScript Block and unblock of attachment types in SharePoint Blogger C# Callouts in SharePoint 2013 Cascading Dropdown list in SharePoint change onenote to another location. change SuiteBarLeft in SharePoint 2013 check if userid exists in database c# click node text to expand/collapse in Treeview client object model Close webpart CQWP crate chart using BI site in PPS Create a modern team site collection in SharePoint online Create BI chart in PPS SharePoint 2013 create filter in dashboard designer. create kpi's in dashboard designer create kpi's in SharePoint 2013 dashboard designer Create List Create List In SharePoint Create List using Power Shell Script Create Lookup Field in List using Power Shell Script Create lookup field in List create SharePoint List custom view. create SharePoint List views in List Schema create site collection in site collection in SharePoint using powershell created Date Time calculated field in SharePoint Cross site Collection in SharePoint 2013 Crud Operation in Asp.net Using Stored Procedure Custom MasterPage Approval in SharePoint custom view for survey list Customly add SharePoint List view in Page. delete items in sharepoint using powershell Difference between Angular 1.x & Angular 2 difference between Office 365 and Windows Azure difference between Windows Azure and Office 365 in sharepoint? DifferenceBetween discussion board Display Data in Grid View display radio buttons and choice fields horizontally in SharePoint 2013 Document library DotNet Drag and drop documents in document library in SharePoint dynamically populating values from one list to another list using jquery in sharepoint edit and delete buttons in datagridview Edit Links email notification using Nintex enable anonymous access in SharePoint 2013 enable app catalog sharepoint online site collection powershell Enable appcatalog site collection level using PowerShell based on Input file Enable versions for list and library except the hidden lists using PowerShell Script Error occurred in deployment step 'Recycle IIS Application Pool': Cannot resolve model for the project package Errors&Solutions Export document library in sharepoint using powershell Export particular Group in Term Store Management in SharePoint 2013 Export to Excel first release Flow Flow features free disk space on servers using powershell Friendly URLs and Managed Navigation in SharePoint 2013 get a list of site collection with template in web application using PowerShell Script in SharePoint Get attachments in SharePoint custom list using c# get current list item id sharepoint programmatically Get current url using jquery Get data from SharePoint list using Rest api & Angular JS Get Random Get Random SharePoint items using PowerShell Get Random values from SharePoint list using PowerShell Get url of the last value using jquery Get-SPOSite : The managed path sites/yoursitename is not a managed path in this tenant. Getting Email From User Hide “Edit Links” in left navigation SharePoint 2013 hide button in sharepoint based on permissions Hide column in SharePoint List view hide fields using client side object model Hide list in Quick Launch in SharePoint using PowerShell How to add Custom Tiles to SharePoint site Page. How to add extension files in Search Navigation in SharePoint 2013 How to Add Multiple users Using SharePoint People Picker How to add SharePoint list view in Page using C# How to Approve MasterPage using PowerShell in SharePoint How to bind Multiple users Using SharePoint People Picker how to change indicators on kpi performance how to check if an email address already exists in the database in asp.net how to configure workflow manager platform for SharePoint 2013 how to create calculated value using powershell how to create certificate in SharePoint How to create flow. how to create gantt chart webpart in sharepoint how to create KPI indicators in Dashboard designer How to create moden communication site in SharePoint online How to create Multi selected filter in Dashboard How to create nintex workflow in sharepoint how to create rdlc reports in asp.net How to Display Data Grid View in ASP.net How to enable anonymous access in SharePoint How to find data in datagridview in c# How to get image names from the folder using C# how to get particular list content type id in SharePoint 2013 How to get QueryString value in SharePoint WebPart Programatically how to get the current item id for newly created item using REST API and JQuery how to hide list in sharepoint how to know who created list in sharepoint How to make a Site Collection Read-Only in SharePoint 2010 How to overlay Office 365 shared calendar on SharePoint Site how to pass jquery value to asp.net textbox control How to pass pagename as a browser's title bar in the page how to remove unused Application Pool in SharePoint how to remove zone using powershell script How to send mail to particular group of people using PowerShell how to update modified by and created by using powershell how to uplaod RAR files in blogger import csv data into sharepoint import data using powershell Import group to term store management using SharePoint 2013. InfoPath InfoPath Cascading Dropdown list Insert update delete in datagridview in C# winforms Integration from SharePoint to k2. K2 Smart Forms for SharePoint JavaScript Injection jquery JSON K2 blackpearl K2 Designer K2 Designer Workflow. K2 smartform cascading dropdown list k2 Workflow K2 workflow to send a mail with PDF left navigation Local Term Set in managed meta data Managed meta data navigation in SharePoint 2013 Managed metadata service in SharePoint 2013. Managed Navigation in SharePoint 2013. Managed Promoted Sites. meta data navigation Microsoft Flow New Features New-SPConfigurationDatabase The user does not exist or is not unique NintexWorkFlow Office 365 OneDrive OneNote overwrite existing document in sharepoint using javascript PDF Converter PDF Method in K2 Performance Point Service in SharePoint 2013 PerformancePoint Services Configurtion PerformancePoint Services Configurtion for SharePoint 2013 PerformancePoint Services in SharePoint Server 2013 Popularity trends in SharePoint 2013 Pages populate dropdown list dynamicallyusing jquery Power Power Automate Power Shell Power shell script to get SharePoint site size. PowerApps powershell read xml PowerShell Script PowerShell script to get list of users from SharePoint groups PowerShell Scripts in SharePoint 2013 Powershell to set the masterpage in SharePoint Promoted Links Promoted Sites psconfig.exe quick launch Rdlc reports Readonly Column in SharePoint Editview Realtime DotNet Interview Questions Recent Dotnet interview questions Recent SharePoint interview questions recover deleted OneNote page. OneNote content is missing Regional Settings in SharePoint 2013 Replace New Item text in SharePoint Rest API Schedule PowerShell Script Search in SharePoint 2013 Search navigation in SharePoint 2013 Secure store service SecureStore Services SecureStore Services configuration for SharePoint 2013 self-signed certificate on IIS Server Send email to members of SharePoint Group using PowerShell sharepint2010 sharepoin2010 SharePoint 2013 SharePoint 2010 SharePoint 2013 SharePoint 2013 Dashboard Designer SharePoint 2013 features SharePoint 2013 Interview Questions SharePoint 2013. SharePoint 2013.disable views from user to create SharePoint 2013.Power shell SharePoint 2013.SharePoint 2010 SharePoint 2016 SharePoint Administration SharePoint Alerts and Reminders SharePoint App Configuration SharePoint Apps SharePoint Bulk upload SharePoint Calculated field SharePoint Calendar View sharepoint interview questions SharePoint online interview questions SharePoint online training SharePoint Onprem vs Online SharePoint RealTime Online Training SharePoint2010 SharePoint2013 SharePoint2016 SharePointInterview SharePointOnline SharePointOnline;Restore deleted site;SharePoint 2013 show data in datagridview in C# Simple Insert update Delete Retrieve Clear in asp.net. Site Collection Operations in SharePoint 2013 Site Collection Read-Only in SharePoint 2013 site contents Sorting & Filtering SPO SPSite Site Collection Operation parameters in SharePoint 2013 Step by step to create rdlc report in .Net Store names in text files in C# Sub site Subsite Term store management. The server was unable to save the form at this time. please try again UI New look update created by using client side object model update field values in SharePoint using powershell update items in SharePoint list using client object model update modified by field using client side object model upload zip files in blog use IsNullOrEmpty in PowerShell VirtoSoftware VirtoSofware vitrosoftware WebParts what is Document Set in SharePoint 2010 What is Filter in SharePoint Dashboard what is Limited-access user permission lock down mode feature What is Modern Team site What is Target Audience in SharePoint Who Created Site Using PowerShell Workflow in SharePoint 2013 Workflow management platform in SharePoint 2013 Workflow manager for SharePoint 2013 XSL-Template.