How can i search the records based on Job Id and job title

Mas

6y1k.NET

Hello Memebers,

Here I am trying to seach the records based on Job title and job-ID...

Can any one guide me, Thank you in advance!!

Below is the ASPX code:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="tquestion.Default" %>
"http://www.w3.org/1999/xhtml">
"server">
"form1" runat="server">
"margin-left:100px;">
"width:600px; height:100px;">
"lblconsucttechscreen" runat="server" Font-Size="12px" Text="Conduct tech screens">
class="content-text">
"lblloadquestions" runat="server" Font-Size="11px" Width="132px" Text="Load questions from template">
"txtrolename" runat="server" Width="370px" placeholder="Type role name">
"btnload" runat="server" Text="Load" Width="65px" Height="25px" style="background-color:darkblue; color:white; font-family:'Segoe UI'; font-size:11px; border:1px solid #DCDCDC" OnClick="btnload_Click" />
class="content-text">
"lbljobid" runat="server" Font-Size="11px" Width="132px" Text="Load questions from template">
"txtjobid" runat="server" Width="370px" placeholder="Type job-id">
"btnload1" runat="server" Text="Load" Width="65px" Height="25px" style="background-color:darkblue; color:white; font-family:'Segoe UI'; font-size:11px; border:1px solid #DCDCDC" OnClick="btnload_Click" />

"GridView1" runat="server" AutoGenerateColumns="false" HeaderStyle-ForeColor="White" HeaderStyle-BackColor="#000099" >

"50px"

DataField="job_id" HeaderText="Job-id" />

"Jobtitle" ItemStyle-Width="90px" HeaderText="Job title" SortExpression="Jobtitle" />

"245px"

DataField="Jobdescription" HeaderText="Job description" />

"65px"

DataField="createdby" HeaderText="Created by" />

"120px"

DataField="createddate" HeaderText="Created date" />

CS code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
using System.Data;
using System.Configuration;
namespace tquestion
{
public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindGrid();
}
}
private void BindGrid()
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT job_id,Jobtitle, Jobdescription, createdby, createddate FROM questions"))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
}
protected void OnPaging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
this.BindGrid();
}
protected void btnload_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM questions WHERE Jobtitle = '@Jobtitle';"))
{
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
using (MySqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
txtrolename.Text = sdr["Jobtitle"].ToString();
}
con.Close();
}
}
}
}
}

6 Replies

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

Mas6y ago
Jignesh, Added the same...

But facing an issue

0
Jignesh Kumar6y ago
Hi Sam,

Please add space before where clause,
string MySql = "SELECT job_id, Jobtitle, Jobdescription, createdby, createddate FROM questions";
if(!string.IsNullOrEmpty(txtrolename.Text.Trim()))
{
MySql += " where Jobtitle Like @Jobtitle '%' ";
cmd.Parameters.AddWithValue("@Jobtitle", txtrolename.Text.Trim());
}
0
Salman Beg6y ago
Are you using MySql?
There is a problem in the Syntax as per the error.
Please check the syntax in MySql manual because i am not good at mysql
Thanks.
0
Mas6y ago
Hi Jignesh,

I am trying to use the same artical, But facing an issue in like statement...

private void loadquestions()
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand())
{
string MySql = "SELECT job_id, Jobtitle, Jobdescription, createdby, createddate FROM questions";
if(!string.IsNullOrEmpty(txtrolename.Text.Trim()))
{
MySql += "where Jobtitle Like @Jobtitle + '%'";
cmd.Parameters.AddWithValue("@Jobtitle", txtrolename.Text.Trim());
}
cmd.CommandText = MySql;
cmd.Connection = con;
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}

Can you please look into this...
0
Salman Beg6y ago
Hi. Are you getting any error? I think in btnload_Click method you added MySqlCommand you added @Jobtitle but you didn't added the parameters in the cmd. So you need to add like this, cmd.Parameters.AddWithValue("@Jobtitle",value);
0
Jignesh Kumar6y ago
Hi Sam,

Please use this link which will help you,
https://www.aspsnippets.com/Articles/Search-and-Filter-GridView-using-TextBox-and-Button-in-ASPNet-using-C-and-VBNet.aspx
0