How can i solve this error of databinding in belove code.I use dropdownlist in grideview and in this dropdown when i select list item i want data in text box from two table how can solve this error.
SqlConnection con = new SqlConnection("Data Source=SERVER2;Initial Catalog=SHANGRILA2012-2013;Integrated Security=True");
SqlCommand com = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bindtestwebdata();
}
}
protected void Bindtestwebdata()
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT RoomMaster.Room_No, RoomMaster.Amount, RoomType.Description FROM RoomMaster INNER JOIN RoomType ON RoomMaster.RTID = RoomType.Code", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//DataTable dt = new DataTable();
da.Fill(ds);
con.Close() ...
Go to the complete details ...