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 houseId,houseNumber,Address,phoneNumber,ownerName, 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 houseId,houseNumber,Address,phoneNumber,ownerName 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