Search data from database

Garima Bansal

I want search a Id for example:

In database table i have GId like 1AGR2023 and want to search using textbox, if id is incorrect or not in database then message shown otherwise Details of related GId like (Name, Contact,Remarks,Status) fill in gridview.


    Enter your Id.:

2 Replies

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

Naimish Makwana3y ago

Accepted answer

Hello Garima,

Try below:

protected void btn_Submit_Click(object sender, EventArgs e)
{
    string inputId = txtid.Text.Trim(); // get the input id from textbox and trim any white spaces
    DataTable dt = GetDataFromDatabase(inputId); // retrieve data from database for the given id

    if (dt != null && dt.Rows.Count > 0) // if data is found for the given id
    {
        grdtrack.DataSource = dt; // bind the data to the gridview
        grdtrack.DataBind();
        grdtrack.Visible = true; // make the gridview visible
    }
    else // if data is not found for the given id
    {
        grdtrack.Visible = false; // hide the gridview
        // show a message to the user
        ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('No data found for the given id.');", true);
    }
}

private DataTable GetDataFromDatabase(string inputId)
{
    DataTable dt = new DataTable();

    string connectionString = "";
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        conn.Open();

        string query = "SELECT Name, Mobile_No, Details, Status FROM YourTableName WHERE GId = @GId";
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
            cmd.Parameters.AddWithValue("@GId", inputId);

            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
                da.Fill(dt);
            }
        }
    }

    return dt;
}

Thanks

Naimish Makwana

Sachin Singh3y ago

follow this



    Enter your Id.:
    
        
        
    



    
        



    
        
        
        
        
        

    


< asp:LabelID="lblMessage" runat="server" Text="Label" >

string cs= "your connection string";
protected void btn_Submit_Click(object sender, EventArgs e)
{
    string inputId = txtid.Text.Trim(); 
    DataTable dt = GetDetailsByGID(gid); 

    if (dt != null && dt.Rows.Count > 0) 
    {
        grdtrack.DataSource = dt; 
        grdtrack.DataBind();
        grdtrack.Visible = true; 
    }
    else 
    {
        grdtrack.Visible = false; 
        lblMessage.Text="No data available";
       
    }
}

private DataTable GetDetailsByGID(string gid)
{
    DataTable dt = new DataTable();

    
    using (SqlConnection conn = new SqlConnection(cs))
    {
        conn.Open();

        string query = "SELECT Name, Mobile_No, Details, Status FROM YourTableName WHERE GId = @GId";
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
            cmd.Parameters.AddWithValue("@GId", gid);

            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
                da.Fill(dt);
            }
        }
    }

    return dt;
}