| Author: Ronak Thakkar 27 Dec 2007 | Member Level: Gold | Rating:  Points: 2 |
Hi,
Hope this will help u a lot....
====== GridView Coding ====================
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddl1" DataTextField = "varBranchName" DataValueField = "intGLCode" runat="server" DataSource='<%#BindSource()%>' ></asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddl2" runat="server" ></asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:TextBox ID="txt1" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
================= Code Behind ===========================
public partial class Default3 : System.Web.UI.Page
{
SqlDataSource ds;
DataSet abc;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindSource();
abc.Clear();//Clear DataSet to clear the first column of gridview when page loads
GridView1.DataSource = abc;
GridView1.DataBind();
}
}
public DataSet BindSource()
{
abc = new DataSet();
string connectinstring = ConfigurationManager.ConnectionStrings["RestaurantConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectinstring);
con.Open();
string command = "Select intglcode,varBranchName from Branch_Mst";
SqlCommand cmdSelect = new SqlCommand(command);
cmdSelect.Connection = con;
SqlDataAdapter adp = new SqlDataAdapter(cmdSelect);
DataSet dsnew = new DataSet();
adp.Fill(dsnew);
abc = dsnew;
return abc;
}
protected void Button1_Click(object sender, EventArgs e)
{
// Here we have data in abc dataset. So first column would be filled
BindSource();
GridView1.DataSource = abc;
GridView1.DataBind();
}
}
Regards,
Ronak Thakkar
|
| Author: Mohan Kumar 27 Dec 2007 | Member Level: Diamond | Rating: Points: 2 |
hi,
Check this link.
http://www.datagridgirl.com/articles.aspx
|