label match is the condition for gridview

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

XML

<asp:GridView runat="server" ID="gvrecords"  AutoGenerateColumns="false"
HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="White" DataKeyNames="DocketNo" AllowPaging="True" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href ='<%#"UpdateDocket.aspx?DocketNo="+DataBinder.Eval(Container.DataItem,"DocketNo") %>'> <%#Eval("DocketNo") %>  </a>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Branch" HeaderText="Branch" />
<asp:BoundField DataField="Date" HeaderText="Date" />
<asp:BoundField DataField="PinCode" HeaderText="PinCode" />
<asp:BoundField DataField="Basis" HeaderText="Basis" />
<asp:BoundField DataField="To" HeaderText="To" />
<asp:BoundField DataField="ConsignorCode" HeaderText="ConsignorCode" />
<asp:BoundField DataField="Consigee" HeaderText="Consignee" />
<asp:BoundField DataField="PKTS" HeaderText="PKTS" />
<asp:BoundField DataField="ActWT" HeaderText="ActWt" />
<asp:BoundField DataField="ChargeWt" HeaderText="ChargeWt" />
<asp:BoundField DataField="TotalFreight" HeaderText="TotalFreight" />
<asp:BoundField DataField="GoodsType" HeaderText="GoodsType" />
<asp:BoundField DataField="CODamount" HeaderText="CODamount" />
</Columns>
</asp:GridView>

I have a label above this gridview which Shows me which branch is this I want that GridView Shows only that branch result which is the label.

Posted 20-Nov-14 20:40pm

Member 11111143

Add a Solution

Comments

King Fisher 21-Nov-14 2:44am

sorry,i can't catch you update your Question

Member 11111143 21-Nov-14 2:57am

User Details

<table border="1" style="border-collapse: collapse; width: 369px;" cellspacing="1">
<tr>
<td width="77" height="16" align="left" >Name:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_UserName" runat="server" Font-Bold="True"><br /></td>

<td width="77" height="16" align="left" >StaffCode:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_address" runat="server" Font-Bold="True"><br /></td>

<td width="77" height="16" align="left" >Branch:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_sal" runat="server" Font-Bold="True"><br /></td>

<td width="77" height="16" align="left" >Designation:</td>
<td width="77" height="16" align="left" > <asp:Label
ID="lbl_phone" runat="server" Font-Bold="True"><br /></td>
<td> <asp:TextBox ID="TextBox1" runat="server">

<script type="text/javascript">
// a startup script to get put everything in motion
window.setTimeout("ShowTime()", 1000);
</script>
</td>
</tr>
</table>
</div>
lbl_sal Shows me which Branch Does the user has login .I want to show only that branch gridview details . Sir How it is possible

King Fisher 21-Nov-14 3:03am

and what's your Query to bind the Gridview?

Laiju k 21-Nov-14 3:06am

grid has many rows then there shall be many branch

King Fisher 21-Nov-14 4:05am

why don't you modify your Query Based on Your Branch Name ?

Member 11111143 21-Nov-14 4:37am

public partial class Admin_Link : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridview();
}
}
protected void BindGridview()
{
SqlConnection con = new SqlConnection("data source = .\\sqlexpress; database = amitpandey;integrated security=SSPI");
con.Open();
SqlCommand cmd = new SqlCommand("select * from CreateDocket ", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);
con.Close();
DataSet ds = new DataSet();
da.Fill(ds);
gvrecords.DataSource = ds;
gvrecords.DataBind();
}

protected void gvrecords_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
SqlConnection con = new SqlConnection("data source = .\\sqlexpress; database = amitpandey;integrated security=SSPI");
con.Open();
SqlCommand cmd = new SqlCommand("select * from CreateDocket ", con);
gvrecords.PageIndex = e.NewPageIndex;
SqlDataAdapter da = new SqlDataAdapter(cmd);
con.Close();
DataSet ds = new DataSet();
da.Fill(ds);
gvrecords.DataSource = ds;
gvrecords.DataBind();
}

}
Sir ,Exactly this I want I want my Query based on Branch .how Shall I do that please tell me sir

Laiju k 21-Nov-14 22:33pm

select * from CreateDocket

don't use select * ,use column names

Member 11111143 21-Nov-14 22:57pm

Sir, how to do it please tell me.

Laiju k 21-Nov-14 23:54pm

select column1name,column2name,.. from CreateDocket

Member 11111143 22-Nov-14 0:26am

my question is far left behind sir, the problem is I want that the label branch to match the branch in gridview. The label value is US then it should show only records of US.

Laiju k 22-Nov-14 0:36am

are you getting value in label on pageload

Member 11111143 22-Nov-14 0:39am

yes sir label value comes from pageload

Laiju k 22-Nov-14 0:42am

what is the column name of branch in database

Member 11111143 22-Nov-14 0:44am

Branch is the column name and it is in the first entry

Laiju k 22-Nov-14 0:54am

I had added a solution below try it.Let me know it solved the problem.

Member 11111143 22-Nov-14 0:59am

yes sir I got it its working thanks

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Laiju k · Accepted Answer · 2014-11-21T18:48:00

Solution 1

select column1name,column2name,.. from CreateDocket where Branch='"+lbl_sal.Text+"'

instead of select * from CreateDocket

Accept Solution if it helped.

Posted 21-Nov-14 18:48pm

Laiju k

Updated 21-Nov-14 18:51pm

v2