Select the data from database

Question

I need visual studio c# coding my doubt is how to select data from sqlserver below the example model

My form is this

i need to select from database when i select author in combobox that related data display in next combobox i.e Bookname

when i select author that related bookname display in combo box my database model is below the picture

for example i select author name like "Balaguruswamy" i want display "Bookname" related from balaguruswamy i.e. java,C++,C these bookname will display in Combobox then i will select anyone display whole data

please help i need c# , sqlserver coding...

---

karthik

Answer 1

http://www.vbforums.com/showthread.php?540421-Tutorial-An-Introduction-to-the-ADO-NET-Entity-Framework

The C# version is at the top of the page, but it lost the screen designs that the VB version has kept.

Answer 2

Hi Karthik,

Hope this will be helpful.  Just change the SQL query to set the fetch the data based on the drop down box "Authors" selected value like , 

//Assuming your Author dropdown is ddlAuthor
string value = ddlAuthor.SelectedValue;

//Creating a new SQL command
SqlCommand command = new SqlCommand("select Bookname from tablename where Author = @author",connection);

//Adding the author parameter
command.Parameters.Add("@author",sqlDbType.Varchar32);

//Assigning the author parameter value
command.Parameters["@author"].Value = value;

//Creating a SQLReader

SqlDataReader drBooks = command.ExecuteReader();

//Assigning the fetched values to Books drop down
ddlBooks.DataSource = drBooks;
ddlBooks.DataValueField = "Bookname";
ddlBooks.DataTextField = "Bookname";
ddlBooks.DataBind();

---

Regards, Ram If you find the answer as helpful, Please vote as helpful.

Answer 3

thank u ram

---

karthik

Answer 4

Check

http://curah.microsoft.com/33929/how-to-do-crud-using-entity-framework-5

or

http://curah.microsoft.com/39543/crud-by-creating-sqldataadapter-when-you-cannot-use-entity-framework

chanmm

---

chanmm