dropdownlist inside the gridview

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

<%#Container.DataItemIndex+1 %>

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Niranjan Poddar12y ago

<%#Container.DataItemIndex+1 %>

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
0