Click here to Skip to main content
       

.NET Framework

 
GeneralRe: Converting from base10 to base16 and save it in unsigned char array? PinmvpRichard MacCutchan19-Sep-12 11:52 
QuestionWhat is Common Type System (CTS) in .net framework? Pinmemberhiredotnet16-Sep-12 19:48 
AnswerRe: What is Common Type System (CTS) in .net framework? PinprotectorPete O'Hanlon16-Sep-12 19:56 
AnswerRe: What is Common Type System (CTS) in .net framework? PinmemberHimanshu Yadav20-Sep-12 8:11 
AnswerRe: What is Common Type System (CTS) in .net framework? PinmemberTadit Dash22-Sep-12 19:01 
QuestionMain components of .NET Framework Pinmemberhiredotnet16-Sep-12 19:45 
RantRe: Main components of .NET Framework PinmemberPaul Conrad16-Sep-12 19:48 
Questioni m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberRashid Choudhary13-Sep-12 22:27 
i have a drop down list which have three entry.when i select every entry of dropdownlist then the data show into the gridview...my code behind page is
 

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Net.Mail;
using System.IO;
using System.ComponentModel;
using System.Drawing;
using System.Web.SessionState;
 
namespace AccountManagement
{
    public partial class Account : System.Web.UI.Page
    {
        SqlConnection con;
       SqlDataAdapter da;
        SqlDataReader dr;
        //DataSet ds1;
       // String Sql;
        //int Count;
        DataTable dt;
        SqlCommand cmd;
        protected void Page_Load(object sender, EventArgs e)
        {
            string s = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
            con = new SqlConnection(s);
            //if (!IsPostBack)
            //{
            //    bindgrid();
            //    bindlst();
            //}
            con.Open();
        }
 
        //protected void Button1_Click(object sender, EventArgs e)
        //{
        //    bindgrid();
        //    GridView1.Visible = true;
            
        //}
        public void bindgrid()
        {
            cmd=new SqlCommand ("select distinct Fname,Lname from Client_registration_tbl",con);
            //ds1 = new DataSet();
            con.Open();
            dr = cmd.ExecuteReader();
            //da.Fill(ds1);
            GridView1.DataSource = dr;
            GridView1.DataBind();
            GridView1.Visible = true;
            con.Close();
 
        }
 
        public void bindlst()
        {
            da = new SqlDataAdapter("select distinct Fname,Lname from Client_registration_tbl", con);
            dt = new DataTable();
            da.Fill(dt);
            DropDownList1.DataSource = dt;
            DropDownList1.DataBind();
        }
        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
 
            da = new SqlDataAdapter("select distinct Fname,Lname from Client_registration_tbl" + DropDownList1.SelectedItem.Text + "", con);
            dt = new DataTable();
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
           
            bindgrid();
            bindlst();
            //GridView1.Visible = true;
        }
 
      
 

    }
}
thanksss in advance
AnswerRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmvpRichard MacCutchan13-Sep-12 23:31 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberRashid Choudhary13-Sep-12 23:36 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinprotectorPete O'Hanlon13-Sep-12 23:40 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmvpRichard MacCutchan14-Sep-12 0:05 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinprotectorPete O'Hanlon14-Sep-12 0:28 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmvpRichard MacCutchan14-Sep-12 0:44 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberTadit Dash22-Sep-12 19:06 
AnswerRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberMeysam Tolouee14-Sep-12 9:01 
Questionbiztalk server Pinmembersrinuthippyreddy12-Sep-12 21:12 
AnswerRe: biztalk server PinmvpRichard MacCutchan12-Sep-12 22:13 
QuestionMultiple Column ComboBox in VB.Net Pinmembersivanesh.p12-Sep-12 2:49 
AnswerRe: Multiple Column ComboBox in VB.Net PinmemberBernhard Hiller12-Sep-12 3:51 
AnswerRe: Multiple Column ComboBox in VB.Net PinmvpDave Kreskowiak12-Sep-12 3:53 
AnswerRe: Multiple Column ComboBox in VB.Net Pinmemberhiredotnet16-Sep-12 19:41 
QuestionHow to disable No of copies in Print Dialog in C#.net Windows Application Pinmembersr1599-Sep-12 23:13 
AnswerRe: How to disable No of copies in Print Dialog in C#.net Windows Application PinmemberEddy Vluggen10-Sep-12 2:45 
AnswerRe: How to disable No of copies in Print Dialog in C#.net Windows Application PinprotectorPete O'Hanlon10-Sep-12 23:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140821.2 | Last Updated 22 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid