dropdownlist inside the gridview

Question

hi

i have dropdownlist inside the gridview.i have bind the dropdownlist using RowDataBound event.

i want
set the default seleted text which comes from the dataset first column how can i do it

string qry2 = string.Empty;
qry2="select Paper_typename,Paper_name,papersize from legends.Paper_type inner join Paper_info on paper_type=Paper_typeid ";
ds11 = db.Executedataset(qry2);

i want to bind Paper_typename as selected for dropdown list

Niranjan Poddar · Answer

'> C# Code-------- SqlConnection con = new SqlConnection ( ConfigurationManager.ConnectionStrings[MyConn].ConnectionString ); SqlDataAdapter da; protected void Page_Load(object sender EventArgs e) { if ( !Page.IsPostBack ) { GetRecord ( ); } } public void GetPaperList (DropDownList CurDropdownlist ) { da = new SqlDataAdapter ( select * from Paper_Master con); DataTable dt = new DataTable ( ); da.Fill ( dt ); if ( dt.Rows.Count > 0 ) { CurDropdownlist.DataSource = dt; CurDropdownlist.DataValueField = PaparID; CurDropdownlist.DataTextField = Paper_Name; CurDropdownlist.DataBind ( ); } } public void GetRecord ( ) { da = new SqlDataAdapter ( select * from Paper_Master con ); DataTable dt = new DataTable ( ); da.Fill ( dt ); grdMain.DataSource = dt; grdMain.DataBind ( ); } protected void grdMain_RowDataBound ( object sender GridViewRowEventArgs e ) { if ( e.Row.RowType == DataControlRowType.DataRow ) { DropDownList ddl = ( DropDownList ) e.Row.FindControl ( ddlPaperName ); GetPaperList ( ddl ); } } Create Table for this Demo-----Just Execute this query CREATE TABLE [dbo].[Paper_Master]( [PaparID] [int] NOT NULL [Paper_Name] [varchar](50) NOT NULL [Company_name] [varchar](50) NULL CONSTRAINT [PK_Paper_Master] PRIMARY KEY CLUSTERED ( [PaparID] ASC )WITH (PAD_INDEX = OFF STATISTICS_NORECOMPUTE = OFF IGNORE_DUP_KEY = OFF ALLOW_ROW_LOCKS = ON ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] Please Try this Code