How To Convert This Into Stored Procedure?

I have the following coe to populate combobox with data from different tables and I want to know how to convert it into stored procedure?



private void populate_drop_down()

{

try

{

//ensure the box is cleared

cboIDType.Items.Clear();

cboNationality.Items.Clear();

cboCountry.Items.Clear();

cboGender.Items.Clear();

cboMaritalStatus.Items.Clear();

cboBloodGroup.Items.Clear();

cboProfession.Items.Clear();

cboCompany.Items.Clear();

cboBloodGroup.Items.Add("");

cboProfession.Items.Add("");

cboCompany.Items.Add("");

//Use the SQLServer provider..

//set up the connection and the command...

// sql_connection = new SqlConnection("server=JASSIM-PC\SQLEXPRESS;Trusted_Connection=yes;database=shefa;connection timeout=30");

string strSQL = "SELECT id_type FROM id_type SELECT country_name FROM iso_country SELECT gender_title FROM gender SELECT marital_status FROM marital_status SELECT blood_group FROM blood_group SELECT profession_title FROM profession SELECT account_name FROM accounts";

sql_command = new SqlCommand(strSQL, sql_connection);

//open the connection, and use the reader to populate the combobox

// sql_connection.Open();

sql_reader = sql_command.ExecuteReader();

if (sql_reader != null)

{

// while (sql_reader.Read())

// {

// cboIDType.Items.Add(sql_reader["id_type"]);

// }

while (sql_reader.Read())

{

cboIDType.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("id_type")));

}



sql_reader.NextResult();



while (sql_reader.Read())

{

cboNationality.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("country_name")));

cboCountry.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("country_name")));

}

sql_reader.NextResult();

while (sql_reader.Read())

{

cboGender.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("gender_title")));

}

sql_reader.NextResult();

while (sql_reader.Read())

{

cboMaritalStatus.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("marital_status")));

}

sql_reader.NextResult();

while (sql_reader.Read())

{

cboBloodGroup.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("blood_group")));

}

sql_reader.NextResult();

while (sql_reader.Read())

{

cboProfession.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("profession_title")));

}

sql_reader.NextResult();

while (sql_reader.Read())

{

cboCompany.Items.Add(sql_reader.GetString(sql_reader.GetOrdinal("account_name")));

}

}



//the finally clause will tidy up for us.

cboIDType.Text = "CPR";

cboNationality.Text = "BAHRAIN";

cboCountry.Text = "BAHRAIN";

cboGender.Text = "MALE";

cboMaritalStatus.Text = "SINGLE";

cboBloodGroup.SelectedIndex = 0;

cboProfession.Text = "";

cboCompany.Text = "";

}

catch (Exception oE)

{

MessageBox.Show("Problem Populating Reader Box: [" + oE.ToString() + "]");

}

finally

{

if (sql_reader != null) sql_reader.Close();

if (sql_connection != null)

{

if (sql_connection.State == ConnectionState.Open)

sql_connection.Close();

}

}

}