dropdownlist

string s = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

private void bindtoddl()
{
SqlConnection con = new SqlConnection(s);
SqlCommand cmd = new SqlCommand("select FieldName from TableName", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "FieldName"; // FieldName of Table in DataBase
DropDownList1.DataValueField = "FieldName";
DropDownList1.DataBind();

}

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.Data.Odbc;

namespace FanaticsDen

{

public partial class frmNotes : System.Web.UI.Page

{

OdbcConnection odbcCon = new OdbcConnection(ConfigurationManager.AppSettings["FanaticsDen"]);

OdbcCommand odbcCmd = new OdbcCommand();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

FillUniversity();

FillGroup();

FillUnit();

FillFormat();

}

}

public void FillGroup()

{

string myXMLfile = Server.MapPath("~/Group.xml");

DataSet dsGroup = new DataSet();

try

{

dsGroup.ReadXml(myXMLfile);

ddlGroup.DataSource = dsGroup;

ddlGroup.DataValueField = "GroupId";

ddlGroup.DataTextField = "GroupName";

ddlGroup.DataBind();

ddlGroup.Items.Insert(0, "SELECT");

}

catch (Exception ex)

{

Response.Write(ex.ToString());

}

}

public void FillUniversity()

{

string myXMLfile = Server.MapPath("~/University.xml");

DataSet dsUniversity = new DataSet();

try

{

dsUniversity.ReadXml(myXMLfile);

ddluniversity.DataSource = dsUniversity;

ddluniversity.DataValueField = "UniversityId";

ddluniversity.DataTextField = "UniversityName";

ddluniversity.DataBind();

ddluniversity.Items.Insert(0, "SELECT");

}

catch (Exception ex)

{

Response.Write(ex.ToString());

}

}

public void FillUnit()

{

ddlUnit.Items.Add("0");

ddlUnit.Items.Add("1");

ddlUnit.Items.Add("2");

ddlUnit.Items.Add("3");

ddlUnit.Items.Add("4");

ddlUnit.Items.Add("5");

ddlUnit.Items.Add("6");

ddlUnit.Items.Add("7");

ddlUnit.Items.Add("8");

ddlUnit.Items.Add("9");

}

public void FillFormat()

{

ddlFormat.Items.Add("Audio");

ddlFormat.Items.Add("Vedio");

ddlFormat.Items.Add("Text");

}

protected void btnAdd_Click(object sender, EventArgs e)

{

string strSql = "insert into Notes(University,[Group],Subject,Unit,Topic,Format) Values('" + ddluniversity.Text

+ "','" + ddlGroup.Text + "','" + txtSubject.Text + "','" + ddlUnit.Text + "','" + txtTopic.Text + "','" + ddlFormat.Text + "')";

odbcCmd.CommandType = CommandType.Text;

odbcCmd.Connection = odbcCon;

odbcCmd.CommandText = strSql;

odbcCon.Open();

odbcCmd.ExecuteNonQuery();

odbcCon.Close();

}

protected void btnView_Click(object sender, EventArgs e)

{

Response.Redirect("frmViewState.aspx");

}

}

}