ComboBox in Datagridview in vb.net2005

[mafaisal]

Hello

I am Using vb.net2005
My Doubt is When i bind database to datagridview how to create combobox in that
my code is
StrSQL = "Select SlNo,Fname,Relation,Age,gender,Others From EmpDet a,EmpMast b Where a.Id = b.Id And b.Id = " & Val(TxtID.Text) & " "
Dap = New OleDb.OleDbDataAdapter(StrSQL, Con)
Dap.Fill(DstDet, "DstDet")
DGView.DataSource = DstDet
DGView.DataMember = "DstDet"

here the colum of gender coming in Combobox hw that is created...?

[dip_developer]

Hello

I am Using vb.net2005
My Doubt is When i bind database to datagridview how to create combobox in that
my code is
StrSQL = "Select SlNo,Fname,Relation,Age,gender,Others From EmpDet a,EmpMast b Where a.Id = b.Id And b.Id = " & Val(TxtID.Text) & " "
Dap = New OleDb.OleDbDataAdapter(StrSQL, Con)
Dap.Fill(DstDet, "DstDet")
DGView.DataSource = DstDet
DGView.DataMember = "DstDet"

here the colum of gender coming in Combobox hw that is created...?

just create a dataset with another sql query which selects the gender....and set the datasource of the combo to that dataset...

see how....

 public DataSet PopulateDropDownList() 
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDatabase"].ConnectionString);
SqlDataAdapter ad = new SqlDataAdapter("SELECT DISTINCT gender FROM EmpDet", myConnection);
DataSet ds = new DataSet();
ad.Fill(ds, "tblgender");
return ds; 
}
 

Now let's see where we call this method...........

 
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSource="<%# PopulateDropDownList() %>" 
DataTextField="Gender" DataValueField = "GenderID">
</asp:DropDownList>
</ItemTemplate>
 
 

[mafaisal]

Hello

Thanx for reply
ok i under stand
My Prob is When we Bind dataset to datagridview i think all column as
datagridviewtextboxcolumn then hw to make datagridviewcomboboxcolumn in gendercolumn

Faisal

just create a dataset with another sql query which selects the gender....and set the datasource of the combo to that dataset...

see how....

 public DataSet PopulateDropDownList() 
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDatabase"].ConnectionString);
SqlDataAdapter ad = new SqlDataAdapter("SELECT DISTINCT gender FROM EmpDet", myConnection);
DataSet ds = new DataSet();
ad.Fill(ds, "tblgender");
return ds; 
}
 

Now let's see where we call this method...........

 
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSource="<%# PopulateDropDownList() %>" 
DataTextField="Gender" DataValueField = "GenderID">
</asp:DropDownList>
</ItemTemplate>