Fetch values from gridview in dropdownlist using c#

Question

hello everyone;

i want to fetch values of "patient reg code" from gridview of "clinic patient registration" and place in the dropdownlist of "patient reg code" of "opd info". remember "clinic patient registration" and "opd info" are two forms in asp.net." and "patient reg code" is a source values of gridview. i am sending screen shot of my problem . you can take help from this.

regards
sumaira

Answer 1

Hi Sumaira,


Try this...


using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    string str;
    SqlCommand com;
    protected void Page_Load(object sender, EventArgs e)
    {
       
        SqlConnection con = new SqlConnection(strConnString);

        if (!IsPostBack)
        {
            DropDownList1.Items.Add("Choose");
            con.Open();
            str = "select * from clinic patient registration";
            com = new SqlCommand(str, con);
            SqlDataReader reader = com.ExecuteReader();
            while (reader.Read())
            {
                DropDownList1.Items.Add(reader["patient reg code"].ToString());
            }
            reader.Close();
            con.Close();
        }
    }
  
}



Thanks

Answer 2

thanks sir