Reading Data From Database and Display in Label or other control

Reading Data From Database and Display in Label or other control

DataSet dtst = new DataSet();

        SqlConnection sqlCon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);

        string strSql = "SELECT FieldName FROM TableName WHERE FieldName LIKE '" + prefixText + "%' ";

        SqlCommand sqlComd = new SqlCommand(strSql, sqlCon);

        sqlCon.Open();

        SqlDataAdapter sqlAdpt = new SqlDataAdapter();

        sqlAdpt.SelectCommand = sqlComd;

        sqlAdpt.Fill(dtst);

        string[] cntName = new string[dtst.Tables[0].Rows.Count];

        int i = 0;

        try

        {

            foreach (DataRow rdr in dtst.Tables[0].Rows)

            {

                cntName.SetValue(rdr["CountryName"].ToString(), i);

                i++;

            }

        }

        catch { }

        finally

        {

            sqlCon.Close();

        }

        return cntName;