Retrieve data from database using ComboBox to GridView

Question

Sir I am in the function of search. My task is by using comboBox. here is my form. You can see the numbers in comboBox. These are the houseNumber saved in the database. here the way I saved data into database:- Like this I want search functions too. when I select a houseNumber from comboBox and click the search button I want the data to be filled in the above picture. please help me.

Iftikar Hussain · Answer

Modify your SP to return the value ALTER PROCEDURE houseNumberView @houseNumber int AS SELECT tbl_House.houseNumber tbl_House.Address tbl_House.phoneNumber tbl_House.ownerName tbl_House.Photo tbl_Person.personName tbl_Person.Age tbl_Person.Sex tbl_Person.Relation tbl_Person.Occupation tbl_House.Photo FROM tbl_House INNER JOIN tbl_Person ON tbl_House.houseId = tbl_Person.houseId in your code private void SearchHouse() { istring sql=select houseIdhouseNumberAddressphoneNumberownerName Photo from tbl_house where houseNumber=@houseNumber var houseNumber=ddlSearch.SelectedItem; if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlCmd = new SqlCommand(sql sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue(@houseNumber houseNumber); SqlDataReader reader=sqlCmd.ExecuteReader(); while (reader.Read()) { txtHouseNumber.Text=reader[houseNumber].ToString(); txtAddress.Text=reader[Address].ToString(); phoneNumber .Text=reader[phoneNumber].ToString(); txtowner.Text=reader[ownerName].ToString(); byte[] byteImageData = new byte[0]; byteImageData = (Byte[])(reader[Photo]); MemoryStream ms = new MemoryStream(b); pictureBox1.Image = Image.FromStream(ms); } reader.close(); if (sqlCon.State == ConnectionState.Open) sqlCon.Close(); } Regards Iftikar

Bineesh VP · Answer

Sir it still has error the error is in the retrieving data into datagridview. As my topic has changed to ASP.Net I left from that topic.

Iftikar Hussain · Answer

Now is it working or not? Regards Iftikar

Bineesh VP · Answer

Sir now the data send from textbox is being retrieved. Photo is being retrieved but not showing in the pictureBox. The gridview items not been retrieved. SQL SP for this function is :- ALTER PROCEDURE houseNumberView @houseNumber int AS SELECT tbl_House.houseNumber tbl_House.Address tbl_House.phoneNumber tbl_House.ownerName tbl_House.Photo tbl_Person.personName tbl_Person.Age tbl_Person.Sex tbl_Person.Relation tbl_Person.Occupation FROM tbl_House INNER JOIN tbl_Person ON tbl_House.houseId = tbl_Person.houseId the form's current state is:-

Iftikar Hussain · Answer

try like this DataRowView dataRow = cmbHouseNumber.SelectedItem as DataRowView; var houseNumber = dataRow.Row.ItemArray[0]; Regards Iftikar

Bineesh VP · Answer

Sir I just applied the code you gave. I write a separate function and called in the btnSearch_Click() Some data is being retrieved. but not reached the output end. Here is the error:-

Iftikar Hussain · Answer

Hi On the Search button click write query to filter data from House Info table private void SearchHouse() { istring sql=select houseIdhouseNumberAddressphoneNumberownerName from tbl_house where houseNumber=@houseNumber var houseNumber=ddlSearch.SelectedItem; if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlCmd = new SqlCommand(sql sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue(@houseNumber houseNumber); SqlDataReader reader=sqlCmd.ExecuteReader(); while (reader.Read()) { txtHouseNumber.Text=reader[houseNumber].ToString(); txtAddress.Text=reader[Address].ToString(); phoneNumber .Text=reader[phoneNumber].ToString(); txtowner.Text=reader[ownerName].ToString(); } reader.close(); if (sqlCon.State == ConnectionState.Open) sqlCon.Close(); } Regards Iftikar