ASP.NET

public IncDetail oIncToSave
		{
			get 
			{
				if (Session["IncToSave"] == null) 
					return new IncDetail();
				else
					return (IncDetail)Session["IncToSave"];
			}
			set 
			{
				Session["IncToSave"] = value;
			}
		}

<br />
 if (!Page.IsPostBack)<br />
        {<br />
            String strConnection;<br />
            strConnection = ConfigurationManager.AppSettings["ConnectionString"];<br />
            OdbcConnection odbcConnection = new OdbcConnection(strConnection);<br />
            OdbcCommand odbcCommand = new OdbcCommand("select * from dadmccom order by Name", odbcConnection);<br />
            odbcConnection.Open();<br />
            OdbcDataReader rd = odbcCommand.ExecuteReader();<br />
            while (rd.Read())<br />
            {<br />
                ListItem listItem = new ListItem();<br />
                listItem.Text = rd["Name"].ToString();<br />
                listItem.Value = rd["Companyid"].ToString();<br />
                RadioButtonList1.Items.Add(listItem);<br />
            }<br />
<br />
            RadioButtonList1.SelectedIndex = 0;<br />
            OdbcCommand odbcCommand1=new OdbcCommand() ;<br />
            odbcCommand1 = new OdbcCommand("Select * from dadmitem where Companyid = " + RadioButtonList1.SelectedValue + " order by Itmdesc ", odbcConnection);<br />
            //OdbcDataReader rd1 = odbcCommand1.ExecuteReader();<br />
            OdbcDataAdapter oda = new OdbcDataAdapter(odbcCommand1);<br />
            DataSet ds = new DataSet();<br />
            oda.Fill(ds);<br />
            DropDownList1.DataSource = ds.Tables[0];<br />
            DropDownList1.DataTextField = ds.Tables[0].Columns["Sku"].ColumnName.ToString();<br />
            DropDownList1.DataValueField = ds.Tables[0].Columns["Itmdesc"].ColumnName.ToString();<br />
            DropDownList1.DataBind();<br />
       <br />
<br />