Click here to Skip to main content

.NET Framework

 
QuestionRe: resizing a form in corner, bottom,right PinmemberEddy Vluggen21-Sep-12 7:20 
QuestionLookup table .NET Component PinmemberHentoDeluxe21-Sep-12 6:26 
AnswerRe: Lookup table .NET Component PinmemberEddy Vluggen21-Sep-12 7:19 
QuestionConverting from base10 to base16 and save it in unsigned char array? PinmemberKiran Satish19-Sep-12 11:06 
AnswerRe: Converting from base10 to base16 and save it in unsigned char array? PinmvpRichard MacCutchan19-Sep-12 12:28 
GeneralRe: Converting from base10 to base16 and save it in unsigned char array? PinmemberKiran Satish19-Sep-12 12:36 
GeneralRe: Converting from base10 to base16 and save it in unsigned char array? PinmvpRichard MacCutchan19-Sep-12 12:52 
QuestionWhat is Common Type System (CTS) in .net framework? Pinmemberhiredotnet16-Sep-12 20:48 
AnswerRe: What is Common Type System (CTS) in .net framework? PinprotectorPete O'Hanlon16-Sep-12 20:56 
AnswerRe: What is Common Type System (CTS) in .net framework? PinmemberHimanshu Yadav20-Sep-12 9:11 
AnswerRe: What is Common Type System (CTS) in .net framework? PinmemberTadit Dash22-Sep-12 20:01 
QuestionMain components of .NET Framework Pinmemberhiredotnet16-Sep-12 20:45 
RantRe: Main components of .NET Framework PinmemberPaul Conrad16-Sep-12 20:48 
Questioni m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberRashid Choudhary13-Sep-12 23: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 MacCutchan14-Sep-12 0:31 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberRashid Choudhary14-Sep-12 0:36 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinprotectorPete O'Hanlon14-Sep-12 0:40 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmvpRichard MacCutchan14-Sep-12 1:05 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinprotectorPete O'Hanlon14-Sep-12 1:28 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmvpRichard MacCutchan14-Sep-12 1:44 
GeneralRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberTadit Dash22-Sep-12 20:06 
AnswerRe: i m new in asp.net. and i want 2 call a gridview by dropdownlist. PinmemberMeysam Tolouee14-Sep-12 10:01 
Questionbiztalk server Pinmembersrinuthippyreddy12-Sep-12 22:12 
AnswerRe: biztalk server PinmvpRichard MacCutchan12-Sep-12 23:13 
QuestionMultiple Column ComboBox in VB.Net Pinmembersivanesh.p12-Sep-12 3:49 
AnswerRe: Multiple Column ComboBox in VB.Net PinmemberBernhard Hiller12-Sep-12 4:51 
AnswerRe: Multiple Column ComboBox in VB.Net PinmvpDave Kreskowiak12-Sep-12 4:53 
AnswerRe: Multiple Column ComboBox in VB.Net Pinmemberhiredotnet16-Sep-12 20:41 
QuestionHow to disable No of copies in Print Dialog in C#.net Windows Application Pinmembersr15910-Sep-12 0:13 
AnswerRe: How to disable No of copies in Print Dialog in C#.net Windows Application PinmemberEddy Vluggen10-Sep-12 3:45 
AnswerRe: How to disable No of copies in Print Dialog in C#.net Windows Application PinprotectorPete O'Hanlon11-Sep-12 0:27 
QuestionRegarding datamining Pinmembervinu Rajendran9-Sep-12 21:03 
AnswerRe: Regarding datamining PinmemberEddy Vluggen10-Sep-12 3:46 
QuestionC# .Net windows application unable to open MS Access Database Connection in windows server 2003 Pinmemberankit_1987_96-Sep-12 0:04 
AnswerRe: C# .Net windows application unable to open MS Access Database Connection in windows server 2003 PinmemberEddy Vluggen6-Sep-12 0:48 
Generaloptiontips.in Pinmemberoptiontips.in4-Sep-12 22:26 
AnswerRe: optiontips.in PinmemberEddy Vluggen4-Sep-12 22:58 
QuestionObtain Summary Values from GridView Control in vb.Net?? PinmemberPriyanka Jain4-Sep-12 20:39 
AnswerRe: Obtain Summary Values from GridView Control in vb.Net?? PinmemberEddy Vluggen4-Sep-12 22:55 
AnswerRe: Obtain Summary Values from GridView Control in vb.Net?? PinmemberDurgeshyadav201211-Sep-12 0:20 
QuestionXML Deserializing Button.Color PinmemberDan Orr4-Sep-12 20:20 
AnswerRe: XML Deserializing Button.Color PinmemberEddy Vluggen4-Sep-12 22:54 
QuestionBest way to understand .Net Framework!? PinmemberTanajee Vaghmare4-Sep-12 7:34 
AnswerRe: Best way to understand .Net Framework!? PinmemberEddy Vluggen4-Sep-12 7:42 
QuestionCustom Tool and Designer Serializer PinmemberMdallal842-Sep-12 3:17 
GeneralRazor Engine Pinmemberalbarhami1-Sep-12 21:45 
GeneralRe: Razor Engine PinmemberEddy Vluggen1-Sep-12 22:50 
GeneralRe: Razor Engine PinmvpDave Kreskowiak2-Sep-12 5:45 
QuestionRazor engine (MVC) Pinmemberalbarhami1-Sep-12 21:44 
Questionhow to create database with sql connection in vb.net Pinmembermamnafih31-Aug-12 2:05 

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
Web03 | 2.8.150224.1 | Last Updated 25 Feb 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid