how to get data using one column through data reader into gridview

Posted by Kishore463 under ASP.NET on 7/24/2013 | Points: 10 | Views : 1748 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

is it posible to get data from database into data reader and data give to gridview using where statement in select query

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 7/25/2013 [Member] [MVP] Platinum | Points: 25

0	Hi Kishore, I think we can do by using WHERE condition in the SQL query itself... Look into the following code... [code] protected void Page_Load(object sender, EventArgs e) { string LastName = ""; //Pass on your string value if (!IsPostBack) { BindGrid(LastName); } } private DataTable GetRecords(string LastName) { // Fill in your database details; else use web.config method string strConnection = "SERVER=XXXXX;Database=XXXXX;User Id=XXXX;Password=XXXXX"; SqlConnection conn = new SqlConnection(strConnection); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = *"Select from DotNet.Employees where last_name = '" + LastName + "';"; SqlDataAdapter dAdapter = new SqlDataAdapter(); dAdapter.SelectCommand = cmd; DataSet objDs = new DataSet(); dAdapter.Fill(objDs); return objDs.Tables[0]; } private void BindGrid(string bndLastName) { DataTable dt = GetRecords(bndLastName); if (dt.Rows.Count > 0) { grdSearch.DataSource = dt; grdSearch.DataBind(); } }[/code] Note: Alternate method is to use GridView along with Search Button Mark This Response as Answer** -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Kishore463, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Kishore,

I think we can do by using WHERE condition in the SQL query itself... Look into the following code...
[code]
protected void Page_Load(object sender, EventArgs e)
{
string LastName = ""; //Pass on your string value
if (!IsPostBack)
{
BindGrid(LastName);
}
}

private DataTable GetRecords(string LastName)
{
// Fill in your database details; else use web.config method
string strConnection = "SERVER=XXXXX;Database=XXXXX;User Id=XXXX;Password=XXXXX";
SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select * from DotNet.Employees where last_name = '" + LastName + "';";
SqlDataAdapter dAdapter = new SqlDataAdapter();
dAdapter.SelectCommand = cmd;
DataSet objDs = new DataSet();
dAdapter.Fill(objDs);
return objDs.Tables[0];

}
private void BindGrid(string bndLastName)
{
DataTable dt = GetRecords(bndLastName);
if (dt.Rows.Count > 0)
{
grdSearch.DataSource = dt;
grdSearch.DataBind();
}
}[/code]
Note: Alternate method is to use GridView along with Search Button

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Kishore463, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Satyapriyanayak on: 7/25/2013 [Member] [MVP] Silver | Points: 25

0	<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Gridview_reader._Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> </div> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br/> <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" /> </form> </body> </html> 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 Gridview_reader { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; string str; protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connStr); str = "select * from employee where EmpId like '" + TextBox1.Text + "%'"; com = new SqlCommand(str, con); con.Open(); SqlDataReader reader; reader = com.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); reader.Close(); con.Close(); } } } If this post helps you mark it as answer Thanks Kishore463, if this helps please login to Mark As Answer. \| Alert Moderator

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Gridview_reader._Default" %>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

        <asp:GridView ID="GridView1" runat="server">

        </asp:GridView>

    

    </div>

    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br/>

    <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />

    </form>

</body>

</html>





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 Gridview_reader

{

    public partial class _Default : System.Web.UI.Page

    {

        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        SqlCommand com;

        string str;



      

        protected void Button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection(connStr);

          

            str = "select * from employee where EmpId like '" + TextBox1.Text + "%'";

            com = new SqlCommand(str, con);

            con.Open();

            SqlDataReader reader;

            reader = com.ExecuteReader();

            GridView1.DataSource = reader;

            GridView1.DataBind();

            reader.Close();

            con.Close();

        }

    }

}

If this post helps you mark it as answer
Thanks

Kishore463, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts