I am Trying to Search Record and Display in GridView

John Joe

I am trying to search the record and display in GridView But I am getting an error : Object reference not set to an instance of an object.

How do I solve this?

{
public partial class Search_Course : System.Web.UI.Page
{
public SqlConnection con;
string constr;
public void connection()
{
constr = ConfigurationManager.ConnectionStrings ["Records"].ToString();
con = new SqlConnection(constr);
con.Open();
}
protected void Page_Load(object sender, EventArgs e)
{
Label1.Visible = false;
}
private void rep_bind()
{
connection();
string query = "select * from Records where Name like'" + TextBox1.Text + "%'";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Search_Click(object sender, EventArgs e)
{
connection();
string query = "select Name from Records where Name like'" + TextBox1.Text + "%'";
SqlCommand com = new SqlCommand(query, con);
SqlDataReader dr;
dr = com.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
rep_bind();
GridView1.Visible = true;
TextBox1.Text = "";
}
else
{
GridView1.Visible = false;
Label1.Visible = true;
Label1.Text = "The search Term " + TextBox1.Text + " Is Not Available in the Records"; ;
}
}
}
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

John Joe13y ago
connection(); str = "select * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.Records') and name like '" + "%" + TextBox1.Text + "%" + "'"; cmd = new SqlCommand(str, con); int count = Convert.ToInt32(cmd.ExecuteScalar()); if (count > 0) { bind(); GridView1.Visible = true; } else { Label1.Text = "The search Term " + TextBox1.Text + " Is Not Available in the Records"; ; GridView1.Visible = false; } } private void bind() { connection(); string query = "select * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.Records') and name like '" + "%" + TextBox1.Text + "%" + "'"; cmd = new SqlCommand(str, con); sqlda = new SqlDataAdapter(cmd); ds = new DataSet(); sqlda.Fill(ds, "Records"); con.Close(); GridView1.DataSource = ds; GridView1.DataMember = "Records"; GridView1.DataBind(); __________________________________ I have tried this code ... but it doesnt display the search result even thought the word exist in the database... it only display the else message, that the record does not exist: I am not sure where i am doing it wrong.
Satyapriya Nayak13y ago
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Search_Record_Display_in_GridView._Default" %>

    Untitled Page









            onclick="btn_search_Click" />




using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Search_Record_Display_in_GridView
{
    public partial class _Default : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand cmd;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;

        protected void btn_search_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            str = "select * from emp where name like '" + TextBox1.Text + "%'";
            cmd = new SqlCommand(str, conn);
            int count = Convert.ToInt32(cmd.ExecuteScalar());
            if (count > 0)
            {
                bind();
                GridView1.Visible = true;
            }
            else
            {
                Response.Write("No records found");
                GridView1.Visible = false;
            }
        }

        private void bind()
        {
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            str = "select * from emp where name like '" + TextBox1.Text + "%'";
            cmd = new SqlCommand(str, conn);
            sqlda = new SqlDataAdapter(cmd);
            ds = new DataSet();
            sqlda.Fill(ds, "emp");
            conn.Close();
            GridView1.DataSource = ds;
            GridView1.DataMember = "emp";
            GridView1.DataBind();
        }
    }
}
John Joe13y ago
I am getting errors ...

string query = "select ColumnName from Records where ColumnName like'" + TextBox1.Text + "%'";

I have a record but I dont know how to get or create Column Name

Faculty
University
Course

a
ac
cb

b
ab
cc
Satyapriya Nayak13y ago
http://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/
Vaibhav Kanase13y ago
you have to add connection string in web.config file like :

providerName="System.Data.SqlClient" />

Faculty	University	Course
a	ac	cb
b	ab	cc