<asp:GridView ID="bussgrid" runat="server" AutoGenerateColumns="False" BorderColor="Aqua" Width="520px" Height="143px" > <Columns> <asp:BoundField DataField="Member_Name" HeaderText="Name" HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple" SortExpression="Member_Name" /> <asp:BoundField DataField="CombinedId" HeaderText="MemberID" ReadOnly="True" HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple" SortExpression="CombinedId" /> <asp:BoundField DataField="IntroducerID" HeaderText="IntroducerID" HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple" SortExpression="IntoducerID" /> <asp:BoundField DataField="Placement_Side" HeaderText="Position" HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple" SortExpression="Placement_Side" /> <asp:TemplateField HeaderText="Introducer Name"> <ItemTemplate> <asp:Label ID="Intro_Name" runat="server"></asp:Label> <%--<asp:Literal ID="Intro_Name" runat="server" />--%> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>
protected void Button1_Click(object sender, EventArgs e) { string text = "select Member_Name,CombinedId,Gender,Member_DOB,[Placement_Side],[City],[Join_Date],IntroducerID,SponsorID from Member_registration where IntroducerID='" + TextBox1.Text + "' "; string text1 = text + " select Member_Name from Member_Registration where CombinedID='"+ TextBox1.Text +"'"; SqlCommand cmd = new SqlCommand(text1, connection); connection.Open(); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); bussgrid.DataSource = dt; bussgrid.DataBind(); } protected void bussgrid_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)