Retrieve data from database using ComboBox to GridView

Bineesh Viswanath

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted 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 Viswanath13y ago
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 Hussain13y ago
Now is it working or not?

Regards,
Iftikar
Bineesh Viswanath13y ago
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 Hussain13y ago
try like this

DataRowView dataRow = cmbHouseNumber.SelectedItem as DataRowView;
var houseNumber = dataRow.Row.ItemArray[0];

Regards,
Iftikar
Bineesh Viswanath13y ago
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 Hussain13y ago
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